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.
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
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
Postgres RLS in Symfony: a setup check for a missing FORCE, and two ways it says "nothing to report" without looking
mollenthiel profile

Postgres RLS in Symfony: a setup check for a missing FORCE, and two ways it says "nothing to report" without looking

#symfony #php #postgres #database
1
Comments 3
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
I benchmarked CognoDB against four other graph databases. The most interesting result had nothing to do with CognoDB.
sachin_meru profile

I benchmarked CognoDB against four other graph databases. The most interesting result had nothing to do with CognoDB.

#webdev #database #devops #benchmarking
Comments 1
5 min read
GIT WORKFLOW
kbonymark profile

GIT WORKFLOW

#ai #python #github #database
Comments
2 min read
Power BI: Data Modelling, Relationships and Joins
smumbi_ profile

Power BI: Data Modelling, Relationships and Joins

#analytics #data #database
1
Comments
7 min read
Postgres Won't Let Me Double-Book a Parking Slot: Exclusion Constraints in Practice
rakno profile

Postgres Won't Let Me Double-Book a Parking Slot: Exclusion Constraints in Practice

#postgres #database #typescript #systemdesign
Comments 2
5 min read
Schema catalogs for AI assistants: the layer nobody wants to maintain
vincenzo_nudo_842cddd9973 profile

Schema catalogs for AI assistants: the layer nobody wants to maintain

#ai #postgres #database #mcp
1
Comments
6 min read
PostgreSQL 19's data checksums can now be switched on without stopping the server

Benchmark shows minimal write throughput impact
alexgeorgiev17 profile

PostgreSQL 19's data checksums can now be switched on without stopping the server

#postgres #database #devops #performance
14
Comments 2
7 min read
I benchmarked 5 graph databases. The first four hours measured the Indian Ocean.
burz4m_13b009bb9f0a92a88c profile

I benchmarked 5 graph databases. The first four hours measured the Indian Ocean.

#showdev #database #benchmarking #devops
Comments
6 min read
My alert fired 7 times across 1963 pairs. I assumed the thresholds were too high. They were, and it didn't matter
juanauriti profile

My alert fired 7 times across 1963 pairs. I assumed the thresholds were too high. They were, and it didn't matter

#monitoring #database #sql #webdev
3
Comments
4 min read
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
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.