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.
Databases & SQL Basics As A Beginner: A Practical Introduction

Databases & SQL Basics As A Beginner: A Practical Introduction

26
Comments 1
3 min read
CHW Monthly Activity Aggregation: Turning Visit Logs into Insight

CHW Monthly Activity Aggregation: Turning Visit Logs into Insight

Comments
5 min read
cursor5

cursor5

Comments
1 min read
I Built SQLTranslate: An AI-Powered Tool to Convert SQL Between Database Dialects

I Built SQLTranslate: An AI-Powered Tool to Convert SQL Between Database Dialects

Comments 1
2 min read
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
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.