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.
PostgreSQL Monitoring with pgEdge AI, Vector Search Trends & PLV8 Extensions

PostgreSQL Monitoring with pgEdge AI, Vector Search Trends & PLV8 Extensions

Comments
3 min read
Elasticsearch & Inverted Indices — The Death of SQL ILIKE (2026)

Elasticsearch & Inverted Indices — The Death of SQL ILIKE (2026)

Comments
2 min read
I built a browser-only SQL practice tool because installing DBeaver is a productivity tax

I built a browser-only SQL practice tool because installing DBeaver is a productivity tax

Comments
3 min read
Calling Stored Procedures in Entity Framework and Choosing the Right ORM Tool

Calling Stored Procedures in Entity Framework and Choosing the Right ORM Tool

Comments
3 min read
Créer un système d’authentification avec PHP et MySQL (étape par étape)

Créer un système d’authentification avec PHP et MySQL (étape par étape)

Comments
2 min read
Créer un système d’authentification avec PHP et MySQL (étape par étape)

Créer un système d’authentification avec PHP et MySQL (étape par étape)

Comments
2 min read
Subqueries vs CTEs: When, Why, How.

Subqueries vs CTEs: When, Why, How.

Comments
3 min read
bisql (Clojure Data Access Library) released v0.4.0: Support Malli Validation

bisql (Clojure Data Access Library) released v0.4.0: Support Malli Validation

Comments
3 min read
Understanding Subqueries vs CTEs in SQL (With Examples)

Understanding Subqueries vs CTEs in SQL (With Examples)

3
Comments
3 min read
Créer un système d’authentification avec PHP et MySQL (étape par étape)

Créer un système d’authentification avec PHP et MySQL (étape par étape)

Comments
2 min read
The Restart Challenge: Day 06

The Restart Challenge: Day 06

Comments
1 min read
SQL SET Operators: UNION, INTERSECT, and EXCEPT Explained Simply

SQL SET Operators: UNION, INTERSECT, and EXCEPT Explained Simply

Comments
3 min read
Subqueries vs CTEs in SQL: A Practical Guide for Data Analysts

Subqueries vs CTEs in SQL: A Practical Guide for Data Analysts

Comments
3 min read
1.1.3 Optimizable vs Utility

1.1.3 Optimizable vs Utility

2
Comments 2
6 min read
SQL Subqueries vs. CTEs: A Guide to Writing Better Queries

SQL Subqueries vs. CTEs: A Guide to Writing Better Queries

Comments
7 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.