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.
Automating SQL Server Database Administration with T-SQL Utility Scripts
dominic_robinson_ff89e6b5 profile

Automating SQL Server Database Administration with T-SQL Utility Scripts

#automation #database #opensource #sql
Comments
4 min read
REDB inside, part 1.1 — why the same 13 tables stay fast no matter how many classes you throw at them
rinat_kozin profile

REDB inside, part 1.1 — why the same 13 tables stay fast no matter how many classes you throw at them

#dotnet #postgres #sql #opensource
2
Comments 8
20 min read
The Hard Truth About Choosing a Database and Why Most Projects Get It Wrong
charity254 profile

The Hard Truth About Choosing a Database and Why Most Projects Get It Wrong

#database #buildinpublic #sql
1
Comments
4 min read
In some scenarios, relying on LLMs to generate SQL is neither rigorous nor reliable.Right way to teach LLMs to generate SQL is here
random_coco profile
Coco

In some scenarios, relying on LLMs to generate SQL is neither rigorous nor reliable.Right way to teach LLMs to generate SQL is here

#ai #sql #database #opensource
Comments
4 min read
Retention cohort analysis with plain SQL
zenovay profile

Retention cohort analysis with plain SQL

#sql #analytics #database #webdev
Comments
2 min read
I Shipped 12 BI Dashboards With 5 Different Tools. Here Is the Honest Comparison.
de_clerke profile

I Shipped 12 BI Dashboards With 5 Different Tools. Here Is the Honest Comparison.

#dataengineering #python #datascience #sql
3
Comments
9 min read
How to Migrate MySQL to PostgreSQL Without Breaking Everything (With Real Examples)
rehman_afzal_536 profile

How to Migrate MySQL to PostgreSQL Without Breaking Everything (With Real Examples)

#database #postgressql #mysql #sql
Comments
5 min read
Dynamically Generating SQL Joins for Tables Based on a Common Column
kaidanov profile

Dynamically Generating SQL Joins for Tables Based on a Common Column

#dba #sql #tutorial #productivity
Comments
7 min read
Automated SQL Migration Review with Real CLI Output (MySQL, PostgreSQL, TiDB)
fanduzi profile
Fan()

Automated SQL Migration Review with Real CLI Output (MySQL, PostgreSQL, TiDB)

#showdev #cli #database #sql
2
Comments
8 min read
Why Big Tech is Migrating from Traditional Databases to NewSQL
dinhphu2k1gif profile

Why Big Tech is Migrating from Traditional Databases to NewSQL

#bigdata #dataengineering #database #sql
1
Comments
1 min read
We Ran One SQL Query
 And Broke Production
cicd_samurai profile

We Ran One SQL Query
 And Broke Production

#devops #database #sql #security
Comments
3 min read
Heart Part 7 - dalCTF 2026
exploitnotes profile

Heart Part 7 - dalCTF 2026

#cybersecurity #security #sql #web
1
Comments
3 min read
PostgreSQL Query Anti-Patterns and Common Mistakes
philip_mcclarence_2ef9475 profile

PostgreSQL Query Anti-Patterns and Common Mistakes

#database #performance #postgres #sql
Comments 1
7 min read
Extended RUM in DocumentDB extension for PostgreSQL: Efficient ESR (Equality, Sort, Range) Queries
franckpachot profile

Extended RUM in DocumentDB extension for PostgreSQL: Efficient ESR (Equality, Sort, Range) Queries

#postgres #sql #document #database
Comments
7 min read
SQL Subqueries vs CTEs
venuskennedy profile

SQL Subqueries vs CTEs

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