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.
Working with ROW Types in GBase 8s JDBC

Working with ROW Types in GBase 8s JDBC

2
Comments
6 min read
PostgreSQL Extension for Row Padding, pgBackRest EOL, and SQLite Windows XP Support

PostgreSQL Extension for Row Padding, pgBackRest EOL, and SQLite Windows XP Support

Comments
3 min read
How a Single Missing Index Nearly Tanked Our SaaS Database (and What We Learned)

How a Single Missing Index Nearly Tanked Our SaaS Database (and What We Learned)

Comments
9 min read
Why InfluxDB Is the Go-To Database for Time-Series Data (With Real Examples)

Why InfluxDB Is the Go-To Database for Time-Series Data (With Real Examples)

Comments
5 min read
Managing Permissions in GBase 8s: From Database-Level to Object-Level Access Control

Managing Permissions in GBase 8s: From Database-Level to Object-Level Access Control

2
Comments
3 min read
PostgreSQL Join Optimization: Nested Loop, Hash, and Merge

PostgreSQL Join Optimization: Nested Loop, Hash, and Merge

Comments
11 min read
How MindsDB Is Becoming the Data Brain for AI Agents in 2026

How MindsDB Is Becoming the Data Brain for AI Agents in 2026

Comments
4 min read
I indexed 17,341 polynomial fan curves in Postgres and matched a duty point in <100ms

I indexed 17,341 polynomial fan curves in Postgres and matched a duty point in <100ms

Comments
4 min read
SQL Subqueries vs CTEs: What I Wish Someone Told Me When I Was Learning SQL

SQL Subqueries vs CTEs: What I Wish Someone Told Me When I Was Learning SQL

Comments
3 min read
Inside GBase 8a Data Consistency: ddlevent, dmlevent, dmlstorageevent

Inside GBase 8a Data Consistency: ddlevent, dmlevent, dmlstorageevent

2
Comments
2 min read
Understanding Subquery and Common Table Expressions(CTEs)

Understanding Subquery and Common Table Expressions(CTEs)

Comments
2 min read
Ruby on Rails Has Scalability Issues. Here's How We Solved Them

Ruby on Rails Has Scalability Issues. Here's How We Solved Them

5
Comments 2
3 min read
Redis vs Read Replica vs Materialised View: Pick the Right One

Redis vs Read Replica vs Materialised View: Pick the Right One

Comments
7 min read
Design Twitter Without the Fanout-on-Write Cliché

Design Twitter Without the Fanout-on-Write Cliché

Comments
7 min read
MongoDB vs Postgres: A Decision Table That Actually Picks For You

MongoDB vs Postgres: A Decision Table That Actually Picks For You

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