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.
DataFrames & SQL in Databricks: Reading, Writing, and Transforming Data

DataFrames & SQL in Databricks: Reading, Writing, and Transforming Data

1
Comments
6 min read
From Tables to Tides: Navigating Databases, Warehouses, Marts, Lakes, and the Lakehouse Revolution

From Tables to Tides: Navigating Databases, Warehouses, Marts, Lakes, and the Lakehouse Revolution

1
Comments
7 min read
PostgreSQL Logical Replication: Setup, Monitoring & Troubleshooting

PostgreSQL Logical Replication: Setup, Monitoring & Troubleshooting

Comments
4 min read
How Power BI is Used in Real-World Data Analysis

How Power BI is Used in Real-World Data Analysis

Comments
2 min read
Vector Databases for AI (Milvus/Pinecone)

Vector Databases for AI (Milvus/Pinecone)

1
Comments
8 min read
DuckDB Streaming, SQLite BLOB Output, & Securing Postgres for AI Agents

DuckDB Streaming, SQLite BLOB Output, & Securing Postgres for AI Agents

1
Comments
3 min read
PostgreSQL Design at Scale: Normalization vs JSONB (A Real-World Guide)

PostgreSQL Design at Scale: Normalization vs JSONB (A Real-World Guide)

1
Comments
4 min read
Why Application-Layer Audit Trails Fail (and How PostgreSQL Triggers Fix It)

Why Application-Layer Audit Trails Fail (and How PostgreSQL Triggers Fix It)

1
Comments
4 min read
Monitor Manticore Search in Grafana with One Command

Monitor Manticore Search in Grafana with One Command

Comments
4 min read
I built a Graph database to catch money launderers. Here's what I actually learned.

I built a Graph database to catch money launderers. Here's what I actually learned.

Comments
5 min read
Indexing Strategies for Faster Database Queries

Indexing Strategies for Faster Database Queries

1
Comments
7 min read
No Indexes, No Parameters, No Problem

No Indexes, No Parameters, No Problem

Comments
4 min read
Build SQL Queries Without Writing SQL

Build SQL Queries Without Writing SQL

Comments
2 min read
How to Export a PostgreSQL Database from a Docker Container (pg_dump Guide)

How to Export a PostgreSQL Database from a Docker Container (pg_dump Guide)

Comments
2 min read
Graph RAG does not need a graph database. It needs a database that does everything.

Graph RAG does not need a graph database. It needs a database that does everything.

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