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 Set Up DuckDB (Run SQL on a CSV With No Import Step)
michaelnocito profile

How to Set Up DuckDB (Run SQL on a CSV With No Import Step)

#sql #database #tutorial #beginners
Comments
10 min read
I built a free, interactive SQL practice tool for data engineering interviews
harishdataengineer profile

I built a free, interactive SQL practice tool for data engineering interviews

#dataengineering #sql #webdev #interview
Comments
1 min read
Subqueries vs CTEs: Query Optimizer Internals & Memory Spooling Explained
arpitmbangre profile

Subqueries vs CTEs: Query Optimizer Internals & Memory Spooling Explained

#database #sql #dataengineering #performance
Comments
2 min read
My security test was green for six weeks because it could not turn red
guidondor profile

My security test was green for six weeks because it could not turn red

#postgres #testing #sql #security
Comments
3 min read
Prisma vs Drizzle vs Raw SQL: What Every Backend Developer Should Understand Before Choosing an ORM
surajsrggupta profile

Prisma vs Drizzle vs Raw SQL: What Every Backend Developer Should Understand Before Choosing an ORM

#sql #prisma #drizzle #database
Comments
13 min read
What Has To Be True Before You Trust An AI Data Agent
paulcrinigan profile

What Has To Be True Before You Trust An AI Data Agent

#ai #data #sql #agents
2
Comments 1
3 min read
Tối Ưu Truy Vấn SQL & Connection Pool Tải Cao
phantam38 profile

Tối Ưu Truy Vấn SQL & Connection Pool Tải Cao

#sql
Comments
4 min read
Stop writing raw SQL in your migrations (most of the time)
darkmavis1980 profile

Stop writing raw SQL in your migrations (most of the time)

#database #sql #node
1
Comments 2
6 min read
Performance Engineering: What Is the System Waiting For?
josemariairiarte profile

Performance Engineering: What Is the System Waiting For?

#performance #dotnet #sql #csharp
1
Comments
13 min read
SQL Execution Order Internals: Why WHERE Fails on Aliases but ORDER BY Succeeds
arpitmbangre profile

SQL Execution Order Internals: Why WHERE Fails on Aliases but ORDER BY Succeeds

#sql #database #dataengineering #backend
Comments
1 min read
Security Fundamentals for Web Developers: Authentication, Authorization, and the Attacks You Need to Prevent
apeder profile

Security Fundamentals for Web Developers: Authentication, Authorization, and the Attacks You Need to Prevent

#security #webdev #sql #cybersecurity
1
Comments 2
9 min read
An ERD MCP Server: AI Agents That Follow Your Naming Standard
sqemo profile

An ERD MCP Server: AI Agents That Follow Your Naming Standard

#ai #mcp #database #sql
Comments
5 min read
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
Partitioning, clustering, and BI Engine: measuring what each one saves in BigQuery
laura_cristinachicovisd profile

Partitioning, clustering, and BI Engine: measuring what each one saves in BigQuery

#bigquery #dataengineering #sql
Comments
7 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
👋 Sign in for the ability to sort posts by relevant, latest, or top.