r/sqlite • u/trailbaseio • Feb 21 '26
TrailBase 0.24: Fast, open, single-executable Firebase alternative now with Geospatial
TrailBase is a Firebase alternative that provides type-safe REST & realtime APIs, auth, multi-DB, a WebAssembly runtime, SSR, admin UI... and now has first-class support for geospatial data and querying. It's self-contained, easy to self-host, fast and built on Rust, SQLite & Wasmtime.
Moreover, it comes with client libraries for JS/TS, Dart/Flutter, Go, Rust, .Net, Kotlin, Swift and Python.
Just released v0.24. Some of the highlights since last time posting here include:
Support for efficiently storing, indexing and querying geometric and geospatial data 🎉
For example, you could throw a bunch of geometries like points and polygons into a table and query: what's in the client's viewport? Is my coordinate intersecting with anything? ...
Much improved admin UI: pretty maps and stats on the logs page, improved accounts page, reduced layout jank during table loading, ...
Change subscriptions using WebSockets in addition to SSE.
Increase horizontal mobility, i.e. reduce lock-in: allow using TBs extensions outside, allow import of existing auth collections (i.e. Auth0 with more to come), dual-licensed clients under more permissive Apache-2, ...
Check out the live demo, our GitHub or our website. TrailBase is only about a year young and rapidly evolving, we'd really appreciate your feedback 🙏
0
u/MaximKiselev Feb 22 '26
ui looks terrible....sqlite ? are u seriosly?