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.
My setup for integration tests in Go with embedded-postgres

My setup for integration tests in Go with embedded-postgres

Comments
3 min read
Module 3 Summary - Data Warehousing & BigQuery

Module 3 Summary - Data Warehousing & BigQuery

Comments
3 min read
How Redis Cut My Database Reads from ~26K to Almost Zero

How Redis Cut My Database Reads from ~26K to Almost Zero

Comments
2 min read
Changing Messy Data, DAX, and Dashboards to a Course of action with Power BI

Changing Messy Data, DAX, and Dashboards to a Course of action with Power BI

1
Comments
2 min read
PostgreSQL indexing explained — 5 index types and when to use each

PostgreSQL indexing explained — 5 index types and when to use each

Comments
9 min read
Building Tabularis: A Developer's Database Tool That Doesn't Suck

Building Tabularis: A Developer's Database Tool That Doesn't Suck

Comments
5 min read
Generating AWR Reports in an Active Data Guard using RMF(12.2)

Generating AWR Reports in an Active Data Guard using RMF(12.2)

Comments
4 min read
MySQL Too many connections: How I Debugged It and Scaled the Connection Pool

MySQL Too many connections: How I Debugged It and Scaled the Connection Pool

3
Comments
9 min read
I Let AI Write to My Database (With Guardrails)🔬

I Let AI Write to My Database (With Guardrails)🔬

8
Comments 1
5 min read
SQL Joins and Window Functions: The Tools That Changed How I Query Data

SQL Joins and Window Functions: The Tools That Changed How I Query Data

2
Comments
7 min read
Best PostgreSQL IDE and GUI Tools in 2026

Best PostgreSQL IDE and GUI Tools in 2026

2
Comments
14 min read
I Benchmarked TimescaleDB vs ClickHouse vs MongoDB for Observability Data - The Results Surprised Me

I Benchmarked TimescaleDB vs ClickHouse vs MongoDB for Observability Data - The Results Surprised Me

8
Comments
8 min read
Why reverse face search is so hard to build at scale (and what we learned)

Why reverse face search is so hard to build at scale (and what we learned)

Comments
1 min read
Dissecting PostgreSQL — Why Being Read-Optimized Comes at the Cost of Write Speed

Dissecting PostgreSQL — Why Being Read-Optimized Comes at the Cost of Write Speed

5
Comments
8 min read
Building a Telegram Bot Payment System with Python (Complete Guide)

Building a Telegram Bot Payment System with Python (Complete Guide)

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