Tag

database

3 posts tagged with "database"

March 1, 2025

Database Query Optimization for Large Datasets

Proven techniques for optimizing database queries in enterprise applications with millions of records, based on experience with PostgreSQL, SQL Server, and MongoDB at scale.

databaseperformancepostgresqlsqloptimizationindexing

September 14, 2024

Prisma vs Drizzle: A Practical Comparison from Production Experience

Comparing two popular TypeScript ORMs based on real-world usage in enterprise applications

prismadrizzledatabasetypescript

July 28, 2024

Database-Agnostic Architecture: Why and How

Why WellOS needed database-agnostic architecture to run on PostgreSQL (cloud), MongoDB (on-premise), and SQLite (offline mobile). Two years of production lessons supporting 6 apps across 3 databases.

databasearchitecturepostgresqlmongodbsqlitedrizzle