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.
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
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
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
What Breaks When You Migrate Petabytes: A Field Guide
prajaktashende profile

What Breaks When You Migrate Petabytes: A Field Guide

#database #aws #googlecloud #dataengineering
1
Comments
4 min read
Where a slow call spends its time. SQL took 0.2 ms; the wait was six round trips
sibi_s_130d5df2798dfc3179 profile

Where a slow call spends its time. SQL took 0.2 ms; the wait was six round trips

#cloudflare #performance #database #ai
1
Comments 1
3 min read
Is AI Still Lacking Systems Thinking?
ruxozheng profile

Is AI Still Lacking Systems Thinking?

#ai #architecture #agents #database
Comments
3 min read
A Single SQL Constraint Can Save Your Database From Bad Data — Do You Know Which One?
kailas_warade_d2a15d1ef8a profile

A Single SQL Constraint Can Save Your Database From Bad Data — Do You Know Which One?

#sql #database #tutorial #beginners
Comments
5 min read
Self-hosted Plausible analytics, in one command
moktar_cffd734aa15706ed2c profile

Self-hosted Plausible analytics, in one command

#analytics #automation #database #devops
Comments
2 min read
Buffer Pool and Cache Management for Database Engines
beefedai profile

Buffer Pool and Cache Management for Database Engines

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