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.
Track Rolling-Back Transactions in GBase 8s

Track Rolling-Back Transactions in GBase 8s

2
Comments
1 min read
How to Export QuickBooks Data to a Database

How to Export QuickBooks Data to a Database

Comments
11 min read
Extended RUM in DocumentDB extension for PostgreSQL: Efficient ESR (Equality, Sort, Range) Queries

Extended RUM in DocumentDB extension for PostgreSQL: Efficient ESR (Equality, Sort, Range) Queries

Comments
7 min read
PostgreSQL Query Anti-Patterns and Common Mistakes

PostgreSQL Query Anti-Patterns and Common Mistakes

Comments 1
7 min read
From Raw SQL Strings to Type-Safe Queries: How I Learned Prisma ORM

From Raw SQL Strings to Type-Safe Queries: How I Learned Prisma ORM

1
Comments
7 min read
SQL Subqueries vs CTEs

SQL Subqueries vs CTEs

Comments
3 min read
VictoriaMetrics Stream Aggregation: A Three-Year Retrospective (2026)

VictoriaMetrics Stream Aggregation: A Three-Year Retrospective (2026)

1
Comments
5 min read
PostgreSQL AI Memory, Perf Tuning; Data Pipeline Orchestration Comparison

PostgreSQL AI Memory, Perf Tuning; Data Pipeline Orchestration Comparison

Comments 1
3 min read
High Memory Usage in Postgres is Good, Actually

High Memory Usage in Postgres is Good, Actually

1
Comments
7 min read
We Replaced Redis with MySQL SKIP LOCKED for Inventory Reservation — Oversells Went to Zero

We Replaced Redis with MySQL SKIP LOCKED for Inventory Reservation — Oversells Went to Zero

Comments
3 min read
Data Management Systems: Transactional to Analytical Architectures

Data Management Systems: Transactional to Analytical Architectures

Comments
7 min read
How I was introduced to SQL window function

How I was introduced to SQL window function

Comments
2 min read
Troubleshooting GBase 8c: OS, Network, Disk, and Database

Troubleshooting GBase 8c: OS, Network, Disk, and Database

2
Comments
3 min read
OLAP vs OLTP: A Deep Dive into Database Processing Systems

OLAP vs OLTP: A Deep Dive into Database Processing Systems

Comments
3 min read
The CAP Theorem in Practice: Making the Right Trade-offs at Scale

The CAP Theorem in Practice: Making the Right Trade-offs at Scale

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