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.
Pure Shell Script to Compress IPv6 Addresses

Pure Shell Script to Compress IPv6 Addresses

2
Comments
4 min read
Pure Shell Script to Expand IPv6 Addresses

Pure Shell Script to Expand IPv6 Addresses

2
Comments
3 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
The NULL timestamp that broke a TTL sweep and a funnel metric at the same time

The NULL timestamp that broke a TTL sweep and a funnel metric at the same time

Comments
2 min read
Why Fraud Rings Are a Graph Problem (And Your SQL Database Can't See Them)

Why Fraud Rings Are a Graph Problem (And Your SQL Database Can't See Them)

Comments
4 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
Installing GDOM with PostgreSQL as the Backend Database

Installing GDOM with PostgreSQL as the Backend Database

2
Comments
3 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
I Reduced a 12-Second SQL Query to 300ms Without Changing the Server

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

Comments 1
4 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
PostgreSQL 22P01 Error: Causes and Solutions Complete Guide

PostgreSQL 22P01 Error: Causes and Solutions Complete Guide

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