DEV Community

Database

Posts on building, using, and learning about databases.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
My First Week with SQL: A Beginner's Guide to Building, Filling, and Querying a Real Database

My First Week with SQL: A Beginner's Guide to Building, Filling, and Querying a Real Database

Comments
7 min read
sql.Open() doesn't open anything

sql.Open() doesn't open anything

Comments
2 min read
Parse Oracle SQL in VS Code with Gudu SQL Omni

Parse Oracle SQL in VS Code with Gudu SQL Omni

Comments
3 min read
An alternative to PG-Admin with LLM

An alternative to PG-Admin with LLM

Comments
4 min read
I Replaced SQLite with a Rust Database in My AI Robot — Here's What Happened

I Replaced SQLite with a Rust Database in My AI Robot — Here's What Happened

3
Comments 1
4 min read
Following a Database Read to the Metal — A Simple Walkthrough

Following a Database Read to the Metal — A Simple Walkthrough

Comments
3 min read
PostgreSQL Connection Pooling: PgBouncer, Supavisor & Built-In

PostgreSQL Connection Pooling: PgBouncer, Supavisor & Built-In

Comments
4 min read
blktrace analysis of MySQL doublewrite buffer contention

blktrace analysis of MySQL doublewrite buffer contention

Comments
10 min read
Oracle SQL/JSON: The Developer's Guide to Querying JSON Like a Pro

Oracle SQL/JSON: The Developer's Guide to Querying JSON Like a Pro

2
Comments
54 min read
Drizzle ORM Is What Prisma Should Have Been

Drizzle ORM Is What Prisma Should Have Been

Comments
6 min read
SQL Concepts and Practical Application

SQL Concepts and Practical Application

1
Comments
2 min read
PostgreSQL O(delta) MV Refreshes, pg_lake for Data Lakes, & ADBC for Columnar Data

PostgreSQL O(delta) MV Refreshes, pg_lake for Data Lakes, & ADBC for Columnar Data

Comments
3 min read
SQL-First PostgreSQL Migrations Without the Magic

SQL-First PostgreSQL Migrations Without the Magic

Comments
6 min read
SQL CASE Expressions: Write Smarter Queries with Conditional Logic

SQL CASE Expressions: Write Smarter Queries with Conditional Logic

Comments
5 min read
I built a database backup tool where even I can't read your backups

I built a database backup tool where even I can't read your backups

Comments
2 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.