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.
Window Functions vs Aggregate Functions in SQL: A Beginner-Friendly Guide

Window Functions vs Aggregate Functions in SQL: A Beginner-Friendly Guide

1
Comments
11 min read
EasyJPA: Type-Safe Dynamic Queries in Three Lines, Not Thirty

EasyJPA: Type-Safe Dynamic Queries in Three Lines, Not Thirty

Comments
8 min read
How to Query Server and Application Logs with SQL (No ELK Stack or Cloud Uploads)

How to Query Server and Application Logs with SQL (No ELK Stack or Cloud Uploads)

Comments
3 min read
Lithair learns SQL — and lists everything it refuses to promise

Lithair learns SQL — and lists everything it refuses to promise

Comments
5 min read
Power BI: Data Modelling, Relationships and Joins

Power BI: Data Modelling, Relationships and Joins

Comments
12 min read
Building a Hybrid RAG System: Combining Neo4j Graph Memory with Vector Search

Building a Hybrid RAG System: Combining Neo4j Graph Memory with Vector Search

Comments
3 min read
Power BI Technical Article: Data Modelling, Relationships & Joins

Power BI Technical Article: Data Modelling, Relationships & Joins

Comments
9 min read
I’m building Permetra an open-source access graph for Supabase

I’m building Permetra an open-source access graph for Supabase

Comments
1 min read
How to monitor PostgreSQL connections, cache hit ratio and replication lag (and get paged before it hurts)

How to monitor PostgreSQL connections, cache hit ratio and replication lag (and get paged before it hurts)

Comments
4 min read
My retrieval counted the same text three times

My retrieval counted the same text three times

Comments
4 min read
Automating SQLite Database Backups with Python and Cron on Linux

Automating SQLite Database Backups with Python and Cron on Linux

Comments
2 min read
How Does a Database Let Everyone Read and Write at Once?

How Does a Database Let Everyone Read and Write at Once?

Comments
19 min read
Lemmalog: Agent Memory as a Deductive Database, Not Another Vector Store

Lemmalog: Agent Memory as a Deductive Database, Not Another Vector Store

Comments
2 min read
The Postgres job-claim query that silently claims the same job twice

The Postgres job-claim query that silently claims the same job twice

Comments
9 min read
The Science of Machine Learning vs. the Push for AI Deployment

The Science of Machine Learning vs. the Push for AI Deployment

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