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.
Vector Databases (with OpenAI and Supabase) - Part 1

Vector Databases (with OpenAI and Supabase) - Part 1

6
Comments 1
5 min read
SQL Access for AI Agents — Flexibility with Guardrails

SQL Access for AI Agents — Flexibility with Guardrails

Comments
2 min read
Migrate the legacy Greenplum to Apache Cloudberry with cbcopy

Migrate the legacy Greenplum to Apache Cloudberry with cbcopy

Comments
7 min read
Transaction Rollback in MongoDB: What Actually Happens When Things Go Wrong

Transaction Rollback in MongoDB: What Actually Happens When Things Go Wrong

Comments
4 min read
SurrealDB joins the NVIDIA Inception Program

SurrealDB joins the NVIDIA Inception Program

15
Comments
1 min read
The Long Tail Problem: Handling Obscure Queries in Data-Driven Apps

The Long Tail Problem: Handling Obscure Queries in Data-Driven Apps

Comments
2 min read
MongoDB Document Model and CRUD in Practice

MongoDB Document Model and CRUD in Practice

1
Comments
5 min read
How SQLite Replaced PostgreSQL as My First Choice

How SQLite Replaced PostgreSQL as My First Choice

Comments
4 min read
EF Core Bulk Data Operations: Insert and Update Best Practices

EF Core Bulk Data Operations: Insert and Update Best Practices

Comments
3 min read
AWS S3 Vectors: Finally, Cloud Scalable Vector Storage 🚀

AWS S3 Vectors: Finally, Cloud Scalable Vector Storage 🚀

1
Comments
5 min read
From CSV to Insights: Analysing Walmart Sales with Python & PostgreSQL

From CSV to Insights: Analysing Walmart Sales with Python & PostgreSQL

Comments
2 min read
Cassandra-Like Distributed Database

Cassandra-Like Distributed Database

Comments
3 min read
Why Your Health Data Belongs on Your Device (Not the Cloud): A Local-First Manifesto

Why Your Health Data Belongs on Your Device (Not the Cloud): A Local-First Manifesto

1
Comments 2
4 min read
Rethinking Stream-Batch Unification: Real-Time Processing with Incremental Materialized Views in Apache Cloudberry

Rethinking Stream-Batch Unification: Real-Time Processing with Incremental Materialized Views in Apache Cloudberry

Comments
5 min read
Lessons Learned: Choosing a Flink Distribution for Kubernetes (Bitnami vs Official)

Lessons Learned: Choosing a Flink Distribution for Kubernetes (Bitnami vs Official)

Comments
4 min read
Top 5 Backup Formats and When to Use Them for PostgreSQL

Top 5 Backup Formats and When to Use Them for PostgreSQL

Comments
6 min read
Concurrency Control and Database Recovery in SQLite

Concurrency Control and Database Recovery in SQLite

11
Comments 1
4 min read
MLOps: Data Science Lifecycle with DataSets examples, Workflows and Pipelines.

MLOps: Data Science Lifecycle with DataSets examples, Workflows and Pipelines.

Comments
4 min read
The Myth of ‘Just Connect Lambda to RDS’

The Myth of ‘Just Connect Lambda to RDS’

6
Comments
8 min read
State Management Patterns for Long-Running AI Agents: Redis vs StatefulSets vs External Databases

State Management Patterns for Long-Running AI Agents: Redis vs StatefulSets vs External Databases

Comments
3 min read
Practicing SQL with Real Data: INSERT, WHERE, ORDER BY, and GROUP BY

Practicing SQL with Real Data: INSERT, WHERE, ORDER BY, and GROUP BY

1
Comments
3 min read
JOIN FETCH can be slower than N+1: a reproducible Doctrine benchmark (+ 1-row-per-entity JSON aggregation)

JOIN FETCH can be slower than N+1: a reproducible Doctrine benchmark (+ 1-row-per-entity JSON aggregation)

1
Comments 2
2 min read
Craft and Control Resource Pools on MSSQL

Craft and Control Resource Pools on MSSQL

Comments
3 min read
Managing Mini-Page Memory: The Buffer Pool Behind Bf-Tree

Managing Mini-Page Memory: The Buffer Pool Behind Bf-Tree

15
Comments
4 min read
DB-Toolkit - Database Management Made Simple

DB-Toolkit - Database Management Made Simple

Comments
1 min read
loading...