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.
Why SQL Still Rules the Data World: Surprising Truths from the Relational Revolution

Why SQL Still Rules the Data World: Surprising Truths from the Relational Revolution

Comments
5 min read
Using Notion Database as a Static CMS with Next.js

Using Notion Database as a Static CMS with Next.js

1
Comments
2 min read
Day 17 of #100DaysOfClickHouse: Mastering Data Filtering for Faster ClickHouse Queries

Day 17 of #100DaysOfClickHouse: Mastering Data Filtering for Faster ClickHouse Queries

Comments
5 min read
PostgreSQL 22P02 Error: Causes and Solutions Complete Guide

PostgreSQL 22P02 Error: Causes and Solutions Complete Guide

Comments
3 min read
Data Consistency Models: From Strong Consistency to Eventual Consistency

Data Consistency Models: From Strong Consistency to Eventual Consistency

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

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

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

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

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

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

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

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

Comments
15 min read
Top 12 SQL Interview Problems for Data Engineers, With Answers

Top 12 SQL Interview Problems for Data Engineers, With Answers

Comments
9 min read
PostgreSQL 22P01 Error: Causes and Solutions Complete Guide

PostgreSQL 22P01 Error: Causes and Solutions Complete Guide

Comments
3 min read
Building a SQL Database in Rust: Reducing Memory Usage with Spans and String Interning

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

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

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

1
Comments
4 min read
Metadata Filtering Before Vector Search: The Recall Win Nobody Measures

Metadata Filtering Before Vector Search: The Recall Win Nobody Measures

Comments
7 min read
Using SurrealDB Graph Queries to Power Video Recommendations

Using SurrealDB Graph Queries to Power Video Recommendations

Comments
8 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.