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.
PgPool2 & PostgreSQL — Bypass SCRAM entirely, use MD5

PgPool2 & PostgreSQL — Bypass SCRAM entirely, use MD5

Comments
2 min read
Extended RUM in DocumentDB extension for PostgreSQL: Efficient ESR (Equality, Sort, Range) Queries

Extended RUM in DocumentDB extension for PostgreSQL: Efficient ESR (Equality, Sort, Range) Queries

Comments
7 min read
How to Pick the Perfect Database Without Losing Your Mind

How to Pick the Perfect Database Without Losing Your Mind

Comments
8 min read
Automating Oracle EBS Data Entry - A Consultant's Guide to Faster Data Loading

Automating Oracle EBS Data Entry - A Consultant's Guide to Faster Data Loading

1
Comments
6 min read
DuckDB 1.5.2 & DuckLake v1.0 Debut, Plus Embedded SQLite in Scripting Engines

DuckDB 1.5.2 & DuckLake v1.0 Debut, Plus Embedded SQLite in Scripting Engines

Comments
3 min read
SQL vs NoSQL Performance Optimization Considerations

SQL vs NoSQL Performance Optimization Considerations

Comments
7 min read
Stop DDoSing Your DB: Queue Concurrency Limits in Laravel 🛑

Stop DDoSing Your DB: Queue Concurrency Limits in Laravel 🛑

1
Comments
2 min read
PostgreSQL 2200D Error: Causes and Solutions Complete Guide

PostgreSQL 2200D Error: Causes and Solutions Complete Guide

Comments
3 min read
From Raw SQL Strings to Type-Safe Queries: How I Learned Prisma ORM

From Raw SQL Strings to Type-Safe Queries: How I Learned Prisma ORM

1
Comments
7 min read
Indexes: Quickstart Using PostgreSQL (15 sec read)

Indexes: Quickstart Using PostgreSQL (15 sec read)

Comments
1 min read
Designing an Audit Log That Actually Helps: Timestamps, Actions, and Forensics

Designing an Audit Log That Actually Helps: Timestamps, Actions, and Forensics

1
Comments 1
5 min read
I built a mini columnar storage engine in pure Python — and finally understood why Parquet is so fast

I built a mini columnar storage engine in pure Python — and finally understood why Parquet is so fast

Comments
6 min read
A practical SQL query tuning playbook: execution plans, joins, indexes, and the traps

A practical SQL query tuning playbook: execution plans, joins, indexes, and the traps

Comments
5 min read
The Future of Query Optimization: AI-Driven Insights in Big Data

The Future of Query Optimization: AI-Driven Insights in Big Data

Comments
7 min read
Vector Databases: The Unsung Hero of Large Language Models and Generative AI

Vector Databases: The Unsung Hero of Large Language Models and Generative AI

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