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 Safe Way to Add a NOT NULL Column to a Large Postgres Table
sayonilmitra profile

The Safe Way to Add a NOT NULL Column to a Large Postgres Table

#database #sql #webdev #postgres
1
Comments 1
4 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
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
SafariConnect: From a Broken Excel Export to a Board-Ready Analysis in PostgreSQL
leahkivuti profile

SafariConnect: From a Broken Excel Export to a Board-Ready Analysis in PostgreSQL

#data #database #sql
Comments 4
11 min read
An AI-generated login endpoint "works" - I still found SQL concatenation before launch
yuan_ming_3549dae7e400994 profile

An AI-generated login endpoint "works" - I still found SQL concatenation before launch

#ai #python #security #sql
Comments 2
3 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
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
👋 Sign in for the ability to sort posts by relevant, latest, or top.