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.
Optimizing GBase 8s JDBC with the OPTOFC Parameter

Optimizing GBase 8s JDBC with the OPTOFC Parameter

2
Comments
2 min read
GBase 8a Statistics Tables: Understanding gc_stats_table and gc_stats_column

GBase 8a Statistics Tables: Understanding gc_stats_table and gc_stats_column

2
Comments
2 min read
Time Zone Pitfall When Migrating from MySQL to GBase 8c — and How to Fix It

Time Zone Pitfall When Migrating from MySQL to GBase 8c — and How to Fix It

2
Comments
3 min read
SQL Basics: Talking to a Database for the First Time

SQL Basics: Talking to a Database for the First Time

Comments
7 min read
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
What Is Record TTL? Database Time-to-Live Explained

What Is Record TTL? Database Time-to-Live Explained

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