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.
How simultaneously swapping unique IDs in Postgres

How simultaneously swapping unique IDs in Postgres

4
Comments
2 min read
SeaORM 2.0: New Entity Format

SeaORM 2.0: New Entity Format

1
Comments
9 min read
Apache Ignite 3.1.0 is now available

Apache Ignite 3.1.0 is now available

Comments
2 min read
Why AI Analytics Tools Are Solving the Wrong Problem

Why AI Analytics Tools Are Solving the Wrong Problem

5
Comments 1
7 min read
cursor

cursor

Comments
3 min read
The Deterministic Problem with Probabilistic AI Analytics

The Deterministic Problem with Probabilistic AI Analytics

Comments
7 min read
DevPill 6 - SQLC: how to scaffold your database code

DevPill 6 - SQLC: how to scaffold your database code

Comments
1 min read
Devpill 4 - Database migrations with Migrate

Devpill 4 - Database migrations with Migrate

Comments 1
1 min read
Fixing SQL Injection Vulnerabilities to Strengthen Security

Fixing SQL Injection Vulnerabilities to Strengthen Security

Comments 2
10 min read
Generating Table Schema from AWS Glue Table

Generating Table Schema from AWS Glue Table

2
Comments
1 min read
How to Learn SQL for Data Analysis in 2026: A Free Learning Path

How to Learn SQL for Data Analysis in 2026: A Free Learning Path

Comments
2 min read
Learning .NET from Beginner to Advanced Level's

Learning .NET from Beginner to Advanced Level's

22
Comments 2
22 min read
Demystifying Normalization in RDBMS: From 1NF to 3NF

Demystifying Normalization in RDBMS: From 1NF to 3NF

Comments
5 min read
Understanding the Difference Between Subquery, CTE, and Stored Procedure

Understanding the Difference Between Subquery, CTE, and Stored Procedure

Comments
3 min read
💾 ACID Properties

💾 ACID Properties

Comments
2 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.