Forem

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
Cover image for 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
FerresDB update!

FerresDB update!

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