Tag: database

20 articles

· typescript / turso

How to set up Turso (libSQL) in a TypeScript project

Set up Turso (libSQL) in TypeScript from scratch: install @libsql/client, run CRUD, add Drizzle ORM, and manage local dev — with the gotchas most guides miss.

· database / postgres

Neon in 2026 — serverless Postgres one year in review

Neon's copy-on-write branching and free tier are the real story. Cold starts and spotty reliability are the honest caveats. A year of production data.

· neon / planetscale

Neon vs PlanetScale — serverless Postgres vs serverless MySQL

Neon has the free tier, the better dev branching, and the Postgres ecosystem. PlanetScale has no cold starts, NVMe speed, and enterprise schema governance. They stopped competing in April 2024 when PlanetScale killed its free tier.

· typescript / orm

Prisma ORM in 2026: Has It Caught Up to Drizzle at Last?

Drizzle still leads on edge and serverless. Prisma 7's Rust-free rewrite is a real architectural shift — here is who should switch and who should stay.

· cloudflare / d1

Cloudflare D1 in 2026: is it production-ready?

D1 cleared production-ready for read-heavy Workers apps in 2026. Two limits remain: ~10 writes/sec per database and always-on foreign key enforcement.

· postgres / database

Best Postgres Host for Early-Stage SaaS (2026)

Neon is the best postgres host for early-stage SaaS: free tier, built-in PgBouncer pooling, and database branching. When Supabase or Railway wins instead.

· mongodb / postgresql

How to Migrate MongoDB to PostgreSQL Without Downtime

How to migrate MongoDB to PostgreSQL without downtime: dual-write strategy, TypeScript ETL, schema mapping, data validation, and 8 production gotchas.

· database / edge

Edge database tradeoffs: when latency is a lie

Edge databases cut read latency globally, but writes still go to a single primary. When D1, Turso, Neon, or PlanetScale makes sense — and when Postgres wins.

· typescript / orm

Drizzle ORM in 2026 — production opinion for TypeScript

Drizzle is production-ready for edge and serverless Postgres. Bundle ~81× smaller than Prisma, 4× throughput. The real trade-offs are in team tooling.

· typescript / orm

How to Migrate from Prisma to Drizzle ORM: Step-by-Step

Step-by-step Prisma to Drizzle migration: schema conversion, query rewrites, transaction refactoring, and eight gotchas most tutorials skip.

· duckdb / sqlite

DuckDB vs SQLite: Which Wins for Desktop Analytics?

For any query touching more than a few thousand rows, DuckDB wins by a wide margin. SQLite still owns app persistence and indexed lookups. When to use each.

· prisma / typeorm

Prisma vs TypeORM: Which TypeScript ORM to Pick in 2026?

Prisma 7 reversed the performance gap and cut bundle size by 90%. TypeORM 1.0 finally hit stable after a decade in pre-release. Honest verdict for 2026.

· postgresql / multi-tenancy

Multi-tenant Postgres patterns in 2026 — schemas vs RLS vs separate DBs

Your tenancy model locks you in before you have enough tenants to feel the pain. Schema-per-tenant degrades past 500 in plain Postgres. RLS has five known CVEs. Here's the decision map.

· clickhouse / postgresql

ClickHouse vs Postgres for analytics

If dashboard queries on 100M+ rows are hitting 8 seconds, ClickHouse is worth looking at. Here is what the benchmarks show about the actual break-even point.

· drizzle / kysely

Drizzle ORM vs Kysely: Which Typed Query Tool in 2026?

Drizzle wins on DX, auto-migrations, and first-party edge adapters. Kysely wins on compile-time query validation for complex schemas. Here is which one to pick.

· turso / cloudflare

Turso vs Cloudflare D1: Which Edge SQLite Should You Pick?

D1 is the obvious choice if you live in Cloudflare Workers. Turso is the right pick everywhere else: Node.js, Deno, Bun, and Vercel. Here is the data.

· database / postgres

Neon vs Supabase — Serverless Postgres Compared (2026)

Neon wins on cold starts and edge compatibility; Supabase wins if you need auth, storage, and realtime bundled in. Here is the data to make the call.

· typescript / orm

Best TypeScript ORM 2026: Drizzle, Prisma, Kysely, TypeORM

Drizzle is the clear default pick for new TypeScript projects in 2026. Here is when each ORM wins — and when the others should stay on the bench.

· typescript / orm

Prisma vs Drizzle 2026 — Full TypeScript ORM showdown

Prisma 7 dropped Rust and cut its bundle by 85%. Drizzle is still 80× lighter. Here is when each makes sense for your TypeScript stack in 2026.

· supabase / firebase

Supabase vs Firebase (2026): Postgres or NoSQL?

Supabase runs Postgres with full SQL. Firebase runs Firestore without it. At 100K MAU the pricing gap is 12×. Here is when each one is the right call.