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
mark_glemba_962f6bc8a12dd profile

Window functions vs Aggregate functions

#analytics #database #datascience #sql
Comments
9 min read
Building Vektor: Natural Language In, Validated PostgreSQL Schemas Out 🚀
tommasoprivitera profile

Building Vektor: Natural Language In, Validated PostgreSQL Schemas Out 🚀

#webdev #ai #database
1
Comments 1
2 min read
Column Comments in PostgreSQL and MySQL: How to Document Columns Without a Migration
tbson87 profile

Column Comments in PostgreSQL and MySQL: How to Document Columns Without a Migration

#database #documentation #sql #postgres
Comments 1
7 min read
MariaDB 10.6 to 13.0 for WordPress: Only One Upgrade Actually Does Anything [Benchmark]
make-wp-fast profile

MariaDB 10.6 to 13.0 for WordPress: Only One Upgrade Actually Does Anything [Benchmark]

#database #performance #sql #wordpress
Comments
10 min read
Chinilpa Scanner (친일파 스캐너): Korea's Collaborator Database, Explained
cc_h_6385c1b4fc86a8b8e2d7 profile
CC H

Chinilpa Scanner (친일파 스캐너): Korea's Collaborator Database, Explained

#database #software #tools
Comments
10 min read
Top Vector Databases for AI Agents in 2026: Qdrant vs Pinecone vs Weaviate vs PgVector vs Milvus
agdex_ai profile

Top Vector Databases for AI Agents in 2026: Qdrant vs Pinecone vs Weaviate vs PgVector vs Milvus

#vectordb #aiagents #database #python
Comments
3 min read
Recursive CTEs: How SQL Secretly Learned to Loop
rahmanfrr profile

Recursive CTEs: How SQL Secretly Learned to Loop

#sql #database #programming #tutorial
Comments 3
3 min read
I Gave Five Graph Databases 256MB of RAM Each. Here's What Broke.
sree_charan profile

I Gave Five Graph Databases 256MB of RAM Each. Here's What Broke.

#database #graphql #cloud #devops
1
Comments 2
6 min read
I gave five graph databases 256 MB of RAM and asked them the same question
manikanta_yarramneedi_ profile

I gave five graph databases 256 MB of RAM and asked them the same question

#cloud #database #performance
Comments
7 min read
MedusaJS Dropped the Foreign Keys Between Its Modules: The defineLink Gamble
andriiboyko profile

MedusaJS Dropped the Foreign Keys Between Its Modules: The defineLink Gamble

#node #ecommerce #database #typescript
16
Comments 5
9 min read
Text-to-SQL in Practice: When to Trust AI Output and When to Gate It
databaseinsights profile

Text-to-SQL in Practice: When to Trust AI Output and When to Gate It

#sql #ai #database #devops
Comments 1
4 min read
Understanding Data Modeling in Power BI
anthony_kibet_4f0cc67d37f profile

Understanding Data Modeling in Power BI

#analytics #data #database
Comments
8 min read
Sentinel: Ingest Path and Log Schema
virorum profile

Sentinel: Ingest Path and Log Schema

#architecture #backend #database #systemdesign
Comments
16 min read
A snapshot-style ops dashboard with nothing but the Python standard library
takahiro_hashito_a1f3f0dc profile

A snapshot-style ops dashboard with nothing but the Python standard library

#python #database #webdev
Comments
5 min read
Reverse-Engineering Messy Databases: My End-to-End Data Audits Across 17,000+ Relational Schema Logs
hafsa_motiwala profile

Reverse-Engineering Messy Databases: My End-to-End Data Audits Across 17,000+ Relational Schema Logs

#showdev #datascience #database #sql
1
Comments
4 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.