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.
Understanding SQL Joins and SQL Functions, CTEs and Subqueries.
josengash profile

Understanding SQL Joins and SQL Functions, CTEs and Subqueries.

#beginners #database #sql #tutorial
Comments
4 min read
Practicing “Database Insights”: where to find real schemas?
acaciaman profile
Karlis

Practicing “Database Insights”: where to find real schemas?

#discuss #ai #database #data
Comments
1 min read
SQLite CLI Prompts, PostgreSQL Load Balancing with pgkeeper, PgBouncer Tuning
soytuber profile
soy

SQLite CLI Prompts, PostgreSQL Load Balancing with pgkeeper, PgBouncer Tuning

#database #sql #sqlite
Comments
3 min read
How to Migrate MySQL to PostgreSQL Without Breaking Everything (With Real Examples)
rehman_afzal_536 profile

How to Migrate MySQL to PostgreSQL Without Breaking Everything (With Real Examples)

#database #postgressql #mysql #sql
Comments
5 min read
Automated SQL Migration Review with Real CLI Output (MySQL, PostgreSQL, TiDB)
fanduzi profile
Fan()

Automated SQL Migration Review with Real CLI Output (MySQL, PostgreSQL, TiDB)

#showdev #cli #database #sql
2
Comments
8 min read
Modeling 1 enrollment = N seats: when a table name lies
michelfaure profile

Modeling 1 enrollment = N seats: when a table name lies

#database #softwareengineering #postgres #architecture
Comments
6 min read
Modéliser 1 inscription = N places : quand le nom d'une table ment
michelfaure profile

Modéliser 1 inscription = N places : quand le nom d'une table ment

#database #softwareengineering #postgres #architecture
Comments
7 min read
Why I Built an Alternative to Sentry (That Doesn’t Overcomplicate Monitoring)
tomurashigaraki22 profile

Why I Built an Alternative to Sentry (That Doesn’t Overcomplicate Monitoring)

#testing #monitoring #uptime #database
Comments
2 min read
Read-Modify-Write isolation in NoSQL: the distributed-lock hell.
hugo_vantighem profile

Read-Modify-Write isolation in NoSQL: the distributed-lock hell.

#architecture #database #distributedsystems #systemdesign
Comments 1
3 min read
Stop Hardcoding Country Lists — Use a Proper World Geo Dataset (MySQL + JSON + CSV)
rakshitshah94 profile

Stop Hardcoding Country Lists — Use a Proper World Geo Dataset (MySQL + JSON + CSV)

#webdev #database #sql #beginners
1
Comments
3 min read
Get Real Row Counts in GBase 8s Without UPDATE STATISTICS
michaelfv profile

Get Real Row Counts in GBase 8s Without UPDATE STATISTICS

#gbase #database #数据库
2
Comments
1 min read
We Ran One SQL Query… And Broke Production
cicd_samurai profile

We Ran One SQL Query… And Broke Production

#devops #database #sql #security
Comments
3 min read
SQLite Internals & PostgreSQL Multi-Master Replication Updates
soytuber profile
soy

SQLite Internals & PostgreSQL Multi-Master Replication Updates

#database #sql #sqlite
Comments
3 min read
MCP tool descriptions are part of your security model
mads_hansen_27b33ebfee4c9 profile

MCP tool descriptions are part of your security model

#mcp #security #ai #database
Comments
2 min read
Cutting a MySQL table in half with one line
andreasbergstrom profile

Cutting a MySQL table in half with one line

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