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 I cut Django indexing from 23 minutes to 11 minutes with one SQL change
n3mo-dev profile
N3MO

How I cut Django indexing from 23 minutes to 11 minutes with one SQL change

#django #performance #postgres #sql
1
Comments
1 min read
Inner vs Outer Joins: The Two Fundamental Join Types in SQL
michaelfv profile

Inner vs Outer Joins: The Two Fundamental Join Types in SQL

#gbase #database #数据库 #sql
2
Comments
1 min read
SQL for Developers: The Practical Guide (2026)
armorbreak profile

SQL for Developers: The Practical Guide (2026)

#beginners #database #sql #tutorial
1
Comments
6 min read
PostgreSQL Plan Signatures: Quick Reference
philip_mcclarence_2ef9475 profile

PostgreSQL Plan Signatures: Quick Reference

#database #performance #postgres #sql
Comments
7 min read
Delete record using JooqTemplate
javaer profile

Delete record using JooqTemplate

#database #java #sql #jooq
Comments
1 min read
SQL Formatting Best Practices: A Practical Guide for Engineers
moksh profile

SQL Formatting Best Practices: A Practical Guide for Engineers

#sql #database #webdev #productivity
4
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 7
20 min read
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
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
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
1
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
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.