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.
Does Prisma respect Supabase RLS? No — here's why
emil_alander_7c profile

Does Prisma respect Supabase RLS? No — here's why

#backend #database #postgres #security
Comments 1
6 min read
Postgres as your message queue is a SPOF you'll regret at 3am
adioof profile

Postgres as your message queue is a SPOF you'll regret at 3am

#postgres #architecture #database #debate
3
Comments
3 min read
Don't Give the Model SQL

Real-world health data traps beat prompts
mattstratton profile

Don't Give the Model SQL

#ai #llm #programming #database
14
Comments 8
11 min read
Why Fuzzy Search Alone Produces Bad Food Results
dietly profile

Why Fuzzy Search Alone Produces Bad Food Results

#database #search #postgres #api
5
Comments
5 min read
SQLite vs. PostgreSQL: Two SQL Giants Built for Different Worlds
kahenda profile

SQLite vs. PostgreSQL: Two SQL Giants Built for Different Worlds

#database #productivity
6
Comments 1
1 min read
Day 86: Faster Map Key Lookups in ClickHouse® 26.3 with Bucketed Map Serialization
kanishga_subramani_49ad73 profile

Day 86: Faster Map Key Lookups in ClickHouse® 26.3 with Bucketed Map Serialization

#clickhouse #devops #analytics #database
Comments
6 min read
Day 85: Using naturalSortKey() in ClickHouse® to Sort Version Strings, Filenames, and Numeric Text Naturally
kanishga_subramani_49ad73 profile

Day 85: Using naturalSortKey() in ClickHouse® to Sort Version Strings, Filenames, and Numeric Text Naturally

#clickhouse #devops #analytics #database
Comments
5 min read
Mastering MongoDB Aggregation: From Complex Pipelines to Plain English
maskdatabases profile

Mastering MongoDB Aggregation: From Complex Pipelines to Plain English

#mongodb #node #database #javascript
Comments
3 min read
Map First, Walk Second: What a Librarian Taught Me About Postgres
mohdsaquib114 profile

Map First, Walk Second: What a Librarian Taught Me About Postgres

#database #performance #postgres #sql
1
Comments
3 min read
Five specific schema patterns — unbounded VARCHAR, nullable columns inside multi
philip_mcclarence_2ef9475 profile

Five specific schema patterns — unbounded VARCHAR, nullable columns inside multi

#database #performance #postgres #sql
Comments
7 min read
Postgres vs Redis, Mongo, and RabbitMQ: Do You Really Need All Four?
philip_mcclarence_2ef9475 profile

Postgres vs Redis, Mongo, and RabbitMQ: Do You Really Need All Four?

#architecture #database #postgres #systemdesign
Comments
8 min read
Day 90 - Data Loss Warning: Why You Cannot Downgrade from ClickHouse® 26.3
kanishga_subramani_49ad73 profile

Day 90 - Data Loss Warning: Why You Cannot Downgrade from ClickHouse® 26.3

#clickhouse #devops #analytics #database
2
Comments
5 min read
Day 89 - Leveraging WebAssembly (WASM) UDFs in ClickHouse® 26.3
kanishga_subramani_49ad73 profile

Day 89 - Leveraging WebAssembly (WASM) UDFs in ClickHouse® 26.3

#clickhouse #analytics #database #devops
2
Comments
5 min read
Surviving High Traffic: Database Read/Write Splitting
iprajapatiparesh profile

Surviving High Traffic: Database Read/Write Splitting

#laravel #php #architecture #database
Comments
3 min read
I Stopped My PostgreSQL Primary 10 Times to Measure Real RPO
leobagnolabs profile

I Stopped My PostgreSQL Primary 10 Times to Measure Real RPO

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