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.
How to use EXPLAIN to fix slow queries in MySQL
drupaladmin profile

How to use EXPLAIN to fix slow queries in MySQL

#database #mysql #devops #webdev
6
Comments
6 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
Materialized Views in SQL: Supercharging Read Performance
cristiansifuentes profile

Materialized Views in SQL: Supercharging Read Performance

#sql #database #dataengineering #backend
Comments
2 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
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
How I Created an API That Enhances the Performance of ChatGPT
neil_brown profile

How I Created an API That Enhances the Performance of ChatGPT

#javascript #chatgpt #programming #database
Comments
3 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.