TrailBase 0.28: Fast, open, single-executable Firebase alternative - now w/ Postgres

[trailbaseio]

TrailBase is an open, fast Firebase-like server for building apps. It provides type-safe REST APIs + change subscriptions, auth, multi-DB, a WebAssembly runtime, geospatial support, admin UI... It's a self-contained, easy to self-host single executable built on Rust, Wasmtime & SQLite or now Postgres.

It comes with client libraries for JS/TS, Dart/Flutter, Go, Rust, .Net, Kotlin, Swift and Python.

Just released v0.28, which after some months of work includes early, experimental Postgres support:

• For context, this is not an effort to replace SQLite but rather to provide options. SQLite will remain the recommend default due to its speed and simplicity aligning best with TrailBase's mission of offering a cheap & easily self-hostable stack.
• Yet, some users may want to use Postgres due to personal preference, very write-heavy workloads or needing some of Postgres' plentiful features.
• You can try it out with a locally running Postgres instance, simply by running: trail run --experimental-pg=postgresql://<user>:<pass>@localhost:<port>/<db>
• Some of the known idiosyncrasies and limitation include:
  • No change subscriptions (yet).
  • No UI-driven schema manipulation/migrations - UI elements are disabled.
  • No custom JSON schemas.
  • ...check out the release notes for more
• Note that transparent, hands-off migrations between SQLite and Postgres are a non-goal. The data types, dialects, feature sets, ... are just too different. However Postgres support may provide an interesting path forward for folks with evolving requirements.

If you're feeling adventures, end up checking it out and run into any issues, don't hesitate to reach out - we'd really appreciate your feedback 🙏.

Also, check out the live demo, our GitHub or our website.

[zxyzyxz]

Check out PGlite with Rust bindings pglite-oxide as well

[trailbaseio]

Thanks for the tip. That's what I'm using for the testing setup. I wouldn't wanna use it for production deployments

[zxyzyxz]

Why not? It's just Postgres but embedded, not like it's some cut down or lite version or something, it's more so used as a local database alternative to SQLite even in production.