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.
Build a Knowledge Layer for SQL Agents with OKF (Part 2)
lakhan_malviya_09d3c6dbcb profile

Build a Knowledge Layer for SQL Agents with OKF (Part 2)

#ai #llm #sql #documentation
1
Comments
16 min read
MySQL Development Setup – macOS Apple Silicon (ARM)
udara_dananjaya profile

MySQL Development Setup – macOS Apple Silicon (ARM)

#backend #database #sql #tutorial
Comments 1
3 min read
SQL Transactions
rhuturaj_takle profile

SQL Transactions

#dotnet #sql #programming #learning
Comments 1
20 min read
Postgres Internals in Simple Words: One Example to Understand Tables, Pages, Tuples, and Indexes
pakeezakhalid profile

Postgres Internals in Simple Words: One Example to Understand Tables, Pages, Tuples, and Indexes

#postgres #database #beginners #sql
Comments 1
4 min read
Before You Convert a Single CA 2E Program, Find Out Which Ones Anyone Still Runs
jay_krshn_1a9ac493fadf8 profile
Jay

Before You Convert a Single CA 2E Program, Find Out Which Ones Anyone Still Runs

#ca2e #ibmi #sql #modernization
Comments
6 min read
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
Optimistic vs Pessimistic Locking: Handling Race Conditions in High-Contention Databases
devanshu_patil profile

Optimistic vs Pessimistic Locking: Handling Race Conditions in High-Contention Databases

#database #sql #architecture #backend
Comments
2 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
What AI Coding Assistants Need Next: Context, Model Choice and Human Review
databaseinsights profile

What AI Coding Assistants Need Next: Context, Model Choice and Human Review

#ai #sql #database #productivity
3
Comments
5 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
Day 1: starting the road to backend developer
afrin_rabikm profile
Afrin

Day 1: starting the road to backend developer

#backend #buildinpublic #java #sql
1
Comments
1 min read
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
👋 Sign in for the ability to sort posts by relevant, latest, or top.