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.
The SQL CASE Expression, Explained for Beginners
michaelnocito profile

The SQL CASE Expression, Explained for Beginners

#sql #database #tutorial #beginners
Comments
9 min read
From 9,663 ms to 18 ms: sorting a 389k-product catalog in Postgres (no magic, three steps)
opttoyschina profile

From 9,663 ms to 18 ms: sorting a 389k-product catalog in Postgres (no magic, three steps)

#database #performance #postgres #sql
Comments 2
2 min read
AWS retired its free database migration assessment tool. The reason should change how you build developer tools.
sajjasudhakararao profile

AWS retired its free database migration assessment tool. The reason should change how you build developer tools.

#database #python #sql #opensource
2
Comments 5
10 min read
SQL for Real Projects: What Tutorials Don't Teach You
praveen_kumargummala_80c profile

SQL for Real Projects: What Tutorials Don't Teach You

#sql #webdevolpment #database #dataanalytics
Comments
4 min read
SQLite Internals: Win32 Malloc; PostgreSQL 19 LZ4 Compression, Spock 6 Beta
soytuber profile
soy

SQLite Internals: Win32 Malloc; PostgreSQL 19 LZ4 Compression, Spock 6 Beta

#database #sql #sqlite
Comments
3 min read
Postgres vs SQLite
odalov profile

Postgres vs SQLite

#architecture #database #postgres #sql
2
Comments
4 min read
AI Data Analysis: Why Governed Metrics Beat Raw SQL Generation
maxbonnard profile

AI Data Analysis: Why Governed Metrics Beat Raw SQL Generation

#data #sql #aiagents #semanticlayer
5
Comments
9 min read
How to Set Up a SQL Database for Beginners
michaelnocito profile

How to Set Up a SQL Database for Beginners

#sql #database #tutorial #beginners
Comments
6 min read
Additive column can 500 every login (Drizzle + Better Auth + preview deploys)
omar_bni_f6856a8bb0e021e9 profile

Additive column can 500 every login (Drizzle + Better Auth + preview deploys)

#database #sql #devops #webdev
3
Comments
9 min read
Build a Natural Language to SQL API in Python
sonam_50a41a4ced7e6b4f3fa profile

Build a Natural Language to SQL API in Python

#python #ai #flask #sql
Comments
2 min read
Why a Single ALTER TABLE Can Take Down Your Whole Database
jatinjainsaraf profile

Why a Single ALTER TABLE Can Take Down Your Whole Database

#postgres #database #backend #sql
Comments
5 min read
Why Do We Keep Forgetting About the Plan Cache in SQL Server?
azhadsuhaimi profile

Why Do We Keep Forgetting About the Plan Cache in SQL Server?

#sql #database #performance
Comments
2 min read
Google Dorking in 2026: The Ultimate Guide for Security Researchers
vickybuilds profile

Google Dorking in 2026: The Ultimate Guide for Security Researchers

#sql #security #google #cybersecurity
6
Comments
11 min read
SQL Basics Explained: DDL, DML, Filtering, and CASE WHEN
itsweshy profile

SQL Basics Explained: DDL, DML, Filtering, and CASE WHEN

#beginners #database #sql
2
Comments 2
4 min read
Postgres: force drop a database that is being accessed by other users
philip_mcclarence_2ef9475 profile

Postgres: force drop a database that is being accessed by other users

#database #postgres #sql #tutorial
Comments
4 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.