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.
Basic SQL Select Queries

Basic SQL Select Queries

1
Comments
2 min read
Beyond CRUD: How easy-query Brings OLAP Superpowers to Your Java ORM

Beyond CRUD: How easy-query Brings OLAP Superpowers to Your Java ORM

2
Comments
7 min read
Dissecting MongoDB — It Uses B-Trees Too, So Why Are Writes Actually Faster?

Dissecting MongoDB — It Uses B-Trees Too, So Why Are Writes Actually Faster?

4
Comments
10 min read
Stop writing cron jobs: I built a C++ database with native temporal states

Stop writing cron jobs: I built a C++ database with native temporal states

5
Comments
1 min read
How I made a 31M-row SQLite query go from 168 seconds to 5 seconds

How I made a 31M-row SQLite query go from 168 seconds to 5 seconds

1
Comments
4 min read
Next.js 16 SaaS Database Schema with Prisma: Users, Subscriptions, and AI Chat

Next.js 16 SaaS Database Schema with Prisma: Users, Subscriptions, and AI Chat

1
Comments
4 min read
Building a Content Cleanup System for Old Videos

Building a Content Cleanup System for Old Videos

Comments
2 min read
AUTOVACUUM in SQLite: How Your Database Cleans Up After Itself

AUTOVACUUM in SQLite: How Your Database Cleans Up After Itself

21
Comments 5
4 min read
Introducing Xata OSS: Postgres platform with branching, now Apache 2.0

Introducing Xata OSS: Postgres platform with branching, now Apache 2.0

6
Comments
7 min read
Reacting to Database Changes in Real-Time: How I Built a CDC Tool

Reacting to Database Changes in Real-Time: How I Built a CDC Tool

1
Comments 1
8 min read
pg_duckpipe: Real-time CDC for streaming Postgres Table into Columnar Ducklake

pg_duckpipe: Real-time CDC for streaming Postgres Table into Columnar Ducklake

1
Comments
3 min read
Salesforce Put Heroku Into Maintenance Mode.

Salesforce Put Heroku Into Maintenance Mode.

1
Comments
2 min read
SQL Formatting Best Practices: Write Clean, Readable Queries

SQL Formatting Best Practices: Write Clean, Readable Queries

Comments
14 min read
What an Old Oracle Database Taught Me About Not Trusting Assumptions

What an Old Oracle Database Taught Me About Not Trusting Assumptions

3
Comments
1 min read
AWS Glue Alternatives: Simpler Ways to Sync API Data to RDS

AWS Glue Alternatives: Simpler Ways to Sync API Data to RDS

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