Forem

Database

Posts on building, using, and learning about databases.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
Journal Entry: I Forgot to Clean Up After Myself

Journal Entry: I Forgot to Clean Up After Myself

Comments
2 min read
Telegram Bot Store on Python: Step-by-Step Guide with Payment, Catalog, and Admin Panel (Aiogram 3 + SQLAlchemy 2)

Telegram Bot Store on Python: Step-by-Step Guide with Payment, Catalog, and Admin Panel (Aiogram 3 + SQLAlchemy 2)

Comments
49 min read
The Best Tools to Design Database Schemas Visually in 2025

The Best Tools to Design Database Schemas Visually in 2025

10
Comments 3
7 min read
How to add rate limiting to your API using TigerBeetle

How to add rate limiting to your API using TigerBeetle

8
Comments 2
8 min read
Data Masking in Real-time Replication

Data Masking in Real-time Replication

Comments
5 min read
How I do local development CockroachDB Backups

How I do local development CockroachDB Backups

Comments
2 min read
Understanding BSON for Java Developers: A Beginner’s Guide to MongoDB’s Data Format

Understanding BSON for Java Developers: A Beginner’s Guide to MongoDB’s Data Format

8
Comments 1
16 min read
Diagnosing and fixing critical PostgreSQL performance issues: A deep dive

Diagnosing and fixing critical PostgreSQL performance issues: A deep dive

6
Comments 1
14 min read
23ai — Analyzing Optimizer Environment Using DBA_HIST_OPTIMIZER_ENV_DETAILS

23ai — Analyzing Optimizer Environment Using DBA_HIST_OPTIMIZER_ENV_DETAILS

Comments
3 min read
Running MongoDB in Docker: A Simple Guide

Running MongoDB in Docker: A Simple Guide

Comments
2 min read
Getting the Available Ranges from Two Tables — From SQL to SPL #34

Getting the Available Ranges from Two Tables — From SQL to SPL #34

9
Comments 3
3 min read
Building My First Full-Stack App: Part 3 - Integrating the Database with PostgreSQL & Knex.js

Building My First Full-Stack App: Part 3 - Integrating the Database with PostgreSQL & Knex.js

1
Comments 1
10 min read
Odoo Database Table Naming Quirk

Odoo Database Table Naming Quirk

1
Comments
1 min read
New Tech Talk Proposal 😎 Just Dropped

New Tech Talk Proposal 😎 Just Dropped

2
Comments 1
2 min read
MongoDB Access Control: Creating Secure Users with Custom Roles

MongoDB Access Control: Creating Secure Users with Custom Roles

Comments 1
3 min read
NyaruDB2: A Mobile-First Experiment in Table Partitioning for iOS

NyaruDB2: A Mobile-First Experiment in Table Partitioning for iOS

Comments
2 min read
Efficient Progress Aggregation in a Deeply Nested Task Hierarchy with Real-Time Sync (PostgreSQL + PowerSync)

Efficient Progress Aggregation in a Deeply Nested Task Hierarchy with Real-Time Sync (PostgreSQL + PowerSync)

2
Comments
2 min read
Finally Completed Designing Data Intensive Application Book

Finally Completed Designing Data Intensive Application Book

2
Comments 2
2 min read
$graphLookup (Connect By / Recursive Query)

$graphLookup (Connect By / Recursive Query)

4
Comments
2 min read
Database Connection in Python, Go, and JavaScript

Database Connection in Python, Go, and JavaScript

1
Comments
1 min read
I built a blazing-fast AI-Powered SQL editor ⚡️

I built a blazing-fast AI-Powered SQL editor ⚡️

Comments
2 min read
Managing Secrets in PCI-DSS Compliant Docker Environments: Techniques and Tools for Secure Handling

Managing Secrets in PCI-DSS Compliant Docker Environments: Techniques and Tools for Secure Handling

5
Comments
3 min read
🚀 Zero-Config Database Setup with Drizzle ORM - From Zero to Hero in 30 Seconds

🚀 Zero-Config Database Setup with Drizzle ORM - From Zero to Hero in 30 Seconds

5
Comments 2
3 min read
$elemMatch and Multi-Key Indexes

$elemMatch and Multi-Key Indexes

13
Comments 1
4 min read
The Data Lakehouse: Unifying Data Lakes and Warehouses for Modern Analytics

The Data Lakehouse: Unifying Data Lakes and Warehouses for Modern Analytics

Comments 1
7 min read
loading...