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.
CQRS Explained: It's Just Two Models (Not a Whole Architecture)
arnavsharma2711 profile

CQRS Explained: It's Just Two Models (Not a Whole Architecture)

#backend #architecture #database #webdev
Comments
6 min read
The Dual-Write Problem and How to Actually Fix It
arnavsharma2711 profile

The Dual-Write Problem and How to Actually Fix It

#backend #microservices #database #distributedsystems
Comments
5 min read
Your Index Only Scan Is Lying: Covering Indexes and the Visibility Map
arnavsharma2711 profile

Your Index Only Scan Is Lying: Covering Indexes and the Visibility Map

#database #postgres #sql #performance
Comments
4 min read
Composite Indexes Explained: Why Column Order Is the Whole Game
arnavsharma2711 profile

Composite Indexes Explained: Why Column Order Is the Whole Game

#database #sql #postgres #backend
Comments
4 min read
How to Query CSV Files with Natural Language Locally (No Cloud Uploads)
veilanalytics profile

How to Query CSV Files with Natural Language Locally (No Cloud Uploads)

#webdev #database #python #privacy
Comments
2 min read
The Silent Killer of ASP.NET Core Performance: The N+1 Query Problem
azhadsuhaimi profile

The Silent Killer of ASP.NET Core Performance: The N+1 Query Problem

#dotnet #csharp #webdev #database
Comments 1
2 min read
QUERY_HISTORY has no PARENT_QUERY_ID. Here's how I traced which statement inside a Snowflake procedure regressed anyway.
tracepointdata profile

QUERY_HISTORY has no PARENT_QUERY_ID. Here's how I traced which statement inside a Snowflake procedure regressed anyway.

#snowflake #sql #dataengineering #database
2
Comments 2
4 min read
73% of the Software Versions We Track Are Already End of Life
endoflifeorg profile

73% of the Software Versions We Track Are Already End of Life

#devops #security #programming #database
Comments
5 min read
How Database Indexes Work (And Why Yours Might Be Useless)
arnavsharma2711 profile

How Database Indexes Work (And Why Yours Might Be Useless)

#database #programming #sql
Comments
6 min read
Virtual threads didn't scale your app. They just moved the crash to your database.
adioof profile

Virtual threads didn't scale your app. They just moved the crash to your database.

#java #performance #database #concurrency
3
Comments 1
3 min read
🧑‍💻 5 Tools Every Beginner Developer Should Understand
shanitiwari profile

🧑‍💻 5 Tools Every Beginner Developer Should Understand

#beginners #database #javascript #typescript
Comments
2 min read
MongoDB Database Design for E-Commerce Applications
agoswami69 profile

MongoDB Database Design for E-Commerce Applications

#architecture #backend #database #scalability
Comments
4 min read
PostgreSQL Internals: What Happens When You Run SELECT *
3ni8ma profile

PostgreSQL Internals: What Happens When You Run SELECT *

#postgres #database #internals #performance
1
Comments
2 min read
Text to SQL Without Sending Data to OpenAI (Local DuckDB & Ollama Setup)
veilanalytics profile

Text to SQL Without Sending Data to OpenAI (Local DuckDB & Ollama Setup)

#database #privacy #javascript #ai
Comments
2 min read
Building an Interactive Excel Dashboard for E-commerce Product Analysis , A Jumia case Study
david_gitonga_2983 profile

Building an Interactive Excel Dashboard for E-commerce Product Analysis , A Jumia case Study

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