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.
GBase 8s Associative Arrays: A Guide to Key-Value Collections

GBase 8s Associative Arrays: A Guide to Key-Value Collections

2
Comments
2 min read
GBase 8s Nested Tables: A Practical Guide to Collection Types

GBase 8s Nested Tables: A Practical Guide to Collection Types

2
Comments
2 min read
Remote Physical Backup and Recovery in GBase 8c Centralized Mode

Remote Physical Backup and Recovery in GBase 8c Centralized Mode

2
Comments
3 min read
Why I Built a Database Client in Go Instead of Electron

Why I Built a Database Client in Go Instead of Electron

Comments 1
6 min read
PostgreSQL Query Rewriting Techniques

PostgreSQL Query Rewriting Techniques

Comments 1
9 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
Codd's Connection Trap and Oracle's JOIN TO ONE

Codd's Connection Trap and Oracle's JOIN TO ONE

Comments
8 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
Shared Page Cache in SQLite: Smarter Memory, Less Redundant Work

Shared Page Cache in SQLite: Smarter Memory, Less Redundant Work

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