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.
Stop Paying for Vector Databases: How to Build AI Search in Postgres
zilton7 profile

Stop Paying for Vector Databases: How to Build AI Search in Postgres

#rails #ai #database #postgres
Comments
4 min read
ClickHouse ReplacingMergeTree - Why Your Row Count Does Not Match
ankitmalikg profile

ClickHouse ReplacingMergeTree - Why Your Row Count Does Not Match

#clickhouse #database #warehouse #analytics
1
Comments
4 min read
The database has to be a defensive boundary again
debba profile

The database has to be a defensive boundary again

#programming #opensource #database #mcp
1
Comments 2
3 min read
PostgreSQL Foreign Data Wrappers: Cross-Database Queries Explained
philip_mcclarence_2ef9475 profile

PostgreSQL Foreign Data Wrappers: Cross-Database Queries Explained

#database #dataengineering #postgres #sql
Comments
4 min read
🌙 Late Night Chronicles: #4 Understanding MySQL Data Types
shreyash_ogale profile

🌙 Late Night Chronicles: #4 Understanding MySQL Data Types

#beginners #database #mysql #sql
Comments
2 min read
Persistent Chat History with Database Design (Practical Example)
janefrances profile

Persistent Chat History with Database Design (Practical Example)

#backenddevelopment #database #backend #databasedesign
Comments
7 min read
UPSERT in MySQL, PostgreSQL, SQLite & MS SQL Server — A Complete Comparison
digipackhq profile

UPSERT in MySQL, PostgreSQL, SQLite & MS SQL Server — A Complete Comparison

#sql #database #python #beginners
2
Comments
2 min read
Running Postgres at Scale: Lessons Learned
samson_tanimawo profile

Running Postgres at Scale: Lessons Learned

#sre #devops #postgres #database
Comments
2 min read
null=True on CharField Is Always Wrong — Here Is Why
h_coder profile

null=True on CharField Is Always Wrong — Here Is Why

#django #python #database #backend
4
Comments
3 min read
Vector Database Performance Compared: pgvector vs Pinecone vs Qdrant vs Weaviate
kencho profile
Giorgi

Vector Database Performance Compared: pgvector vs Pinecone vs Qdrant vs Weaviate

#vectordatabase #database #machinelearning
Comments
6 min read
How to Find the Postgres Indexes Your Planner Never Picks (I Found 20 of 51)

78% index disk waste revealed by custom tools
alimafana profile

How to Find the Postgres Indexes Your Planner Never Picks (I Found 20 of 51)

#postgres #database #performance #sql
15
Comments 5
10 min read
ETL vs ELT: Two Paradigms, One Goal
edmund_eryuba profile

ETL vs ELT: Two Paradigms, One Goal

#dataengineering #datascience #database #cicd
Comments
5 min read
How to Master SQLAlchemy I/O: Testing Queries in CI to Prevent Database Disasters 🚨
fmartins profile

How to Master SQLAlchemy I/O: Testing Queries in CI to Prevent Database Disasters 🚨

#cicd #database #python #testing
Comments
6 min read
Mastering GBase 8s Triggers: A Practical Guide to REFERENCING NEW and OLD for Smarter Data Control
scale_b4260f8ecad7f02306d profile

Mastering GBase 8s Triggers: A Practical Guide to REFERENCING NEW and OLD for Smarter Data Control

#gbase #database
3
Comments
2 min read
GDPR Erasure Is Not DELETE FROM users
sharjeelz profile

GDPR Erasure Is Not DELETE FROM users

#laravel #gdpr #database #security
1
Comments
6 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.