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.
Implementing temporal table auditing in software development projects

Implementing temporal table auditing in software development projects

Comments
8 min read
What’s the Difference Between Relational Databases and NoSQL?

What’s the Difference Between Relational Databases and NoSQL?

Comments
3 min read
How to Optimize Search Queries in Large Databases with PostgreSQL and GIN Indexes

How to Optimize Search Queries in Large Databases with PostgreSQL and GIN Indexes

Comments
4 min read
Normalization: How to Structure Your Database for Efficiency

Normalization: How to Structure Your Database for Efficiency

3
Comments
2 min read
Mastering SQL Server CONTAINS for Advanced Text Search

Mastering SQL Server CONTAINS for Advanced Text Search

Comments
1 min read
Twitter Stuck Signing Up? No Email, Phone Field Broken?

Twitter Stuck Signing Up? No Email, Phone Field Broken?

Comments
2 min read
Supercharge Your Jupyter Notebook: SQL Command Magic for IPython

Supercharge Your Jupyter Notebook: SQL Command Magic for IPython

Comments
3 min read
Study Notes 6.11-12: Kafka ksqlDB, Connect & Schema Registry

Study Notes 6.11-12: Kafka ksqlDB, Connect & Schema Registry

Comments
7 min read
🚀 Run PostgreSQL Directly in Your Browser or Node.js!

🚀 Run PostgreSQL Directly in Your Browser or Node.js!

Comments
1 min read
🚀 Mastering Unit of Work in SQLAlchemy: Efficient Transactions in 2025

🚀 Mastering Unit of Work in SQLAlchemy: Efficient Transactions in 2025

Comments
1 min read
🚀 SQL Query Optimization in 2025: 7 Techniques for Faster Performance

🚀 SQL Query Optimization in 2025: 7 Techniques for Faster Performance

Comments
1 min read
Top 3 PostgreSQL Performance Issues: Diagnosis and Proven Solutions

Top 3 PostgreSQL Performance Issues: Diagnosis and Proven Solutions

1
Comments
5 min read
Deduplicate between an uncertain number of columns:SQL VS SPL #15

Deduplicate between an uncertain number of columns:SQL VS SPL #15

10
Comments
2 min read
You, Too, Can Scale Postgres to 2 PB and 1 T Metrics per Day

You, Too, Can Scale Postgres to 2 PB and 1 T Metrics per Day

Comments
5 min read
𝗛𝗼𝘄 𝘁𝗼 𝗔𝘂𝘁𝗼𝗺𝗮𝘁𝗶𝗰𝗮𝗹𝗹𝘆 𝗨𝗽𝗱𝗮𝘁𝗲 𝗦𝗽𝗲𝗻𝘁 𝗔𝗺𝗼𝘂𝗻𝘁 𝗶𝗻 𝗕𝘂𝗱𝗴𝗲𝘁 𝗨𝘀𝗶𝗻𝗴 𝗧𝗿𝗶𝗴𝗴𝗲𝗿𝘀 𝗶𝗻 𝗦𝗤𝗟 𝗦𝗲𝗿𝘃𝗲𝗿

𝗛𝗼𝘄 𝘁𝗼 𝗔𝘂𝘁𝗼𝗺𝗮𝘁𝗶𝗰𝗮𝗹𝗹𝘆 𝗨𝗽𝗱𝗮𝘁𝗲 𝗦𝗽𝗲𝗻𝘁 𝗔𝗺𝗼𝘂𝗻𝘁 𝗶𝗻 𝗕𝘂𝗱𝗴𝗲𝘁 𝗨𝘀𝗶𝗻𝗴 𝗧𝗿𝗶𝗴𝗴𝗲𝗿𝘀 𝗶𝗻 𝗦𝗤𝗟 𝗦𝗲𝗿𝘃𝗲𝗿

Comments
1 min read
What is SQL? A Simple Introduction to Structured Query Language

What is SQL? A Simple Introduction to Structured Query Language

Comments
2 min read
I Made a Detective Game That Teaches You SQL

I Made a Detective Game That Teaches You SQL

5
Comments
2 min read
Getting Started with SQL DISTINCT

Getting Started with SQL DISTINCT

Comments
2 min read
Game-Changing Guide to SQL for SEO Optimization

Game-Changing Guide to SQL for SEO Optimization

Comments
6 min read
Types of Databases: Relational, NoSQL, and Beyond

Types of Databases: Relational, NoSQL, and Beyond

Comments
2 min read
The Dark Side of Building AI Agents with Poor Data Quality

The Dark Side of Building AI Agents with Poor Data Quality

Comments
4 min read
SQL Query Logical Order

SQL Query Logical Order

Comments
2 min read
PostgreSQL 🐘🔍 SQL Review and Style Guide 📇

PostgreSQL 🐘🔍 SQL Review and Style Guide 📇

6
Comments
16 min read
Why Databases Matter: Real-World Applications and Use Cases

Why Databases Matter: Real-World Applications and Use Cases

Comments
2 min read
How to Optimize a Slow Query

How to Optimize a Slow Query

Comments
2 min read
loading...