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.
DuckDB Lance Lakehouse Integration for Vector Search; SQLite Journaling; pgrls RLS Linter

DuckDB Lance Lakehouse Integration for Vector Search; SQLite Journaling; pgrls RLS Linter

Comments 1
3 min read
At what headcount does an internal data flywheel begin to compound meaningfully?

At what headcount does an internal data flywheel begin to compound meaningfully?

Comments
1 min read
Hidden Partitioning: How Iceberg Eliminates Accidental Full Table Scans

Hidden Partitioning: How Iceberg Eliminates Accidental Full Table Scans

Comments
7 min read
OLTP vs OLAP

OLTP vs OLAP

Comments
5 min read
Meilisearch

Meilisearch

Comments
10 min read
Porque o PostgreSQL é tão queridinho?

Porque o PostgreSQL é tão queridinho?

26
Comments
2 min read
Migrating to Apache Iceberg: Strategies for Every Source System

Migrating to Apache Iceberg: Strategies for Every Source System

Comments
7 min read
Semantic Search with PostgreSQL: Pragmatism Beats Hype - Most of the Time

Semantic Search with PostgreSQL: Pragmatism Beats Hype - Most of the Time

5
Comments
8 min read
Our graph database was abandoned upstream — here's the 6-line migration (EngramGraph 0.3.0)

Our graph database was abandoned upstream — here's the 6-line migration (EngramGraph 0.3.0)

Comments 2
2 min read
Sync Supabase via OAuth: No Connection String Needed

Sync Supabase via OAuth: No Connection String Needed

Comments 1
9 min read
I built an audit-friendly SQLite viewer for VSCode because I stopped trusting marketplace extensions

I built an audit-friendly SQLite viewer for VSCode because I stopped trusting marketplace extensions

2
Comments
5 min read
Preventing double-bookings with PostgreSQL exclusion constraints

Preventing double-bookings with PostgreSQL exclusion constraints

Comments
6 min read
The pgAudit Attribution Gap: Why Role-Level Logging Fails GDPR and How to Close It

The pgAudit Attribution Gap: Why Role-Level Logging Fails GDPR and How to Close It

Comments 1
5 min read
SQLite Journaling on SMB, TypeGraph for SQL Graphs, Cross-Engine Migrations

SQLite Journaling on SMB, TypeGraph for SQL Graphs, Cross-Engine Migrations

Comments
3 min read
Chat with your database in plain English — locally, for free

Chat with your database in plain English — locally, for free

Comments
2 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.