dev101.io

Databases & Data

Relational, document, vector, and analytics databases — plus GUIs, migration tools, and streaming platforms.

40 curated links across 8 sections

Operational stores, analytics warehouses, search engines, and the tooling around them. If you're picking a database today, start with a managed Postgres — and reach for the specialists only when the workload demands it.

Managed Postgres

Start here for 90% of use cases.

  • Supabase
    FeaturedFreemium

    Postgres + auth + storage + edge functions + realtime. The open-source Firebase.

    PostgresBaaS
  • Neon
    FeaturedFreemium

    Serverless Postgres with branching, autosuspend, and scale-to-zero. Previews per PR.

    Postgresserverless
  • Tembo
    Freemium

    Postgres with 200+ pre-packaged extensions. Great for specialized workloads.

    Postgresextensions
  • Enterprise-grade managed Postgres from the folks behind PGO. Serious production workloads.

    Postgresenterprise
  • The default on AWS. Boring, reliable, integrates with everything.

    PostgresAWS

Other SQL & document DBs

When Postgres isn't the right fit.

  • MySQL-compatible (Vitess) serverless DB with branch-based schema changes.

    MySQL
  • Turso
    Freemium

    Hosted libSQL (SQLite fork). Multi-tenant DBs at the edge.

    SQLiteedge
  • MongoDB Atlas
    FeaturedFreemium

    Managed MongoDB with vector search built in. Generous free tier.

    MongoDBdocument
  • Distributed SQL DB that survives region failures. Drop-in Postgres wire protocol.

    distributedSQL
  • FaunaDB
    Freemium

    Serverless document-relational DB with FQL. Global by default, ACID transactions.

    documentserverless

Key-value, cache & queue

Fast, ephemeral, or pub/sub workloads.

  • Upstash
    FeaturedFreemium

    Serverless Redis, Kafka, QStash. Pay-per-request, no idle cost.

    Redisserverless
  • Official managed Redis from Redis Inc. Every module (Search, JSON, TimeSeries).

    Redis
  • DragonflyDB
    Open-source

    Redis-compatible DB with a modern multi-threaded architecture. 25× faster for some workloads.

    Redis-compatibleself-hostable
  • Valkey
    Open-source

    Linux Foundation fork of Redis. Drop-in replacement, OSS-first governance.

    Redis-forkopen-source

Analytics & warehouses

Columnar stores for OLAP, BI, and event pipelines. Cheap-per-byte, expensive-per-query.

  • ClickHouse Cloud
    FeaturedFreemium

    Ludicrously fast open-source columnar DB. The go-to for real-time analytics.

    columnarOLAP
  • Google's serverless warehouse. SQL, ML, geospatial, streaming ingest. Billed per scan.

    warehouseGCP
  • Multi-cloud data warehouse with best-in-class separation of compute + storage.

    warehouse
  • Lakehouse platform — Delta Lake, Spark, ML, governance. Preferred for data engineering at scale.

    lakehouseSpark
  • DuckDB
    FeaturedOpen-source

    In-process OLAP DB. SQL over Parquet / JSON / CSV at warehouse speed, locally.

    OLAPembedded
  • Managed DuckDB with hybrid local/cloud execution. Notebook-first workflow.

    DuckDBmanaged

Search engines

Full-text, fuzzy, faceted, and hybrid search.

  • Typesense
    FeaturedFreemium

    Fast typo-tolerant search. Open-source alternative to Algolia.

    searchopen-source
  • Developer-friendly search with vector + hybrid out of the box. Rust core.

    searchopen-source
  • The industry-standard hosted search. Best-in-class SDKs + UI components.

    search
  • Managed Elasticsearch + Kibana. Still the heavyweight for log + metric search.

    Elasticsearch
  • Orama
    Freemium

    In-browser vector + full-text search. Runs on-device for offline apps.

    searchembedded

Streaming & event pipelines

Move data between systems in real time.

  • Managed Kafka from the people who wrote it. Multi-cloud, Schema Registry, ksqlDB.

    Kafka
  • Redpanda
    Freemium

    Kafka-API-compatible broker in a single binary. No ZooKeeper, much faster.

    Kafka-compatible
  • Kafka-compatible streaming on S3. Radical cost reductions at scale.

    Kafka-compatibleS3
  • Inngest
    FeaturedFreemium

    Event-driven background jobs + workflows for serverless. Durable execution, retries.

    eventsworkflows

SQL clients & GUIs

Where you actually run queries day-to-day.

  • DBeaver
    FeaturedFree

    Free, universal DB GUI. Supports every major engine. Community edition is all you need.

    GUIuniversal
  • TablePlus
    Freemium

    Native Mac/Windows client with a beautiful UI. The paid favorite.

    GUInative
  • JetBrains' DB IDE. Sharpest SQL editor + refactoring + version control integration.

    GUIJetBrains
  • Open-source SQL editor. Cross-platform, clean UX, no signup.

    GUIopen-source
  • Outerbase
    Freemium

    Browser-based multi-DB client with AI query assistance + editable tables.

    browserAI
  • Visual editor for any DB with a Prisma schema. Great for Node/TS teams.

    GUIPrisma

ORMs, migrations & schema

The layer between your code and the DB.

  • Drizzle ORM
    FeaturedOpen-source

    TypeScript-first, SQL-like ORM with zero runtime overhead. Current TS favorite.

    TypeScriptORM
  • Prisma
    Open-source

    TypeScript ORM with a declarative schema. Mature tooling, big ecosystem.

    TypeScriptORM
  • Kysely
    Open-source

    Type-safe TypeScript SQL query builder. Nothing runtime-y about it.

    TypeScriptquery builder
  • SQLAlchemy
    Open-source

    The canonical Python ORM + SQL toolkit. Industrial-strength.

    PythonORM
  • Atlas
    Freemium

    Modern DB schema migration tool. Declarative schemas, CI integrations.

    migrations

Other resource directories

Links on this page point to third-party sites. We pick them on merit — no affiliate tracking, no paid placements. Spot something outdated or missing? Open an issue.