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.
The Engineering Behind Fast Analytics: Columnar Storage Explained

The Engineering Behind Fast Analytics: Columnar Storage Explained

1
Comments
10 min read
Building Blocks of the Cloud: How to Create and Secure an Azure Storage Account

Building Blocks of the Cloud: How to Create and Secure an Azure Storage Account

5
Comments
5 min read
Vector Databases: Foundations, Function, and the Future of AI Retrieval

Vector Databases: Foundations, Function, and the Future of AI Retrieval

6
Comments
5 min read
ALTER TABLE ... ADD COLUMN

ALTER TABLE ... ADD COLUMN

5
Comments
12 min read
Safeguarding Your PostgreSQL Data: A Practical Guide to pg_dump and pg_restore

Safeguarding Your PostgreSQL Data: A Practical Guide to pg_dump and pg_restore

Comments
5 min read
Beyond Caching: How Redis 8 Became Our Forum's Primary Database and AI Engine

Redis AI Challenge: Beyond the Cache

Beyond Caching: How Redis 8 Became Our Forum's Primary Database and AI Engine

29
Comments 6
5 min read
Mastering Foreign Keys in MySQL: A Comprehensive Guide

Mastering Foreign Keys in MySQL: A Comprehensive Guide

Comments
6 min read
Beginner’s Guide to SQL Server Stored Procedures

Beginner’s Guide to SQL Server Stored Procedures

2
Comments
5 min read
EF Core Query Optimization: A Real-World Case Study

EF Core Query Optimization: A Real-World Case Study

Comments
4 min read
When Cloudflare D1's 2MB Limit Taught Me a Hard Lesson About Database Design

When Cloudflare D1's 2MB Limit Taught Me a Hard Lesson About Database Design

Comments
3 min read
[Share] SQL - A Quick Intro

[Share] SQL - A Quick Intro

Comments
8 min read
⏱️ Taming QuestDB Materialized View Refresh Frequency

⏱️ Taming QuestDB Materialized View Refresh Frequency

Comments
2 min read
PostgreSQL MVCC Internals: From xmin/xmax to Isolation Levels

PostgreSQL MVCC Internals: From xmin/xmax to Isolation Levels

1
Comments
5 min read
SQL vs NoSQL

SQL vs NoSQL

Comments
3 min read
Just Use Postgres 🐘

Just Use Postgres 🐘

1
Comments
9 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.