Forem

Database

Posts on building, using, and learning about databases.

Posts

đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
20 Essential MySQL Optimization Tips for Better Database
Cover image for 20 Essential MySQL Optimization Tips for Better Database

20 Essential MySQL Optimization Tips for Better Database

Comments
5 min read
The Ultimate Database That Makes Compliance Audits Effortless
Cover image for The Ultimate Database That Makes Compliance Audits Effortless

The Ultimate Database That Makes Compliance Audits Effortless

Comments
6 min read
The Full Graph-RAG Stack As Declarative Pipelines in Cypher

The Full Graph-RAG Stack As Declarative Pipelines in Cypher

Comments
4 min read
What Happens If Two Android Phones Edit the Same Data Offline?
Cover image for What Happens If Two Android Phones Edit the Same Data Offline?

What Happens If Two Android Phones Edit the Same Data Offline?

Comments
7 min read
SQLite as a Vector Database — Yes, Really

SQLite as a Vector Database — Yes, Really

1
Comments
7 min read
How I Cut API Latency by 95% by Fixing One Hidden Loop ❤️‍🔥
Cover image for How I Cut API Latency by 95% by Fixing One Hidden Loop ❤️‍🔥

How I Cut API Latency by 95% by Fixing One Hidden Loop ❤️‍🔥

2
Comments 1
11 min read
Why We Built Database for Document Retrieval

Why We Built Database for Document Retrieval

1
Comments 1
3 min read
Designing a Modern Data Warehouse: Combining Bill Inmon and Ralph Kimball in a Hybrid Medallion Architecture

Designing a Modern Data Warehouse: Combining Bill Inmon and Ralph Kimball in a Hybrid Medallion Architecture

2
Comments
3 min read
MySQL backup to cloud — Backing up MySQL databases to AWS S3 and Google Cloud
Cover image for MySQL backup to cloud — Backing up MySQL databases to AWS S3 and Google Cloud

MySQL backup to cloud — Backing up MySQL databases to AWS S3 and Google Cloud

Comments
8 min read
Index Key Format in SQLite
Cover image for Index Key Format in SQLite

Index Key Format in SQLite

13
Comments
4 min read
myanon — how I anonymize 200GB of MySQL nightly for GDPR-safe dev

myanon — how I anonymize 200GB of MySQL nightly for GDPR-safe dev

Comments
1 min read
Day 30 of #100DaysOfCode — Introduction to Database
Cover image for Day 30 of #100DaysOfCode — Introduction to Database

Day 30 of #100DaysOfCode — Introduction to Database

6
Comments
4 min read
SQL Joins and Window Functions: The Difference Between Combining Data and Analyzing It

SQL Joins and Window Functions: The Difference Between Combining Data and Analyzing It

1
Comments
3 min read
Go Database Refactored to Eliminate Incompatible Storage Format, Reducing Code Bloat and Maintenance Challenges

Go Database Refactored to Eliminate Incompatible Storage Format, Reducing Code Bloat and Maintenance Challenges

2
Comments
10 min read
How I automated MongoDB JSON Flattening for Analytics (No ETL)
Cover image for How I automated MongoDB JSON Flattening for Analytics (No ETL)

How I automated MongoDB JSON Flattening for Analytics (No ETL)

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