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 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
Building a SQL Lexer in Rust: Why I Replaced `Vec<char>` with `&str` and `Ident(String)` with Spans

Building a SQL Lexer in Rust: Why I Replaced `Vec<char>` with `&str` and `Ident(String)` with Spans

1
Comments
3 min read
PostgreSQL Query Rewriting Techniques

PostgreSQL Query Rewriting Techniques

Comments 1
9 min read
Continuation — Tables, CRUD, and Foreign Keys

Continuation — Tables, CRUD, and Foreign Keys

1
Comments
2 min read
Using the table.list File for Flexible Backup in GBase 8a

Using the table.list File for Flexible Backup in GBase 8a

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