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.
SQL Join Dark Arts: Anti Joins, Semi Joins, and Beyond
cristiansifuentes profile

SQL Join Dark Arts: Anti Joins, Semi Joins, and Beyond

#sql #database
Comments
2 min read
Think in Sets: Writing High-Performance SQL the Declarative Way
cristiansifuentes profile

Think in Sets: Writing High-Performance SQL the Declarative Way

#sql #database #postgres #sqlserver
Comments
2 min read
Transforming Rows to Columns and Back: SQL PIVOT/UNPIVOT Techniques
cristiansifuentes profile

Transforming Rows to Columns and Back: SQL PIVOT/UNPIVOT Techniques

#sql #database #dataengineering #analytics
1
Comments
2 min read
Working with JSON in PostgreSQL, MySQL & SQL Server
cristiansifuentes profile

Working with JSON in PostgreSQL, MySQL & SQL Server

#sql #database #json #datamodeling
1
Comments
2 min read
Install MongoDB & Create a Database | MongoDB Tutorial 2025
roxana_haidiner profile

Install MongoDB & Create a Database | MongoDB Tutorial 2025

#mongodb #nosql #database #devops
6
Comments
5 min read
Querying the Past: Temporal Tables in SQL Server and PostgreSQL
cristiansifuentes profile

Querying the Past: Temporal Tables in SQL Server and PostgreSQL

#sql #database #sqlserver #postgres
2
Comments
2 min read
Materialized Views in SQL: Supercharging Read Performance
cristiansifuentes profile

Materialized Views in SQL: Supercharging Read Performance

#sql #database #dataengineering #backend
Comments
2 min read
Behind the Scenes: Reading SQL Execution Plans Like a Pro
cristiansifuentes profile

Behind the Scenes: Reading SQL Execution Plans Like a Pro

#sql #database #backend #indexing
Comments
3 min read
Why Netflix Doesn’t Trust Auto-Increment IDs: The Untold Power of UUIDs in a Distributed World
curious_tinkerer profile

Why Netflix Doesn’t Trust Auto-Increment IDs: The Untold Power of UUIDs in a Distributed World

#webdev #programming #database #backend
1
Comments
4 min read
How to Backup and Restore Amazon DocumentDB: Step-by-Step Guide
krishnendubhowmick profile

How to Backup and Restore Amazon DocumentDB: Step-by-Step Guide

#devops #aws #database #webdev
Comments
3 min read
A simple, convenience package for the Azure Cosmos DB Go SDK
abhirockzz profile

A simple, convenience package for the Azure Cosmos DB Go SDK

#go #database #azure #nosql
4
Comments
5 min read
PostgreSQL Ignored My Index — Until I Fought Back (A Planner Battle Story)
max_shafiei_f46a24e31e2cb profile

PostgreSQL Ignored My Index — Until I Fought Back (A Planner Battle Story)

#programming #database #postgres #webdev
1
Comments
3 min read
TRANSACTIONS IN DATABASE
srashtigupta profile

TRANSACTIONS IN DATABASE

#webdev #database #webperf #nosql
1
Comments
2 min read
Compression Algorithms You Probably Inherited: gzip, Snappy, LZ4, zstd
konstantinas_mamonas profile

Compression Algorithms You Probably Inherited: gzip, Snappy, LZ4, zstd

#database #sql #programming #performance
8
Comments
4 min read
How I Replaced Python with C in My Project
neil_brown profile

How I Replaced Python with C in My Project

#python #c #database #datascience
3
Comments 2
4 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.