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.
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
Resilience Testing- Why It Matters More Than Ever

Resilience Testing- Why It Matters More Than Ever

Comments
2 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
Setting Up PostgreSQL on macOS: A Fresh Start Guide

Setting Up PostgreSQL on macOS: A Fresh Start Guide

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
An MCP server that operates the EdgeDB database

An MCP server that operates the EdgeDB database

Comments
2 min read
Building resilient Go applications: Simple tip for mocking and testing database error responses

Building resilient Go applications: Simple tip for mocking and testing database error responses

3
Comments
8 min read
What are knowledge graphs and why is everyone talking about them?

What are knowledge graphs and why is everyone talking about them?

13
Comments
6 min read
Migrating from MySQL 8 to PostgreSQL 17 on Ubuntu 24.04 LTS

Migrating from MySQL 8 to PostgreSQL 17 on Ubuntu 24.04 LTS

Comments
3 min read
Accessing AWS DocumentDB via SSH Tunnel Using Python

Accessing AWS DocumentDB via SSH Tunnel Using Python

2
Comments
2 min read
How Sharding and Partitioning Help Scale Your Product Efficiently

How Sharding and Partitioning Help Scale Your Product Efficiently

Comments
2 min read
What's new in Surrealist 3.4

What's new in Surrealist 3.4

26
Comments
3 min read
Scaling multi-tenant Go applications: Choosing the right database partitioning approach

Scaling multi-tenant Go applications: Choosing the right database partitioning approach

14
Comments
8 min read
Simplifying Programmatic Database Handling

Simplifying Programmatic Database Handling

Comments
4 min read
loading...