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.
PostgreSQL 22P02 Error: Causes and Solutions Complete Guide
dbmserror profile

PostgreSQL 22P02 Error: Causes and Solutions Complete Guide

#postgres #database #dba #sql
Comments
3 min read
Data Consistency Models: From Strong Consistency to Eventual Consistency
veduis profile

Data Consistency Models: From Strong Consistency to Eventual Consistency

#architecture #database #distributedsystems #systemdesign
Comments
10 min read
KoutenDB: Data Locality as a First-Stage Retrieval Index
puffball1567 profile

KoutenDB: Data Locality as a First-Stage Retrieval Index

#database #search #rag #llm
Comments
6 min read
Vertica vs VoltDB (Volt Active Data): Key Differences, Use Cases & How to Choose in 2026
andrewll profile

Vertica vs VoltDB (Volt Active Data): Key Differences, Use Cases & How to Choose in 2026

#architecture #database #dataengineering #distributedsystems
Comments
7 min read
Installing GDOM with PostgreSQL as the Backend Database
michaelfv profile

Installing GDOM with PostgreSQL as the Backend Database

#gbase #database #æ•°æźćș“ #postgres
2
Comments
3 min read
System Design - 22. Consistent Hashing: The Algorithm That Lets Cassandra Add a Server Without Breaking Everything
rajkiran_389 profile

System Design - 22. Consistent Hashing: The Algorithm That Lets Cassandra Add a Server Without Breaking Everything

#softwaredevelopment #systemdesign #database #distributedsystems
Comments
7 min read
DuckDB-Iceberg v1.5.3 Features, SQLite R-Tree -0.0 Bug, and pg_kpart for PostgreSQL Partitioning
soytuber profile
soy

DuckDB-Iceberg v1.5.3 Features, SQLite R-Tree -0.0 Bug, and pg_kpart for PostgreSQL Partitioning

#database #sql #sqlite
Comments
3 min read
I Reduced a 12-Second SQL Query to 300ms Without Changing the Server
aasimghaffar profile

I Reduced a 12-Second SQL Query to 300ms Without Changing the Server

#database #sql #productivity #api
Comments 1
4 min read
Digital Trainee Struggles with SQL SELECT Queries and Table Relationships: Targeted Practice and Mentorship Offer Solutions
serbyte profile

Digital Trainee Struggles with SQL SELECT Queries and Table Relationships: Targeted Practice and Mentorship Offer Solutions

#sql #database #normalization #joins
Comments
15 min read
PostgreSQL 22P01 Error: Causes and Solutions Complete Guide
dbmserror profile

PostgreSQL 22P01 Error: Causes and Solutions Complete Guide

#postgres #database #dba #sql
Comments
3 min read
Building a SQL Database in Rust: Reducing Memory Usage with Spans and String Interning
musab0986 profile

Building a SQL Database in Rust: Reducing Memory Usage with Spans and String Interning

#help #rust #database #compiling
Comments
2 min read
When Code "Works" by Accident: Hunting Down an Undocumented Fallback in node-pg-migrate 🔍

Summer Bug Smash: Smash Stories Submission 🐛đŸ›č
lksferreira profile

When Code "Works" by Accident: Hunting Down an Undocumented Fallback in node-pg-migrate 🔍

#devchallenge #bugsmash #node #database
8
Comments 4
4 min read
Day 16: ClickHouse Dictionaries – Eliminating Expensive JOINs with High-Speed In-Memory Lookups
kanishga_subramani_49ad73 profile

Day 16: ClickHouse Dictionaries – Eliminating Expensive JOINs with High-Speed In-Memory Lookups

#clickhouse #database #dataengineering #devops
1
Comments
4 min read
Using SurrealDB Graph Queries to Power Video Recommendations
ahmet_gedik778845 profile

Using SurrealDB Graph Queries to Power Video Recommendations

#surrealdb #php #database #webdev
Comments
8 min read
Why Your SaaS Multi-Tenancy Logic Will Eventually Break
ntty profile
Ntty

Why Your SaaS Multi-Tenancy Logic Will Eventually Break

#architecture #database #saas #security
1
Comments 1
3 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.