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.
Snowflake Data Cloud: A Comprehensive Guide

Snowflake Data Cloud: A Comprehensive Guide

Comments
31 min read
The Complete Guide to Data Modeling: A Comprehensive Chai-Time Conversation

The Complete Guide to Data Modeling: A Comprehensive Chai-Time Conversation

Comments
39 min read
Why is offset pagination slow

Why is offset pagination slow

Comments
2 min read
Understanding How Applications Talk to SQLite Internally

Understanding How Applications Talk to SQLite Internally

10
Comments
4 min read
I Built a Hybrid AI Database - Cache in Go (And It Runs Stable on My Old Dell Latitude)

I Built a Hybrid AI Database - Cache in Go (And It Runs Stable on My Old Dell Latitude)

5
Comments
7 min read
Database connection in NextJS (App Router)

Database connection in NextJS (App Router)

Comments
2 min read
The Myth of ‘Just Connect Lambda to RDS’

The Myth of ‘Just Connect Lambda to RDS’

Comments
8 min read
The Myth of ‘Just Connect Lambda to RDS’

The Myth of ‘Just Connect Lambda to RDS’

Comments
8 min read
Why Tenant Context Must Be Scoped Per Transaction

Why Tenant Context Must Be Scoped Per Transaction

Comments
4 min read
QUICK SQL REVISION

QUICK SQL REVISION

Comments
14 min read
The basics of managing the database schema changes

The basics of managing the database schema changes

Comments
4 min read
MySQL Performance Tuning: From Slow Queries to Lightning-Fast Database

MySQL Performance Tuning: From Slow Queries to Lightning-Fast Database

Comments
5 min read
UPDATE...RETURNING in MongoDB: ACID and idempotency with findOneAndUpdate()

UPDATE...RETURNING in MongoDB: ACID and idempotency with findOneAndUpdate()

Comments
5 min read
Track Blocking and Deadlocks in MSSQL with my custom script

Track Blocking and Deadlocks in MSSQL with my custom script

1
Comments
4 min read
How to Sync Stripe Data to PostgreSQL in 5 Minutes (No Code)

How to Sync Stripe Data to PostgreSQL in 5 Minutes (No Code)

Comments
3 min read
Wait, what? PK is not needed for HABTM?

Wait, what? PK is not needed for HABTM?

Comments
2 min read
Why I Built DDL to Data

Why I Built DDL to Data

Comments
4 min read
Week 8 of 40 – Giving CatAtlas a Real Identity (and Tests)

Week 8 of 40 – Giving CatAtlas a Real Identity (and Tests)

Comments
2 min read
MariaDB mysqldump guide — Using mysqldump for MariaDB database backups

MariaDB mysqldump guide — Using mysqldump for MariaDB database backups

Comments
9 min read
Stop Manually Tracing Azure Synapse Dependencies

Stop Manually Tracing Azure Synapse Dependencies

Comments
1 min read
I Built a Scalable Financial Transaction System That Stays Correct Under Load

I Built a Scalable Financial Transaction System That Stays Correct Under Load

1
Comments
4 min read
AWS Databases!

AWS Databases!

Comments
2 min read
Part 5: Building a ZIP Code Dimension Table

Part 5: Building a ZIP Code Dimension Table

Comments
2 min read
EP 7: The "Join" Tax vs. The "Storage" Tax

EP 7: The "Join" Tax vs. The "Storage" Tax

Comments
4 min read
CertDb: Building a Comprehensive Cybersecurity Certification Database

CertDb: Building a Comprehensive Cybersecurity Certification Database

Comments
9 min read
loading...