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.
Why PostgreSQL Might Be All the Backend You Need: Forget the Kitchen Sink
simplr_sh profile

Why PostgreSQL Might Be All the Backend You Need: Forget the Kitchen Sink

#database #vectordatabase #webdev #programming
6
Comments
4 min read
Reactive Programming in Node.js
bengreenberg profile

Reactive Programming in Node.js

#webdev #javascript #blockchain #database
Comments
3 min read
Features I Wish MySQL Had but Postgres 🐘 Already Has đŸ˜»
op3ratordec profile

Features I Wish MySQL Had but Postgres 🐘 Already Has đŸ˜»

#postgres #mysql #sql #database
5
Comments 2
5 min read
How to Create a New MySQL User and Grant All Permissions
msnmongare profile

How to Create a New MySQL User and Grant All Permissions

#mysql #sql #database #programming
Comments
2 min read
SelfDB – Ditch Supabase and Firebase Lock-In, Self-Host Simply
selfdb_io profile

SelfDB – Ditch Supabase and Firebase Lock-In, Self-Host Simply

#webdev #programming #database #node
1
Comments 2
3 min read
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
8
Comments 1
6 min read
10 SQL Anti-Patterns You Must Avoid in Production
cristiansifuentes profile

10 SQL Anti-Patterns You Must Avoid in Production

#sql #database #performance #advancedsql
2
Comments
2 min read
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
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
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
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
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
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
👋 Sign in for the ability to sort posts by relevant, latest, or top.