DEV Community

select * from SQL

Posts on tips and tricks, using and learning about SQL for database development and analysis.

Posts

đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
The road to SeaQuery 1.0

The road to SeaQuery 1.0

2
Comments 1
11 min read
My Interview Experience & Questions Faced (Frontend + JavaScript + SQL)

My Interview Experience & Questions Faced (Frontend + JavaScript + SQL)

1
Comments
1 min read
A Sneak Peek at SeaORM 2.0

A Sneak Peek at SeaORM 2.0

Comments
7 min read
compare7

compare7

Comments
1 min read
compare3

compare3

Comments
1 min read
pg-status - a lightweight microservice for checking PostgreSQL host status

pg-status - a lightweight microservice for checking PostgreSQL host status

1
Comments
7 min read
HackerRank 'The Pads' MySQL

HackerRank 'The Pads' MySQL

Comments
3 min read
Why is offset pagination slow

Why is offset pagination slow

Comments
2 min read
How to Read SQL Server Execution Plans: 7 Things That Matter

How to Read SQL Server Execution Plans: 7 Things That Matter

4
Comments
10 min read
7 Best Resources to Learn SQL: My Journey from Confusion to Confidence

7 Best Resources to Learn SQL: My Journey from Confusion to Confidence

Comments
3 min read
From 40% to 100% SQL Generation Accuracy: Why Local AI Needs Self-Correction, Not Perfect Prompts

From 40% to 100% SQL Generation Accuracy: Why Local AI Needs Self-Correction, Not Perfect Prompts

1
Comments
4 min read
SQL Injection: The Security Nightmare Every Developer Must Understand

SQL Injection: The Security Nightmare Every Developer Must Understand

2
Comments
6 min read
QUICK SQL REVISION

QUICK SQL REVISION

1
Comments
14 min read
Track Blocking and Deadlocks in MSSQL with my custom script

Track Blocking and Deadlocks in MSSQL with my custom script

3
Comments
4 min read
Wait, what? PK is not needed for HABTM?

Wait, what? PK is not needed for HABTM?

Comments
2 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.