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.
Subqueries & Views in SQLite: Writing Smarter, Cleaner Queries

Subqueries & Views in SQLite: Writing Smarter, Cleaner Queries

17
Comments
3 min read
Reliable messaging:Guaranteeing at-least-once with transactional outbox pattern

Reliable messaging:Guaranteeing at-least-once with transactional outbox pattern

Comments
2 min read
AUTOINCREMENT in SQLite

AUTOINCREMENT in SQLite

17
Comments 1
3 min read
Introduction to SQL: DDL, DML, and Querying Data

Introduction to SQL: DDL, DML, and Querying Data

1
Comments
3 min read
A Deep Dive into SQL Basics

A Deep Dive into SQL Basics

Comments
3 min read
PostgreSQL Performance Tuning on a 10TB Database: What Actually Worked

PostgreSQL Performance Tuning on a 10TB Database: What Actually Worked

Comments 1
6 min read
How to Securely Migrate PostgreSQL to AWS RDS with Zero Downtime (Docker & Terraform)

How to Securely Migrate PostgreSQL to AWS RDS with Zero Downtime (Docker & Terraform)

Comments
6 min read
🚨 Redis Mistake That Broke My Production System (Eviction Policy Lesson)

🚨 Redis Mistake That Broke My Production System (Eviction Policy Lesson)

1
Comments 1
1 min read
Agent Native Data Infrastructure

Agent Native Data Infrastructure

5
Comments 1
11 min read
A AWS lançou um ambiente de testes onde você pode experimentar o Aurora DSQL imediatamente, sem precisar fazer login.

A AWS lançou um ambiente de testes onde você pode experimentar o Aurora DSQL imediatamente, sem precisar fazer login.

Comments
2 min read
JSON vs JSONB in PostgreSQL: I tested 1M rows to find out

JSON vs JSONB in PostgreSQL: I tested 1M rows to find out

1
Comments
2 min read
Master-Class: Scaling Databases with Sharding, Partitioning, and Consistent Hashing

Master-Class: Scaling Databases with Sharding, Partitioning, and Consistent Hashing

Comments
4 min read
SQL Fundamentals: DDL vs DML and Essential Commands

SQL Fundamentals: DDL vs DML and Essential Commands

Comments
3 min read
SQLite WAL Mode: 10x Performance for Python Apps

SQLite WAL Mode: 10x Performance for Python Apps

Comments
5 min read
I built an open-source encyclopedia of psychoactive substances with Next.js 16

I built an open-source encyclopedia of psychoactive substances with Next.js 16

Comments
3 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.