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.
INSERT ALL and INSERT FIRST in GBase 8s: Usage and Examples

INSERT ALL and INSERT FIRST in GBase 8s: Usage and Examples

2
Comments
2 min read
Migrating From a JSON Column to a Proper Schema in Postgres

Migrating From a JSON Column to a Proper Schema in Postgres

1
Comments
6 min read
I built a PostgreSQL learning platform with labs & quizzes — would love feedback

I built a PostgreSQL learning platform with labs & quizzes — would love feedback

Comments
1 min read
GBase 8a Full-Text Index: Features, Queries, and Configuration

GBase 8a Full-Text Index: Features, Queries, and Configuration

2
Comments
2 min read
ShannonBase HTAP Architecture Analysis: From MySQL Optimizer to Vectorized Execution Engine — Overview

ShannonBase HTAP Architecture Analysis: From MySQL Optimizer to Vectorized Execution Engine — Overview

Comments
2 min read
Time-Series, Document, or Relational? The 5-Question Test Every New Project Needs

Time-Series, Document, or Relational? The 5-Question Test Every New Project Needs

Comments 1
8 min read
LSM Trees vs B-Trees: How Storage Engines Choose Their Data Structure

LSM Trees vs B-Trees: How Storage Engines Choose Their Data Structure

Comments
3 min read
Don’t Trust Backups You Haven’t Restored

Don’t Trust Backups You Haven’t Restored

Comments
8 min read
Day 19 - Relational Database Service

Day 19 - Relational Database Service

5
Comments 2
5 min read
Why PostgreSQL EXPLAIN ANALYZE Can Mislead You — and What to Use Instead

Why PostgreSQL EXPLAIN ANALYZE Can Mislead You — and What to Use Instead

Comments
6 min read
YouTube Backend: How Database & Data Management Actually Work

YouTube Backend: How Database & Data Management Actually Work

2
Comments
6 min read
The Metadata Structure of Modern Table Formats

The Metadata Structure of Modern Table Formats

Comments
7 min read
3 General Methods to Optimize Query Performance in GBase 8a

3 General Methods to Optimize Query Performance in GBase 8a

2
Comments
3 min read
$exists and non-sparse indexes in MongoDB and in other DocumentDB

$exists and non-sparse indexes in MongoDB and in other DocumentDB

Comments
10 min read
DuckDB Single-Node Analytics, PostgreSQL Bloom Filters, SQLite Compression

DuckDB Single-Node Analytics, PostgreSQL Bloom Filters, SQLite Compression

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