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.
Time-Series Storage: How to Evaluate Encoding and Compression for IoT Data
timecho profile

Time-Series Storage: How to Evaluate Encoding and Compression for IoT Data

#iot #timeseries #database #opensource
5
Comments 2
4 min read
PostgreSQL numeric vs double precision vs money: Which Type to Use for Prices
tbson87 profile

PostgreSQL numeric vs double precision vs money: Which Type to Use for Prices

#postgres #database #sql #webdev
Comments 1
9 min read
Understanding SQL Execution Order
buddika_b profile

Understanding SQL Execution Order

#backend #database #sql #tutorial
Comments 1
2 min read
True upserts in an append-only world: ReplacingMergeTree and FINAL.
william_rodriguez_65a5898 profile

True upserts in an append-only world: ReplacingMergeTree and FINAL.

#database
Comments 1
1 min read
When the Commit Succeeds but the Response Is Lost: Do You Always Need Operation IDs?
dhanagani_lakshmi_2487ad0 profile

When the Commit Succeeds but the Response Is Lost: Do You Always Need Operation IDs?

#dotnet #database #trans #csharp
Comments 1
4 min read
A PostgreSQL deadlock hiding in a foreign key check
edyiaeonian profile

A PostgreSQL deadlock hiding in a foreign key check

#postgres #database #java #debugging
Comments
12 min read
Zero-downtime schema evolution: Auto-migrations for ClickHouse.
william_rodriguez_65a5898 profile

Zero-downtime schema evolution: Auto-migrations for ClickHouse.

#database
Comments 1
1 min read
How to optimize a database, one step at a time
tarangnagda profile

How to optimize a database, one step at a time

#database #sql #beginners #systemdesign
Comments 1
4 min read
Bind Variables: The Hard-Parse Storm That Melts Your Shared Pool
uptimearchitect profile

Bind Variables: The Hard-Parse Storm That Melts Your Shared Pool

#oracle #database #performance #sql
Comments 2
11 min read
PostgreSQL Generated Column vs Trigger: Which to Use for a Derived Column
tbson87 profile

PostgreSQL Generated Column vs Trigger: Which to Use for a Derived Column

#postgres #database #sql #performance
Comments
10 min read
Power BI Data Modelling, Relationships and Joins: A Practical Guide to Building Effective BI Models
samuelmwaurandungu profile

Power BI Data Modelling, Relationships and Joins: A Practical Guide to Building Effective BI Models

#analytics #data #database #tutorial
Comments 1
6 min read
Database Concurrency 101: Optimistic vs. Pessimistic Locking
saurav_tb_pandey profile

Database Concurrency 101: Optimistic vs. Pessimistic Locking

#optimisticlocking #database #node #mysql
Comments
3 min read
🥇 We Won Best Use of Snowflake at ELEMENTX 2026 ❄️ | MLH Hack Day 💻
abdullahlko profile

🥇 We Won Best Use of Snowflake at ELEMENTX 2026 ❄️ | MLH Hack Day 💻

#cloud #database #machinelearning #softwaredevelopment
1
Comments 2
3 min read
SensorFlow vs Plausible in 2026: Two Very Different Ways to Own Analytics
sensorflow profile

SensorFlow vs Plausible in 2026: Two Very Different Ways to Own Analytics

#analytics #opensource #database #architecture
Comments
6 min read
Oracle SQL: Essential Environment Commands
sandeep-dos profile

Oracle SQL: Essential Environment Commands

#database #sql #oracle #oraclesql
Comments
2 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.