Database Cheat Sheet: 20+ Engines in One Reference
A quick reference covering every database engine SpinDB supports, what each one does, and when to pick it.
databases
A quick reference covering every database engine SpinDB supports, what each one does, and when to pick it.
A practical guide to choosing between SQLite, LibSQL, and DuckDB when your project does not need a standalone database server.
A practical guide to migrating from MongoDB to FerretDB, covering what works out of the box, what breaks, and how to check your codebase before switching.
PostgreSQL is the right database for your SaaS MVP, and you probably will not need anything else for a long time.
A practical guide to picking the right database for IoT sensor data, covering QuestDB, InfluxDB, and PostgreSQL with SpinDB examples you can run locally.
A step-by-step guide to migrating from Redis to Valkey, covering data transfer, application changes, and the one gotcha worth knowing about.
PostgreSQL for persistent data plus Redis for real-time features is the proven stack for building chat applications at any scale.
Learn when to use full-text search, vector search, or both by running the same queries against Meilisearch and Qdrant side by side.
A practical comparison of PostgreSQL, MySQL, MariaDB, and CockroachDB to help you pick the right relational database for your project.
A practical comparison of ClickHouse and DuckDB with side-by-side code examples, covering when to pick a production analytics server versus an embedded analytical engine.
A hands-on comparison of Qdrant and Weaviate covering hybrid search, schema design, filtering, and side-by-side TypeScript code so you can pick the right vector database for your project.
A side-by-side comparison of QuestDB and InfluxDB for time-series workloads, with identical sensor pipelines in TypeScript to show how different these two databases really are.
A practical comparison of MongoDB and FerretDB covering wire protocol compatibility, storage engines, licensing, and where each one makes the most sense.
A practical comparison of SQLite and LibSQL covering server mode, replication, vector search, and when to pick each one.
A practical comparison of MySQL and MariaDB covering licensing, features, performance, and side-by-side TypeScript examples so you can pick the right one for your project.
A practical comparison of Redis and Valkey covering licensing, compatibility, and why the same code runs on both without changes.
Build a multi-party payment system with TigerBeetle and TypeScript, using double-entry bookkeeping, two-phase transfers, and balance limits to handle financial transactions correctly at scale.
Build a knowledge graph with TypeDB and TypeScript, covering type-safe schemas, pattern matching queries, multi-hop traversals, and inference rules that derive new facts from existing data.
Build a field survey app with CouchDB and TypeScript, exploring document storage, revision tracking, MapReduce views, Mango queries, and one-line replication.
Build a social movie recommendation graph with SurrealDB and TypeScript, using one query language that handles documents, relations, and graph traversals without any JOINs.
Build instant, typo-tolerant search with Meilisearch and TypeScript. Learn why traditional database queries fail on misspelled input and how Meilisearch returns the right results in milliseconds.
Build a semantic article search with Weaviate and TypeScript, covering schema-aware collections, vector search, hybrid search that combines keyword and semantic matching, and filtered queries.
Build an application performance monitoring pipeline with InfluxDB and TypeScript, learn how its measurement-tag-field data model and Flux queries handle high-frequency metrics, and run it all in one script.
Build a semantic movie search with Qdrant and TypeScript. Learn what vector databases actually do, why keyword search fails, and how embeddings let you search by meaning, all in one runnable script.
Build a real-time web analytics pipeline with ClickHouse and TypeScript, from raw page view events to funnel analysis, all in one runnable script.
Build a time-series sensor pipeline with QuestDB and TypeScript, learn why SAMPLE BY beats verbose GROUP BY queries, and run it all in one script.
Build a distributed orders system with CockroachDB and TypeScript, using standard SQL over the PostgreSQL wire protocol with built-in sharding, time-travel queries, and automatic replication.
Run analytical queries on sales data with DuckDB and TypeScript, including rollups, window functions, and native PIVOT syntax that PostgreSQL cannot do.
PostgreSQL 18 shipped with native UUIDv7, virtual generated columns, OLD/NEW in RETURNING, temporal constraints, skip scan, and zero-downtime NOT NULL. Here are the features that matter most, with examples you can run locally.
Build a bookmarks and knowledge base app with LibSQL and TypeScript, covering SQL fundamentals, JSON queries, native vector search, and batch transactions.
Build a task management app with SQLite and TypeScript, exploring JSON functions, window functions, recursive CTEs, and why the world's most deployed database might be all you need.
Build an e-commerce product catalog with FerretDB and TypeScript using the standard MongoDB driver, then see how your documents are really stored in PostgreSQL.
Build a recipe collection app with MongoDB and TypeScript, covering flexible queries, nested array operations, aggregation pipelines, text search, and update operators.
Build an inventory management system with MariaDB and TypeScript, covering core SQL operations alongside features MySQL lacks like sequences and system-versioned tables.
Build a blog platform with MySQL and TypeScript, covering table design, JSON columns, full-text search, and CTEs, all in one runnable script.
Build a rate limiter and real-time leaderboard with Redis and TypeScript, using data structures that would take hundreds of lines in a relational database.
Build caching, session management, and pub/sub messaging with Valkey and TypeScript using the same redis npm package you already know.
A practical comparison of Docker Compose and SpinDB for running local development databases, covering setup, resource usage, and when each approach makes sense.
A practical guide to running PostgreSQL, Redis, Qdrant, ClickHouse, and other databases side by side on your local machine without the configuration headaches.
Skip the containers and docker-compose files by running PostgreSQL, Redis, and other databases as native binaries with a single CLI command.
A practical guide to when document databases like MongoDB make sense and when PostgreSQL with JSONB is the better choice.
A practical guide to understanding when your timestamped data needs a dedicated time-series database and when PostgreSQL is enough.
A plain-language explanation of vector databases, when you actually need one, and a quick demo that stores and searches vectors locally with Qdrant and SpinDB.
FerretDB v2 depends on a PostgreSQL extension that doesn't exist on Windows yet. We built custom binaries so you can run FerretDB v1 natively on Windows without Docker or WSL.
Redis has no official Windows build. We created custom binaries so you can run Redis natively on Windows without Docker or WSL, using Layerbase Desktop or SpinDB.
No official Valkey Windows binary exists anywhere. We manually compiled one so you can run Valkey natively on Windows without Docker or WSL.