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.
Database Partitioning & Sharding: How to Distribute Massive Datasets
tanu_priya profile

Database Partitioning & Sharding: How to Distribute Massive Datasets

#architecture #backend #database #systemdesign
Comments
7 min read
Building TRACE: An Agentic Fraud Investigation System with TigerGraph and Gemini
krapnshiii16 profile

Building TRACE: An Agentic Fraud Investigation System with TigerGraph and Gemini

#ai #python #database #learning
Comments
5 min read
Zero updated rows do not fail a D1 batch: testing the rollback boundary
hirodeath profile

Zero updated rows do not fail a D1 batch: testing the rollback boundary

#cloudflare #sql #database #javascript
1
Comments 2
4 min read
Customer Segmentation in SQL With CASE WHEN
michaelnocito profile

Customer Segmentation in SQL With CASE WHEN

#sql #database #tutorial #beginners
Comments
14 min read
How to Practice SQL Online With Nothing Installed (And Where Your Data Goes)
michaelnocito profile

How to Practice SQL Online With Nothing Installed (And Where Your Data Goes)

#sql #database #tutorial #beginners
Comments
11 min read
Where to Get a Sample Database to Practice SQL (And How to Check It Loaded)
michaelnocito profile

Where to Get a Sample Database to Practice SQL (And How to Check It Loaded)

#sql #database #tutorial #beginners
Comments
13 min read
NOT IN can be executed as an Anti-Join (NOT EXISTS) in PG19
franckpachot profile

NOT IN can be executed as an Anti-Join (NOT EXISTS) in PG19

#postgres #sql #database #performance
Comments 2
7 min read
Day 35: Start and Enable Are Different Promises, and the Slow Thing Goes First
ndcodes profile

Day 35: Start and Enable Are Different Promises, and the Slow Thing Goes First

#devops #docker #aws #database
14
Comments 3
5 min read
SQL Comment Syntax by Database: MySQL, PostgreSQL, SQL Server, SQLite, Oracle
michaelnocito profile

SQL Comment Syntax by Database: MySQL, PostgreSQL, SQL Server, SQLite, Oracle

#sql #database #tutorial #beginners
Comments
5 min read
NULL in SQL: Why = NULL Finds Nothing and What to Write Instead
michaelnocito profile

NULL in SQL: Why = NULL Finds Nothing and What to Write Instead

#sql #database #tutorial #beginners
Comments
14 min read
How to Find Duplicate Rows in SQL (and Decide What Counts as One)
michaelnocito profile

How to Find Duplicate Rows in SQL (and Decide What Counts as One)

#sql #database #tutorial #beginners
Comments
15 min read
Month-over-Month Growth in SQL: LAG, the Growth Formula, and the Traps
michaelnocito profile

Month-over-Month Growth in SQL: LAG, the Growth Formula, and the Traps

#sql #database #tutorial #beginners
Comments
15 min read
COMMENT ON TABLE: How to Store a Table Description in the Database Itself
michaelnocito profile

COMMENT ON TABLE: How to Store a Table Description in the Database Itself

#sql #database #tutorial #beginners
Comments
6 min read
Which SQL Database Should You Install?
michaelnocito profile

Which SQL Database Should You Install?

#sql #database #tutorial #beginners
Comments
6 min read
DDL and DML WHAT ARE THEY?
super_b8c82b4153dee9fab1c profile

DDL and DML WHAT ARE THEY?

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