Forem

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
Cover image for 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
Cover image for 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
Cover image for 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
Cover image for 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
Cover image for 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
Cover image for 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
Cover image for 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
🚀 Understanding Indexing in Oracle (B-Tree, B+ Tree, Hash Cluster) Indexes are one of the most important concepts in databases.

🚀 Understanding Indexing in Oracle (B-Tree, B+ Tree, Hash Cluster) Indexes are one of the most important concepts in databases.

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