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.
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
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
2
Comments
4 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
Optimizing SQL queries for your AI Agents.
sten profile

Optimizing SQL queries for your AI Agents.

#ai #sql #python #database
7
Comments 2
4 min read
JavaLSM: An LSM Tree Based Key-Value Storage in Java
seungwonlee03 profile

JavaLSM: An LSM Tree Based Key-Value Storage in Java

#database #nosql #software
Comments
4 min read
What is redis pipeline
ankitmalikg profile

What is redis pipeline

#redis #database #go #python
6
Comments
2 min read
Don’t Use SQL If Your Client Doesn’t Know What They Want
criscmd profile

Don’t Use SQL If Your Client Doesn’t Know What They Want

#discuss #database #webdev #career
Comments 2
2 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.