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.
Building a Financial Data Pipeline: How I Scraped 25 Years of Stock Market Filings with Python and a Graph Database

Building a Financial Data Pipeline: How I Scraped 25 Years of Stock Market Filings with Python and a Graph Database

Comments
4 min read
Managing Large PostgreSQL Tables with Native Partitioning and pg_partman

Managing Large PostgreSQL Tables with Native Partitioning and pg_partman

3
Comments
3 min read
My setup for integration tests in Go with embedded-postgres

My setup for integration tests in Go with embedded-postgres

Comments
3 min read
FerresDB update!

FerresDB update!

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