Developer Articles | TechForDev

Latest AI / ML JavaScript Python React Next.js Web Dev DevOps Cloud

Garbage collecting OpenCode's 2.4 GB session database

Wu Haotian5d ago • 2 min read

Garbage collecting OpenCode's 2.4 GB session database

I've been using OpenCode from time to time for about a month, mainly working on a single side projec...

#opencode#ai#sqlite#ocgc

6 0

SQLite's PRAGMAs You Never Remember — I Put Them in a CLI

SEN LLC5d ago • 8 min read

SQLite's PRAGMAs You Never Remember — I Put Them in a CLI

SQLite's PRAGMAs You Never Remember — I Put Them in a CLI When you're handed an unknown...

#rust#sqlite#cli#tutorial

0 0

1.5M Events/sec on SQLite: What Happens When You Stop Fighting Shared State

dwighson PavionApr 13, 2026 • 4 min read

1.5M Events/sec on SQLite: What Happens When You Stop Fighting Shared State

I spent years building applications with Postgres. It works. But every time I modeled a domain with....

#typescript#database#sqlite#eventsourcing

0 0

Building a URL Shortener in Rust with axum, SQLite, and 30 Lines of base62

SEN LLC5d ago • 9 min read

Building a URL Shortener in Rust with axum, SQLite, and 30 Lines of base62

Building a URL Shortener in Rust with axum, SQLite, and 30 Lines of base62 The URL...

#rust#axum#sqlite#tutorial

0 0

I built a CMS that fits in one file — here's why and how

Gerwin Weiher6d ago • 2 min read

I built a CMS that fits in one file — here's why and how

Every CMS I've tried for Astro comes with the same overhead: a database to provision, a media CDN to...

#astro#cms#sqlite#webdev

1 0

[01] Building a Personal ALM System — Your Life as a Database Schema

soy5d ago • 6 min read

[01] Building a Personal ALM System — Your Life as a Database Schema

Banks model assets and liabilities together. We do the same for personal finances using SQLite — bui...

#python#finance#sqlite#fire

1 0

PostgreSQL Vector Search & TimescaleDB Performance, SQLite Extension Build Fixes

soy1d ago • 3 min read

PostgreSQL Vector Search & TimescaleDB Performance, SQLite Extension Build Fixes

PostgreSQL Vector Search & TimescaleDB Performance, SQLite Extension Build Fixes ...

#database#sql#sqlite

0 0

PostgreSQL Ecosystem Expands with ULAK Extension & Open-Source Xata; SQLite Vector Search Advances

soy4d ago • 3 min read

PostgreSQL Ecosystem Expands with ULAK Extension & Open-Source Xata; SQLite Vector Search Advances

PostgreSQL Ecosystem Expands with ULAK Extension & Open-Source Xata; SQLite Vector...

#database#sql#sqlite

0 0

SQLite Tcl Extension, TimescaleDB Aggregates & PostgreSQL Data Pipelines

soy21h ago • 3 min read

SQLite Tcl Extension, TimescaleDB Aggregates & PostgreSQL Data Pipelines

SQLite Tcl Extension, TimescaleDB Aggregates & PostgreSQL Data Pipelines ...

#database#sql#sqlite

0 0

DuckDB Extensions in C#, Production DuckLake, & pgvector Performance Insights

soy2d ago • 3 min read

DuckDB Extensions in C#, Production DuckLake, & pgvector Performance Insights

DuckDB Extensions in C#, Production DuckLake, & pgvector Performance Insights ...

#database#sql#sqlite

0 0

SQLite Sharding in Practice: A Deep Comparison of Three Sharding Strategies

Hagicode3d ago • 8 min read

SQLite Sharding in Practice: A Deep Comparison of Three Sharding Strategies

SQLite Sharding in Practice: A Deep Comparison of Three Sharding Strategies When single file SQLite ...

#sqlite#hagicode

0 0

SQLite Cross-DB FKs, SQL-First Postgres, & N+1 Query Fingerprinting

soy3d ago • 4 min read

SQLite Cross-DB FKs, SQL-First Postgres, & N+1 Query Fingerprinting

SQLite Cross-DB FKs, SQL-First Postgres, & N+1 Query Fingerprinting Today's...

#database#sql#sqlite

0 0

DuckDB 1.5.2, SQLite JSON Join Speedup, & Postgres NOTIFY Debugger

soy5d ago • 3 min read

DuckDB 1.5.2, SQLite JSON Join Speedup, & Postgres NOTIFY Debugger

DuckDB 1.5.2, SQLite JSON Join Speedup, & Postgres NOTIFY Debugger Today's...

#database#sql#sqlite

0 0

DuckDB Lake, dbt Custom Materializations, & PostgreSQL Partitioning Strategies

soy6d ago • 3 min read

DuckDB Lake, dbt Custom Materializations, & PostgreSQL Partitioning Strategies

DuckDB Lake, dbt Custom Materializations, & PostgreSQL Partitioning Strategies ...

#database#sql#sqlite

0 0

Cloudflare D1: Serverless SQLite at the Edge — Production Patterns

Atlas Whoff17h ago • 3 min read

Cloudflare D1: Serverless SQLite at the Edge — Production Patterns

Cloudflare D1: Serverless SQLite at the Edge — Production Patterns Cloudflare D1 is SQLite...

#cloudflare#sqlite#typescript#webdev

0 0

Turso + LibSQL + Drizzle: SQLite at the Edge in 2026

Atlas Whoff3d ago • 2 min read

Turso + LibSQL + Drizzle: SQLite at the Edge in 2026

Turso gives you SQLite with global replication. How to use it with Drizzle ORM in Next.js -- schema,...

#sqlite#nextjs#typescript#database

0 0

PostgreSQL vs SQLite for SaaS: When the Simple Choice Is the Right Choice

Atlas Whoff3d ago • 8 min read

PostgreSQL vs SQLite for SaaS: When the Simple Choice Is the Right Choice

You're building a SaaS. You've got a Next.js App Router project scaffolded, Drizzle ORM installed,.....

#postgres#sqlite#saas#typescript

0 0

Tech Articles

Garbage collecting OpenCode's 2.4 GB session database

SQLite's PRAGMAs You Never Remember — I Put Them in a CLI

1.5M Events/sec on SQLite: What Happens When You Stop Fighting Shared State

Building a URL Shortener in Rust with axum, SQLite, and 30 Lines of base62

I built a CMS that fits in one file — here's why and how

[01] Building a Personal ALM System — Your Life as a Database Schema

PostgreSQL Vector Search & TimescaleDB Performance, SQLite Extension Build Fixes

PostgreSQL Ecosystem Expands with ULAK Extension & Open-Source Xata; SQLite Vector Search Advances

SQLite Tcl Extension, TimescaleDB Aggregates & PostgreSQL Data Pipelines

DuckDB Extensions in C#, Production DuckLake, & pgvector Performance Insights

SQLite Sharding in Practice: A Deep Comparison of Three Sharding Strategies

SQLite Cross-DB FKs, SQL-First Postgres, & N+1 Query Fingerprinting

DuckDB 1.5.2, SQLite JSON Join Speedup, & Postgres NOTIFY Debugger

DuckDB Lake, dbt Custom Materializations, & PostgreSQL Partitioning Strategies

Cloudflare D1: Serverless SQLite at the Edge — Production Patterns

Turso + LibSQL + Drizzle: SQLite at the Edge in 2026

PostgreSQL vs SQLite for SaaS: When the Simple Choice Is the Right Choice