Stars
Forks
Watchers
Developer links
TrailBase
With 5,400+ GitHub stars and sub-millisecond response times that eliminate the need for dedicated caches entirely, TrailBase consolidates your database, API server, auth service, realtime subscriptions, and admin interface into a single Rust binary weighing under 40MB. The platform generates type-safe CRUD APIs automatically from your SQLite schema with configurable access control rules using SQL expressions, while realtime subscriptions push data changes to connected clients via Server-Sent Events. The embedded Wasmtime runtime executes custom server-side logic as WebAssembly components compiled from Rust, JavaScript, Python, or any language targeting WASI, enabling complex business logic without external services. First-class geospatial support through the in-house LiteGIS GEOS extension provides GeoJSON integration, spatial indexing via R-Trees, and query operators including @within, @intersects, and @contains for location-based applications. Client SDKs span JavaScript/TypeScript, Dart/Flutter, Rust, C#/.NET, Swift, Kotlin, Go, and Python — covering mobile, web, desktop, and IoT platforms. The admin dashboard offers visual schema editing, a data browser, Record API configuration, OAuth provider setup, user management, SQL query editor, ERD visualization, and server logs. Experimental PostgreSQL support (v0.28+) allows connecting to existing Postgres instances via connection string. Deploy via a single binary, Docker container, or the one-line install script across Linux, macOS, and Windows. Running on a dedicated VPS on RepoCloud with guaranteed CPU, RAM, and SSD, full root SSH access, and a browser serial console. OSL-3.0 licensed.
Benefits
- Sub-Millisecond Single Binary Backend
- One Rust executable replaces database, API server, auth service, cache, and admin UI with sub-millisecond latencies that eliminate cache invalidation complexity and stale data issues.
- WebAssembly Server-Side Runtime
- Wasmtime executes custom business logic as WASM components compiled from Rust, JavaScript, Python, or any WASI-targeting language with sandboxed isolation and near-native performance.
- First-Class Geospatial Queries
- LiteGIS GEOS extension provides GeoJSON integration, R-Tree spatial indexing, and operators like @within, @intersects, and @contains for proximity searches and geofencing applications.
- Universal Client SDK Coverage
- Official SDKs for JavaScript, Dart/Flutter, Rust, C#/.NET, Swift, Kotlin, Go, and Python enable native mobile, web, desktop, and IoT applications with type-safe API access.
Features
- Type-Safe REST APIs
- Auto-generates CRUD endpoints from SQLite schema with configurable SQL-expression access control rules, pagination, filtering, sorting, and nested relation expansion.
- Realtime Subscriptions
- Server-Sent Events push data changes to connected clients with per-table subscription support, enabling live dashboards and collaborative applications without polling.
- Admin Dashboard
- Embedded web UI provides visual schema editor, data browser, Record API configuration, OAuth setup, user management, SQL query editor, and ERD visualization.
- Built-in Authentication
- Email/password and OAuth2 authentication with configurable providers, session management, JWT tokens, and user management accessible through both the admin UI and APIs.
- Multi-Database Support
- Primary SQLite with attached databases plus experimental PostgreSQL support via connection string, enabling migration paths for teams with existing Postgres infrastructure.