Lab

Lab

AI tools, creative workflows, developer deep-dives, and behind-the-scenes from RAXXO Studios.

9 articles

RAXXO Studios 9 min read

Why I Stopped Reaching for Redis on Solo Projects

Six Redis use cases replaced with SQLite, Postgres, and Edge KV Rate limiting fits in one SQLite table with 40 lines Postgres LISTEN handles pubsub without a second service One place Redis still wins: high-throughput shared queues I ran Redis...

DatabaseDevelopmentTutorials
Read article
More Articles
Development
RAXXO Studios 10 min

The DuckDB Pattern When SQLite Is Not Enough but Postgres Is Overkill

DuckDB scans 10M rows in under a second on a laptop SQLite for transactions, DuckDB for analytics, no server needed Query CSV and Parquet files...

Development
RAXXO Studios 9 min

SQLite is Enough: 5 RAXXO Services I Moved Off Postgres

Moved 5 RAXXO services off Postgres + Neon to SQLite + better-sqlite3 in WAL mode Local roundtrips dropped from 38ms to 0.4ms on the syndication...

Development
RAXXO Studios 9 min

Neon Database Branching Saved Me 200 EUR Every Month

I run 14 Neon database branches per project for the price of one Postgres instance Neon copy-on-write branching clones a 12 GB database in under...

Development
RAXXO Studios 11 min

The 5 Postgres Extensions Every Shopify Backend Needs

pg_cron, pgvector, pg_partman, pg_stat_statements, postgres_fdw. The five extensions that turn generic Postgres into a Shopify-aware database.

Development
RAXXO Studios 10 min

The 7 Postgres Indexes That Took My API From 400ms to 40ms

I took one of my APIs from 400ms p95 to 40ms p95 by fixing 7 missing or wrong Postgres indexes. Most of my slow queries...

AI Tools
RAXXO Studios 2 min

Building a Global Leaderboard with Neon Postgres and Zero Infrastructure Cost

Serverless Postgres for side projects. One npm install, one env var, global leaderboard running for free.

Tutorials
RAXXO Studios 5 min

Drizzle ORM with Neon Postgres: A Practical Guide

A practical guide to using Drizzle ORM with Neon serverless Postgres. Schema design, migrations, queries, and deployment patterns for Next.js apps.

Development
RAXXO Studios 5 min

Supabase vs Neon: Choosing a Serverless Database in 2026

Supabase vs Neon compared for serverless Postgres in 2026. Features, pricing, DX, and which one works better for solo developers.