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.
Day 4/100: Understanding the Architecture That Makes ClickHouse® So Fast

Day 4/100: Understanding the Architecture That Makes ClickHouse® So Fast

3
Comments
2 min read
Subqueries vs. CTEs in SQL: What They Are and When to Use Each.

Subqueries vs. CTEs in SQL: What They Are and When to Use Each.

Comments
7 min read
Automate MongoDB Exports, Imports, and Sync Jobs with VisuaLeaf

Automate MongoDB Exports, Imports, and Sync Jobs with VisuaLeaf

6
Comments
6 min read
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
Apache Data Lakehouse Weekly: May 28 - June 4, 2026

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

Comments
24 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
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
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.