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.
Gnoke-Database: Firebase in your pocket.
edmundsparrow profile

Gnoke-Database: Firebase in your pocket.

#php #gnoke #sql #backend
8
Comments 2
2 min read
Why WHERE phone = NULL Returns Nothing in SQL
dechive profile

Why WHERE phone = NULL Returns Nothing in SQL

#beginners #database #sql #tutorial
Comments
4 min read
Injection Attacks Are Not Dead: SQL, NoSQL, ORM, and Command Injection — How to Actually Fix Them (2026)
mahdi0shamlou profile

Injection Attacks Are Not Dead: SQL, NoSQL, ORM, and Command Injection — How to Actually Fix Them (2026)

#sql #nosql #security #injection
6
Comments
5 min read
Do you need foreign keys and surrogate keys because you broke your relationships ?
franckpachot profile

Do you need foreign keys and surrogate keys because you broke your relationships ?

#architecture #database #sql #document
2
Comments
9 min read
The SQL Playground That Understands Your Questions Before You Ask Them
o96a profile

The SQL Playground That Understands Your Questions Before You Ask Them

#ai #sql #tools
Comments
3 min read
🚀 Gudu SQL Omni Lineage Analysis — Directly Inside VS Code
_8a5b012a1114c57f808deb profile
沈欢

🚀 Gudu SQL Omni Lineage Analysis — Directly Inside VS Code

#dataengineering #sql #tooling #vscode
Comments
3 min read
📘SQL JOINs Explained Simply - A Beginner's Guide
sharonnyabuto profile

📘SQL JOINs Explained Simply - A Beginner's Guide

#sql #learning #beginners
Comments
4 min read
B-Trees, Clustered Indexes, and the OLAP Revolution (Part 2) 📊
piyush6348 profile

B-Trees, Clustered Indexes, and the OLAP Revolution (Part 2) 📊

#database #sql #bigdata #systemdesign
Comments
3 min read
The Offset Massacre — Why Cursor Pagination is Mandatory (2026)
kaushikcoderpy profile

The Offset Massacre — Why Cursor Pagination is Mandatory (2026)

#sql #offset #cursors
1
Comments
4 min read
Osztályközök képzése SQL-ben (GROUP BY trükk)
kovoliver profile

Osztályközök képzése SQL-ben (GROUP BY trükk)

#sql #database #mysql
1
Comments
2 min read
How a Database Really Works Underneath
farhansyah profile

How a Database Really Works Underneath

#database #nodedb #sql #storage
Comments
6 min read
I Built a Natural Language to SQL Generator with LangChain, Groq, and Streamlit
naimulkarim profile

I Built a Natural Language to SQL Generator with LangChain, Groq, and Streamlit

#python #sql #ai #beginners
Comments
10 min read
Hiểu Chuẩn ACID & Transaction: Đừng Để Database Của Bạn "Toang" Vì Lỗi Cơ Bản!
itprepvn profile
ITPrep

Hiểu Chuẩn ACID & Transaction: Đừng Để Database Của Bạn "Toang" Vì Lỗi Cơ Bản!

#database #sql #backend #architecture
Comments 1
6 min read
# Understanding Data Modeling in PowerBI: Joins, Relationship and Schemas.
nyamatari_brian_c41e0c389 profile

# Understanding Data Modeling in PowerBI: Joins, Relationship and Schemas.

#dataengineering #datascience #microsoft #sql
1
Comments
2 min read
PostgreSQL Performance Crisis, Cloud-Native DB Deployments, & Collation Deep Dive
soytuber profile
soy

PostgreSQL Performance Crisis, Cloud-Native DB Deployments, & Collation Deep Dive

#database #sql #dataengineering
Comments
4 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.