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.
Why Schema-Aware Query Generation Beats Generic AI Templates for Production Databases

Why Schema-Aware Query Generation Beats Generic AI Templates for Production Databases

Comments
3 min read
Data warehouse for startups: picking BigQuery or Snowflake

Data warehouse for startups: picking BigQuery or Snowflake

Comments
5 min read
Supabase vs Firebase: Which Backend Wins?

Supabase vs Firebase: Which Backend Wins?

Comments
7 min read
Why I Chose Neon (dev.to Database Partner) for My AI Routing Platform

Why I Chose Neon (dev.to Database Partner) for My AI Routing Platform

Comments
5 min read
Part 3: Exposing ClickHouse as an Embeddable Analytics API — With Access Control and Cost Attribution

Part 3: Exposing ClickHouse as an Embeddable Analytics API — With Access Control and Cost Attribution

Comments 1
5 min read
Parallel Processing Gone Wrong

Parallel Processing Gone Wrong

Comments
2 min read
A engenharia de nunca perder um webhook: fila, retry e idempotĂŞncia

A engenharia de nunca perder um webhook: fila, retry e idempotĂŞncia

Comments 1
4 min read
The Outbox Pattern Explained (Complete Guide)

The Outbox Pattern Explained (Complete Guide)

6
Comments 3
2 min read
Day 67 of #100DaysOfClickHouse: Securing ClickHouse® with SSL/TLS and LDAP Authentication

Day 67 of #100DaysOfClickHouse: Securing ClickHouse® with SSL/TLS and LDAP Authentication

Comments
5 min read
Installing Couchbase Database on Ubuntu 22.04

Installing Couchbase Database on Ubuntu 22.04

8
Comments
3 min read
SQL Window Functions: How to Get the Top Row Per Group

SQL Window Functions: How to Get the Top Row Per Group

Comments
16 min read
OLTP vs OLAP : Understanding the Foundation of Modern Data Systems

OLTP vs OLAP : Understanding the Foundation of Modern Data Systems

Comments
4 min read
Normalization vs. Denormalization: Choosing the Right Database Design for Performance

Normalization vs. Denormalization: Choosing the Right Database Design for Performance

Comments
3 min read
SQL Foundations, Start to Finish

SQL Foundations, Start to Finish

Comments
15 min read
GROUP BY and HAVING: How to Summarize Rows Without Getting a Fake Answer

GROUP BY and HAVING: How to Summarize Rows Without Getting a Fake Answer

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