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.
Designing PostgreSQL HA with Patroni, etcd, and HAProxy in Multi-Zone Linux Clusters
hostingpodium profile

Designing PostgreSQL HA with Patroni, etcd, and HAProxy in Multi-Zone Linux Clusters

#postgres #linux #database #sre
Comments
8 min read
CVE-2026-107823: How a Crafted Username Becomes MariaDB Security Metadata
jeffreyciend profile

CVE-2026-107823: How a Crafted Username Becomes MariaDB Security Metadata

#cybersecurity #database #infosec #security
Comments
3 min read
SQL Concepts Using Hospital Data
jkisutsa profile

SQL Concepts Using Hospital Data

#data #database #sql #tutorial
Comments
15 min read
MariaDB's FILE Privilege Is a Filesystem Primitive: CVE-2026-107814 and CVE-2026-107818
stark_zhuang_df5076f35c68 profile

MariaDB's FILE Privilege Is a Filesystem Primitive: CVE-2026-107814 and CVE-2026-107818

#cybersecurity #database #infosec #security
Comments
3 min read
An append-only, hash-chained audit log in SQLite, and a script to check it
nicholasflemmer profile

An append-only, hash-chained audit log in SQLite, and a script to check it

#database #opensource #security
Comments 1
3 min read
Enable RSA key-pair based authentication - GoldenGate to Snowflake (On Premise)
dbcasefiles profile

Enable RSA key-pair based authentication - GoldenGate to Snowflake (On Premise)

#database #security #goldengate #snowflake
Comments
7 min read
5 SQL Window-Function Exercises Taken From Real Business Problems
unpredictableprashant profile

5 SQL Window-Function Exercises Taken From Real Business Problems

#sql #database #beginners #career
Comments
3 min read
Writing SQL in Go Without Losing Type Safety: An Introduction to sqlc
jlamka profile

Writing SQL in Go Without Losing Type Safety: An Introduction to sqlc

#backend #database #go #sql
Comments
2 min read
I Migrated a Cloudflare Agents Workspace and Measured Everything: What Changes When the Storage Format Changes?
tanahiro2010 profile

I Migrated a Cloudflare Agents Workspace and Measured Everything: What Changes When the Storage Format Changes?

#cloudflare #typescript #agents #database
6
Comments 2
15 min read
Building an Offline-First Bible Reader on iOS: Bundled SQLite, Full-Text Search and iCloud-Synced Notes
aryansbtloe profile

Building an Offline-First Bible Reader on iOS: Bundled SQLite, Full-Text Search and iCloud-Synced Notes

#database #ios #mobile #softwaredevelopment
Comments
12 min read
# Stop Breaking Your Next.js App: NextAuth Setup in App Router (with MongoDB)
yashdevelopers profile

# Stop Breaking Your Next.js App: NextAuth Setup in App Router (with MongoDB)

#webdev #programming #javascript #database
Comments
2 min read
How to Auto-Update an updated_at Column: MySQL ON UPDATE vs a Database Trigger vs the ORM
tbson87 profile

How to Auto-Update an updated_at Column: MySQL ON UPDATE vs a Database Trigger vs the ORM

#mysql #postgres #database #sql
Comments
10 min read
SQLite Ignored My ON DELETE CASCADE: Foreign Keys Are Off Until Each Connection Turns Them On
superfunicular profile

SQLite Ignored My ON DELETE CASCADE: Foreign Keys Are Off Until Each Connection Turns Them On

#sqlite #python #database #debugging
Comments
8 min read
PostgreSQL 17 VACUUM Overhaul: Adaptive Radix Trees End the 1GB Limit
syed_anzar profile

PostgreSQL 17 VACUUM Overhaul: Adaptive Radix Trees End the 1GB Limit

#postgres #database #performance #vacuum
Comments
2 min read
Designing data-intensive applications: replication, partitioning, quorums
mseada profile

Designing data-intensive applications: replication, partitioning, quorums

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