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.
Maybe SQLite Is Still Better Than DuckDB for My Workloads
soytuber profile
soy

Maybe SQLite Is Still Better Than DuckDB for My Workloads

#database #sqlite #duckdb #sql
Comments
8 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
Understanding SQL Joins and SQL Functions, CTEs and Subqueries.
josengash profile

Understanding SQL Joins and SQL Functions, CTEs and Subqueries.

#beginners #database #sql #tutorial
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
SQLite CLI Prompts, PostgreSQL Load Balancing with pgkeeper, PgBouncer Tuning
soytuber profile
soy

SQLite CLI Prompts, PostgreSQL Load Balancing with pgkeeper, PgBouncer Tuning

#database #sql #sqlite
Comments
3 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
2
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
SQLite Internals & PostgreSQL Multi-Master Replication Updates
soytuber profile
soy

SQLite Internals & PostgreSQL Multi-Master Replication Updates

#database #sql #sqlite
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
👋 Sign in for the ability to sort posts by relevant, latest, or top.