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.
How to Install PostgreSQL for Beginners (And Whether You Need To)
michaelnocito profile

How to Install PostgreSQL for Beginners (And Whether You Need To)

#sql #database #tutorial #beginners
Comments
11 min read
From Plain English to a Live Dashboard: Automating Reporting with MCP
vivekdraxlr profile

From Plain English to a Live Dashboard: Automating Reporting with MCP

#sql #database #ai #productivity
Comments
6 min read
How to Export SQL Results to CSV and Excel (Without Wrecking the Data)
michaelnocito profile

How to Export SQL Results to CSV and Excel (Without Wrecking the Data)

#sql #database #tutorial #beginners
Comments
10 min read
Free AI Compute for SQL Review: A Structured Debate and a Decision Rule
dataio_4921 profile

Free AI Compute for SQL Review: A Structured Debate and a Decision Rule

#ai #sql #testing #database
Comments
6 min read
SQLazy: Convert Swipe Records into Single-Row Sessions by Pairing Order
esproc_spl profile
Judy

SQLazy: Convert Swipe Records into Single-Row Sessions by Pairing Order

#backend #database #sql
6
Comments 2
4 min read
SQL Cheat sheet
iliya_faz profile

SQL Cheat sheet

#beginners #database #sql #tutorial
1
Comments
7 min read
The Slow Query Sentinel: A Zero-Dollar Server That Explains Your Database's Worst SQL
dataio_4921 profile

The Slow Query Sentinel: A Zero-Dollar Server That Explains Your Database's Worst SQL

#sql #database #ai #python
Comments
4 min read
MCP vs. a Direct Database Connection: A Security and Workflow Comparison
vivekdraxlr profile

MCP vs. a Direct Database Connection: A Security and Workflow Comparison

#sql #database #ai #postgres
Comments
7 min read
Synthetic Data Is the Missing Layer in Your SQL Eval Harness
dataio_4921 profile

Synthetic Data Is the Missing Layer in Your SQL Eval Harness

#sql #ai #testing #dataprivacy
Comments
4 min read
Web Performance on a Budget: Bundle Size, API Limits, and Database Indexes
apeder profile

Web Performance on a Budget: Bundle Size, API Limits, and Database Indexes

#guide #webdev #api #sql
1
Comments
9 min read
Why I Chose SQLite Over PostgreSQL
vladshiyan profile

Why I Chose SQLite Over PostgreSQL

#database #sql #privacy #localfirst
Comments
7 min read
TIL mysqladmin ping returns exit 0 even on Access Denied. our backups were silently broken and nobody noticed
knutt3 profile

TIL mysqladmin ping returns exit 0 even on Access Denied. our backups were silently broken and nobody noticed

#sql
Comments
1 min read
Prove Your Backups Actually Restore Automatically, on a Separate Server
deepeshd profile

Prove Your Backups Actually Restore Automatically, on a Separate Server

#automation #database #devops #sql
Comments
7 min read
A Windows Service is Down. Now What?
prateek_srivastava_6a5661 profile

A Windows Service is Down. Now What?

#devops #microsoft #sql #sre
Comments
6 min read
What actually happens in a database index (and why half of them do nothing)
vladut02 profile
VLAD

What actually happens in a database index (and why half of them do nothing)

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