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.
What's New in Surrealist 3.8

What's New in Surrealist 3.8

14
Comments
3 min read
1.3.4 RETURNING Mapping and View-Target DML Transformation

1.3.4 RETURNING Mapping and View-Target DML Transformation

Comments
9 min read
Columnar Databases (ClickHouse/Snowflake)

Columnar Databases (ClickHouse/Snowflake)

1
Comments
8 min read
SQLite Is All You Need (Until It Isn't) — A Practical Guide

SQLite Is All You Need (Until It Isn't) — A Practical Guide

Comments
4 min read
Refreshing PostgreSQL Materialized Views Without Downtime

Refreshing PostgreSQL Materialized Views Without Downtime

1
Comments
7 min read
19/30 Days System Design Questions!

19/30 Days System Design Questions!

1
Comments 4
1 min read
SQL Subqueries vs CTEs: Types, Differences, Performance, and When to Use Each

SQL Subqueries vs CTEs: Types, Differences, Performance, and When to Use Each

2
Comments
3 min read
Stop Setting Up Databases for Things That Just Need to Remember Stuff

Stop Setting Up Databases for Things That Just Need to Remember Stuff

Comments
2 min read
Configuration as Code: The Missing GitOps Layer in Multi-Tenant SaaS

Configuration as Code: The Missing GitOps Layer in Multi-Tenant SaaS

3
Comments 2
2 min read
Part 9 - dbt Project Setup and Contracts 🧱

Part 9 - dbt Project Setup and Contracts 🧱

Comments
1 min read
Part 8 - Staging Load into Postgres 🗃️

Part 8 - Staging Load into Postgres 🗃️

Comments
2 min read
Part 11 - Dimensions and Fact Table 📊

Part 11 - Dimensions and Fact Table 📊

Comments
2 min read
How to Use EXPLAIN ANALYZE in PostgreSQL: A Visual Guide

How to Use EXPLAIN ANALYZE in PostgreSQL: A Visual Guide

1
Comments
5 min read
PostgreSQL INT4RANGE: Enforce non-overlapping zones in SQL

PostgreSQL INT4RANGE: Enforce non-overlapping zones in SQL

Comments
4 min read
SQLite JSONB C++ Support, PostgreSQL Benchmarks & pgweb Client

SQLite JSONB C++ Support, PostgreSQL Benchmarks & pgweb Client

Comments
3 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.