Databases

11 guides covering databases tools

Choose and manage databases effectively with these developer-focused guides. From SQL and NoSQL options to database GUIs, migration tools, and performance optimization, find practical advice for the data layer of your applications.

DuckDB: The Analytics Database That Runs Everywhere

2026-03-04 · 5 min duckdb analytics database parquet olap python sql data engineering

DuckDB is an in-process analytics database with no server required. Covers querying CSV and Parquet files, Python integration, SQL features, and where it fits compared to SQLite and BigQuery.
Essential PostgreSQL Extensions Every Developer Should Know

2026-02-15 · 5 min postgresql extensions pgvector timescaledb citus database

A comprehensive guide to must-have PostgreSQL extensions including pgvector for AI/embeddings, TimescaleDB for time series, pg_cron for scheduling, PostGIS for geospatial data, and more.
Vector Databases for RAG: Qdrant, Weaviate, and Milvus Compared

2026-02-15 · 14 min vector-database rag embeddings qdrant weaviate milvus chroma llm ai

A practical guide to vector databases for retrieval-augmented generation -- covering embeddings, indexing strategies, Docker setup, querying patterns, and an honest comparison of Qdrant, Weaviate, Milvus, and Chroma.
Database Migration Tools: Flyway, Liquibase, Prisma Migrate, Drizzle Kit, and golang-migrate

2026-02-15 · 13 min databases migrations flyway liquibase prisma drizzle golang-migrate schema-management

A comprehensive guide to database migration tools comparing SQL-first vs generated approaches, rollback support, CI integration, and practical setup examples for Flyway, Liquibase, Prisma Migrate, Drizzle Kit, and golang-migrate.
Turso and libSQL: SQLite at the Edge

2026-02-14 · 6 min turso libsql sqlite database edge typescript serverless replication

A practical guide to Turso and libSQL, the edge-first SQLite fork. Covers architecture, embedded replicas, multi-tenant patterns, SDK usage with TypeScript, and comparison with PlanetScale and Neon.
SQLite for Developers: When and How to Use the World's Most Deployed Database

2026-02-14 · 8 min sqlite databases embedded local-first sql

A practical guide to SQLite as a developer tool -- use cases, WAL mode, JSON support, performance tuning, and when to choose it over Postgres or MySQL.
Database Migrations and ORMs: Prisma, Drizzle, Knex, and Beyond

2026-02-09 · 6 min database orm prisma drizzle migrations sql

A practical comparison of database migration tools and ORMs -- Prisma, Drizzle, Knex, TypeORM, and raw SQL. Schema management, type safety, and performance.
Database Tools for Developers: GUIs, CLIs, Migrations, and Local Setup

2026-02-09 · 5 min database postgresql mysql docker prisma drizzle

A guide to database tooling for developers covering GUI clients like DBeaver and TablePlus, CLI tools like pgcli, migration frameworks including Prisma and Drizzle, and Docker Compose setups for local development.
Database Testing and Local Development Tools

2026-02-09 · 6 min database testing testcontainers docker migrations seed-data

A practical guide to database testing and local development tools -- Testcontainers, Docker-based databases, seed data management, migration testing, and tools for reliable database workflows.
PostgreSQL Tools: Clients, Monitoring, Migration, and Performance

2026-02-09 · 6 min postgresql databases sql pgadmin migration

A practical guide to PostgreSQL tooling -- GUI clients, CLI tools, migration frameworks, monitoring dashboards, and performance analysis utilities.
Database GUI Tools Compared: DBeaver, DataGrip, TablePlus, Beekeeper Studio, and pgAdmin

2026-02-09 · 6 min database gui dbeaver datagrip tableplus

A practical comparison of database GUI clients covering DBeaver, DataGrip, TablePlus, Beekeeper Studio, and pgAdmin -- with honest assessments of pricing, features, and when CLI tools are the better choice.