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.
UUID vs UUIDv7 vs Snowflake ID: Choosing the Right Identifier for Backend Systems

UUID vs UUIDv7 vs Snowflake ID: Choosing the Right Identifier for Backend Systems

Comments
4 min read
Interval Partitioning in GBase 8s: Automatic Extension and Lifecycle Management

Interval Partitioning in GBase 8s: Automatic Extension and Lifecycle Management

2
Comments
2 min read
The bug your Typescript compiler and SQL migration both miss

The bug your Typescript compiler and SQL migration both miss

Comments
1 min read
Basics of Vector Databases: Moving Beyond Rows and Columns

Basics of Vector Databases: Moving Beyond Rows and Columns

Comments
2 min read
Why I Stopped Using Redis for Coordination State and Built Something Else

Why I Stopped Using Redis for Coordination State and Built Something Else

2
Comments 2
5 min read
Query Markdown as a Database with mq-db: SQL, mq, and Interval Indexes

Query Markdown as a Database with mq-db: SQL, mq, and Interval Indexes

Comments 1
4 min read
An MCP server for PostgreSQL is not just another SQL shortcut

An MCP server for PostgreSQL is not just another SQL shortcut

Comments
2 min read
Why I'm Building a Database From Scratch in Raw C++ (And Why I Banned the STL)

Why I'm Building a Database From Scratch in Raw C++ (And Why I Banned the STL)

Comments
2 min read
GBase 8s JDBC Batch Insert: Configuration and Example

GBase 8s JDBC Batch Insert: Configuration and Example

2
Comments
1 min read
count(*) vs count(1) vs count(column_name) in GBase 8c

count(*) vs count(1) vs count(column_name) in GBase 8c

2
Comments
2 min read
Apache Data Lakehouse Weekly: May 28 - June 4, 2026

Apache Data Lakehouse Weekly: May 28 - June 4, 2026

Comments
24 min read
OLTP vs. OLAP: The Two Sides of the Data Coin

OLTP vs. OLAP: The Two Sides of the Data Coin

1
Comments
3 min read
Getting Started with pg_durable: Workflows Inside PostgreSQL

Getting Started with pg_durable: Workflows Inside PostgreSQL

9
Comments 1
11 min read
Eloquent's Magic Is Gone. Drizzle Makes You Name Column Types.

Eloquent's Magic Is Gone. Drizzle Makes You Name Column Types.

Comments
11 min read
Stop Wiring Up Database Drivers Manually — A Simpler Python Database API

Stop Wiring Up Database Drivers Manually — A Simpler Python Database API

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