PocketBase Backend

PocketBase is an open-source backend-in-a-box created by Gani Georgiev in 2022, written in Go, providing an embedded SQLite database with real-time subscriptions, file storage, authentication, and an admin dashboard in a single binary file, designed for rapid prototyping and small to medium applications that need a backend without the complexity of setting up separate database, authentication, and file storage services, with the entire backend running from a single executable file with zero external dependencies. The database is built on embedded SQLite with real-time change notifications through server-sent events, enabling client applications to subscribe to collection changes and receive automatic updates when records are created, updated, or deleted, with the SQL schema managed through migrations or the admin UI, supporting relations, indexes, and full-text search. The authentication system provides email and password, OAuth2 with Google, GitHub, Facebook, GitLab, Discord, Apple, Microsoft, Spotify, Kakao, Twitch, and Strava, and superadmin authentication, with automatic token generation and refresh, role-based access control, and per-collection authorization rules. The file storage provides local and S3-compatible storage for user uploads with automatic thumbnail generation, file size limits, and access control. The admin dashboard provides a web UI for managing collections, records, files, and users. The REST API covers all CRUD operations with filtering, sorting, pagination, and relation expansion. The JavaScript SDK. The Go SDK. The extensibility through Go hooks. Designed for rapid prototyping and small applications.