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.
COALESCE in SQL: the “Don’t Let NULL Win” Function You’ll Use Everywhere
baldwin_apps profile

COALESCE in SQL: the “Don’t Let NULL Win” Function You’ll Use Everywhere

#sql #database #programming #dataengineering
Comments
2 min read
Databasus released full backups portability: backups recoverable without Databasus itself
finny_collins profile

Databasus released full backups portability: backups recoverable without Databasus itself

#database #postgres
Comments
4 min read
.Net Learning Notes: Custom In-Memory Provider(3) - Storage Write Model and Key-Based Retrieval
alexleeeeeeeeee profile
Alex

.Net Learning Notes: Custom In-Memory Provider(3) - Storage Write Model and Key-Based Retrieval

#csharp #database #dotnet #learning
Comments
4 min read
AlloyDB + SQLAlchemy: Connection Pooling Strategies That Actually Work in Production
humzakt profile

AlloyDB + SQLAlchemy: Connection Pooling Strategies That Actually Work in Production

#gcp #python #postgres #database
Comments
3 min read
ACID compliance in data analytics platforms: what it is, why it matters, and how to verify it (2026)
manveer_chawla_64a7283d5a profile

ACID compliance in data analytics platforms: what it is, why it matters, and how to verify it (2026)

#database #duckdb #analytics #data
Comments
14 min read
5 MariaDB performance tuning techniques for faster queries
finny_collins profile

5 MariaDB performance tuning techniques for faster queries

#database #mariadb
Comments
5 min read
How We Tamed 300+ Stored Procedures in a Legacy PostgreSQL Project
euroformat profile

How We Tamed 300+ Stored Procedures in a Legacy PostgreSQL Project

#postgres #python #refactoring #database
3
Comments
3 min read
Zero-Downtime Schema Changes in SQL Server: The Reality Behind “Just Run the Migration”
sonia_bobrik_1939cdddd79d profile

Zero-Downtime Schema Changes in SQL Server: The Reality Behind “Just Run the Migration”

#database #performance #sql #sre
Comments
6 min read
Why SQL Makes You Stand Ahead of Most Candidates
tanushreep profile

Why SQL Makes You Stand Ahead of Most Candidates

#sql #analytics #database #datascience
Comments
2 min read
EF Core HasQueryFilter II
karenpayneoregon profile

EF Core HasQueryFilter II

#csharp #dotnetcore #database
Comments
3 min read
Two ClickHouse Internals That Change How You Write Queries
mohhddhassan profile

Two ClickHouse Internals That Change How You Write Queries

#clickhouse #database #backend #performance
2
Comments
4 min read
Creating and Mapping Entities in JPA: Essential Annotations Explained
amamre profile

Creating and Mapping Entities in JPA: Essential Annotations Explained

#java #jpa #database #backenddevelopment
Comments
4 min read
Talk to your data from any chat app
anuveyatsu profile

Talk to your data from any chat app

#ai #database #data #llm
Comments
2 min read
Solving MSSQL's 2100 Parameter Limit: From IN Clause to Cursor-Based Pagination
sangwoo_rhie profile

Solving MSSQL's 2100 Parameter Limit: From IN Clause to Cursor-Based Pagination

#backend #database #sql #typescript
Comments
4 min read
MySQL replication setup — 6 steps to configure master-slave replication
freddowson profile

MySQL replication setup — 6 steps to configure master-slave replication

#database #opensource #mysql
Comments
8 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.