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.
Ring buffer in the database

Ring buffer in the database

Comments
3 min read
Struggling with Vendor Lock-In? Why PostgreSQL is Your Exit Strategy?

Struggling with Vendor Lock-In? Why PostgreSQL is Your Exit Strategy?

1
Comments
3 min read
The Ultimate MySQL Queries Cheat Sheet (With Examples & Outputs)

The Ultimate MySQL Queries Cheat Sheet (With Examples & Outputs)

Comments
3 min read
Enforcing Row Level Security in Supabase: A Deep Dive into LockIn's Multi-Tenant Architecture

Enforcing Row Level Security in Supabase: A Deep Dive into LockIn's Multi-Tenant Architecture

Comments 1
8 min read
Oracle 21c — Setting Compression Attribute for Indexes During Import

Oracle 21c — Setting Compression Attribute for Indexes During Import

Comments
2 min read
Designing Scalable SQLite Schemas for Python Apps

Designing Scalable SQLite Schemas for Python Apps

Comments
3 min read
AWS OpenSearch Full Documents Reindexing: When? Why? How?

AWS OpenSearch Full Documents Reindexing: When? Why? How?

1
Comments 1
5 min read
Kimball vs. Inmon: High-Level Design Strategies for Data Warehousing

Kimball vs. Inmon: High-Level Design Strategies for Data Warehousing

1
Comments
6 min read
Part 1: MySQL 8.0 Optimizer Enhancements - SQL Query Optimization Deep Dive

Part 1: MySQL 8.0 Optimizer Enhancements - SQL Query Optimization Deep Dive

Comments
12 min read
DuckDB + Iceberg: The ultimate synergy

DuckDB + Iceberg: The ultimate synergy

Comments
2 min read
Apache Polaris Dev Mailing List — Weekly Digest (Aug 11–17, 2025)

Apache Polaris Dev Mailing List — Weekly Digest (Aug 11–17, 2025)

Comments
4 min read
Comparing RDS PostgreSQL, Athena on S3 JSON, and QuickSight for Scalable Dashboards

Comparing RDS PostgreSQL, Athena on S3 JSON, and QuickSight for Scalable Dashboards

Comments
7 min read
Database Security Patterns for Web Applications

Database Security Patterns for Web Applications

Comments
2 min read
I'm building a Redis Clone in Zig: A Deep Dive into Pub/Sub, and Memory Allocation

I'm building a Redis Clone in Zig: A Deep Dive into Pub/Sub, and Memory Allocation

2
Comments 2
3 min read
EF Core prototyping

EF Core prototyping

3
Comments
2 min read
NodeJs Mongo script query

NodeJs Mongo script query

Comments
1 min read
Run Oracle19c Database in Mac M1/M2 using Docker

Run Oracle19c Database in Mac M1/M2 using Docker

Comments
3 min read
Oracle Database 23ai,19c — RMAN Progress Status Report

Oracle Database 23ai,19c — RMAN Progress Status Report

Comments
3 min read
Amazon ElastiCache Redis as a Vector Embeddings Storage for Semantic Search in AWS Community Blog posts

Amazon ElastiCache Redis as a Vector Embeddings Storage for Semantic Search in AWS Community Blog posts

12
Comments 1
8 min read
Is Cloud SQL Enterprise Plus Worth It? Evaluating the MySQL upgrade at SpareRoom

Is Cloud SQL Enterprise Plus Worth It? Evaluating the MySQL upgrade at SpareRoom

2
Comments
4 min read
Kyrage: A TypeScript-First Database Migration Tool for Modern Development

Kyrage: A TypeScript-First Database Migration Tool for Modern Development

10
Comments 1
6 min read
Design Databases Like a Senior Engineer: My Battle-Tested 7-Step Process

Design Databases Like a Senior Engineer: My Battle-Tested 7-Step Process

1
Comments
2 min read
SQLite dot commands: Output mode separator command

SQLite dot commands: Output mode separator command

2
Comments
2 min read
Text Search With MongoDB (BM25 TF-IDF) and PostgreSQL

Text Search With MongoDB (BM25 TF-IDF) and PostgreSQL

7
Comments
9 min read
What actually is ACID in databases?

What actually is ACID in databases?

1
Comments 1
3 min read
loading...