# Embedded Database

In-process analytical SQL database

DuckDB is a high-performance analytical database that runs as an in-process SQL OLAP engine. Unlike traditional client-server databases, DuckDB embeds directly within your application, similar to SQLite but optimized for analytical queries. It supports complex SQL including window functions, CTEs, and nested types while processing columnar data with vectorized execution. DuckDB reads Parquet, CSV, JSON, and Arrow formats natively and integrates with Python and R data science workflows.

Single-binary open-source backend

PocketBase is an open-source backend in a single Go binary with 44K+ GitHub stars providing a real-time database, authentication, file storage, and admin dashboard. No dependencies, no Docker required — just download and run. Features collection-based data modeling, REST API, real-time subscriptions, OAuth2 authentication, file uploads with thumbnails, and a built-in admin UI. Extends with custom Go code or JavaScript hooks. Ideal for prototyping, MVPs, and small-to-medium applications.