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.
SQL vs. NoSQL: Key Differences Explained

SQL vs. NoSQL: Key Differences Explained

Comments 1
1 min read
SQL JOINs Explained: Connecting Data Across Tables

SQL JOINs Explained: Connecting Data Across Tables

Comments
6 min read
Hacker rank's Median SQL Solution

Hacker rank's Median SQL Solution

Comments
3 min read
DuckDB 🦆 : Libérez le puissant moteur de Requêtes

DuckDB 🦆 : Libérez le puissant moteur de Requêtes

Comments
8 min read
SQL vs NoSQL for Large Tables: Choosing the Right Database for Big Data Applications

SQL vs NoSQL for Large Tables: Choosing the Right Database for Big Data Applications

2
Comments
6 min read
(Beyond) The Art of Database Indexing

(Beyond) The Art of Database Indexing

Comments
3 min read
Desire for Structure (read “SQL”)

Desire for Structure (read “SQL”)

Comments
10 min read
How to Use esProc to Speed Up JOIN to Avoid Wide Tables

How to Use esProc to Speed Up JOIN to Avoid Wide Tables

6
Comments
6 min read
SQL Query Optimization for Data Engineers

SQL Query Optimization for Data Engineers

9
Comments
3 min read
How Indexes Really Work

How Indexes Really Work

Comments
5 min read
Postgres 🐘 vs. SQL Server: a Complete Comparison ⚖️ in 2025

Postgres 🐘 vs. SQL Server: a Complete Comparison ⚖️ in 2025

5
Comments
7 min read
What is SQL? A Simple Guide to Databases and Queries

What is SQL? A Simple Guide to Databases and Queries

1
Comments
1 min read
Implement an end-to-end RAG solution with watsonx.ai and Elasticsearch SQL

Implement an end-to-end RAG solution with watsonx.ai and Elasticsearch SQL

2
Comments
2 min read
SQL and I Had Beef 😂So I Built a Trigger

SQL and I Had Beef 😂So I Built a Trigger

1
Comments 1
2 min read
Oracle Database 23ai - CLOB to JSON Migration - Series Part2 | Stress Testing with Exhaustive Weather JSON Payloads

Oracle Database 23ai - CLOB to JSON Migration - Series Part2 | Stress Testing with Exhaustive Weather JSON Payloads

Comments
71 min read
Oracle Database 23ai - CLOB to JSON Migration Essentials - Series Part 1

Oracle Database 23ai - CLOB to JSON Migration Essentials - Series Part 1

Comments
13 min read
Como bancos de dados realmente salvam os dados

Como bancos de dados realmente salvam os dados

Comments
3 min read
Why I Built USPL: Helping GPT Understand Multi-Table SQL

Why I Built USPL: Helping GPT Understand Multi-Table SQL

Comments 1
2 min read
Build a Shared-Nothing Distributed Queue with SQLite and Python

Build a Shared-Nothing Distributed Queue with SQLite and Python

Comments
2 min read
Why uber ditched postgres for mysql: What every developer can learn from it

Why uber ditched postgres for mysql: What every developer can learn from it

2
Comments
46 min read
The Five Levels Of SQL

The Five Levels Of SQL

1
Comments 3
3 min read
Mastering Neon: A Pro's Guide to Using Serverless PostgreSQL

Mastering Neon: A Pro's Guide to Using Serverless PostgreSQL

2
Comments
3 min read
Calculate all the year/months included in the year/month interval — From SQL to SPL #15

Calculate all the year/months included in the year/month interval — From SQL to SPL #15

5
Comments 1
2 min read
How to simplify nested SQL in applications with esProc

How to simplify nested SQL in applications with esProc

11
Comments
4 min read
Comprehensive SQL Guide for Freshers and Intermediate Learners

Comprehensive SQL Guide for Freshers and Intermediate Learners

Comments
9 min read
loading...