Forem

Database

Posts on building, using, and learning about databases.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
PostgreSQL Ignored My Index — Until I Fought Back (A Planner Battle Story)

PostgreSQL Ignored My Index — Until I Fought Back (A Planner Battle Story)

1
Comments
3 min read
How I Replaced Python with C in My Project
Cover image for How I Replaced Python with C in My Project

How I Replaced Python with C in My Project

3
Comments 2
4 min read
TRANSACTIONS IN DATABASE
Cover image for TRANSACTIONS IN DATABASE

TRANSACTIONS IN DATABASE

Comments
2 min read
Compression Algorithms You Probably Inherited: gzip, Snappy, LZ4, zstd
Cover image for Compression Algorithms You Probably Inherited: gzip, Snappy, LZ4, zstd

Compression Algorithms You Probably Inherited: gzip, Snappy, LZ4, zstd

7
Comments
4 min read
How I Created an API That Enhances the Performance of ChatGPT
Cover image for How I Created an API That Enhances the Performance of ChatGPT

How I Created an API That Enhances the Performance of ChatGPT

1
Comments
3 min read
Optimizing SQL queries for your AI Agents.
Cover image for Optimizing SQL queries for your AI Agents.

Optimizing SQL queries for your AI Agents.

6
Comments
4 min read
A Guide to Cleaning and Organizing Customer Data
Cover image for A Guide to Cleaning and Organizing Customer Data

A Guide to Cleaning and Organizing Customer Data

Comments
2 min read
PgDog: Your New Best Friend for PostgreSQL Management
Cover image for PgDog: Your New Best Friend for PostgreSQL Management

PgDog: Your New Best Friend for PostgreSQL Management

Comments
3 min read
Oracle 21c – pdbTimezone Parameter in DBCA Command

Oracle 21c – pdbTimezone Parameter in DBCA Command

Comments 2
1 min read
Finding and Remediating Idle AWS Databases Made Easy
Cover image for Finding and Remediating Idle AWS Databases Made Easy

Finding and Remediating Idle AWS Databases Made Easy

Comments
24 min read
Azure SQL Database vs. SQL Managed Instance: A Developer’s Guide to Choosing the Right Service
Cover image for Azure SQL Database vs. SQL Managed Instance: A Developer’s Guide to Choosing the Right Service

Azure SQL Database vs. SQL Managed Instance: A Developer’s Guide to Choosing the Right Service

1
Comments 2
3 min read
dynq: a free analytic query and data processing CLI tool for DynamoDB

dynq: a free analytic query and data processing CLI tool for DynamoDB

Comments
1 min read
What is redis pipeline

What is redis pipeline

1
Comments
2 min read
AI in Warehouses: Because Human Errors Are Too Expensive

AI in Warehouses: Because Human Errors Are Too Expensive

1
Comments
3 min read
Don’t Use SQL If Your Client Doesn’t Know What They Want

Don’t Use SQL If Your Client Doesn’t Know What They Want

Comments 2
2 min read
JavaRaft: Raft Distributed Consensus Protocol

JavaRaft: Raft Distributed Consensus Protocol

Comments
10 min read
Amazon RDS Unlocked: Your Ultimate Guide to Managed Databases in AWS (2025 Edition)
Cover image for Amazon RDS Unlocked: Your Ultimate Guide to Managed Databases in AWS (2025 Edition)

Amazon RDS Unlocked: Your Ultimate Guide to Managed Databases in AWS (2025 Edition)

6
Comments 1
12 min read
Recursion in SQL: Unlocking Trees and Graphs with Recursive CTEs

Recursion in SQL: Unlocking Trees and Graphs with Recursive CTEs

Comments
3 min read
Navigating the Landscape of Data-Modeling – A Comprehensive Guide
Cover image for Navigating the Landscape of Data-Modeling – A Comprehensive Guide

Navigating the Landscape of Data-Modeling – A Comprehensive Guide

Comments 2
4 min read
Atlas Device Sync

Atlas Device Sync

Comments 2
2 min read
Build a Real-Time Analytics API for a Fitness App with Tinybird

Build a Real-Time Analytics API for a Fitness App with Tinybird

Comments 1
5 min read
Redis cheatsheet

Redis cheatsheet

2
Comments
2 min read
Mastering SQL Window Functions: ROW_NUMBER vs RANK vs DENSE_RANK

Mastering SQL Window Functions: ROW_NUMBER vs RANK vs DENSE_RANK

Comments
2 min read
🎯 Day 18 – Revised @PostMapping & @GetMapping, Started @PutMapping in Spring Boot

🎯 Day 18 – Revised @PostMapping & @GetMapping, Started @PutMapping in Spring Boot

Comments 3
1 min read
Mastering SQL Joins: Your Definitive Guide to Relational Data Mastery

Mastering SQL Joins: Your Definitive Guide to Relational Data Mastery

Comments
2 min read
loading...