Soul: A SQLite REST and Realtime Server

• pocketbase

  177 33,169 9.7 Go

  Open Source realtime backend in 1 file

  

Hi, PocketBase author here.

Keep in mind that PocketBase do a lot more than just executing a raw DB query. We perform data validation, normalization, serialization, enriching, auto fail-retry to handle additional SQLITE_BUSY errors, etc. All of this comes with some cost and will always have an effect when doing microbenchmarks like this.

The performance would also depend on what version of PocketBase did you try, whether you used CGO or the pure Go driver, etc.

For a benchmark closer to a "real world" scenarios tested on various servers you can check the results from https://github.com/pocketbase/benchmarks.

There is definitely room for improvements (I haven't done any detailed profiling yet) but the current performance is "good enough" for the purposes the applications PocketBase is intended for (I've shared some numbers regarding a PocketBase app on production in https://github.com/pocketbase/pocketbase/discussions/4254).

Hope the above helps.

• soul

  24 1,415 8.9 JavaScript

  🕉 A SQLite REST and realtime server (by thevahidal)

• WorkOS

  workos.com sponsored

  The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

  

• pglite

  6 4,381 8.2 TypeScript

  Lightweight Postgres packaged as WASM into a TypeScript library for the browser, Node.js, Bun and Deno

  

I've found postgres via docker to be fine for dev and testing, but there are various epheremal postgres scripts, plus this could be promising for node stuff https://github.com/electric-sql/pglite if it works out. I'd imagine if this does work out we'll see the same kind of builds for other runtimes as well (like python)

• sqliterg

  1 41 8.8 Go

  A SQLite Remote Gateway - query SQLite via HTTP

• postgrest

  100 22,282 9.7 Haskell

  REST API for any Postgres database

  

• benchmarks

  1 27 3.2 Go

  PocketBase test application with various benchmarks (by pocketbase)

  

Hi, PocketBase author here.

Keep in mind that PocketBase do a lot more than just executing a raw DB query. We perform data validation, normalization, serialization, enriching, auto fail-retry to handle additional SQLITE_BUSY errors, etc. All of this comes with some cost and will always have an effect when doing microbenchmarks like this.

The performance would also depend on what version of PocketBase did you try, whether you used CGO or the pure Go driver, etc.

For a benchmark closer to a "real world" scenarios tested on various servers you can check the results from https://github.com/pocketbase/benchmarks.

There is definitely room for improvements (I haven't done any detailed profiling yet) but the current performance is "good enough" for the purposes the applications PocketBase is intended for (I've shared some numbers regarding a PocketBase app on production in https://github.com/pocketbase/pocketbase/discussions/4254).

Hope the above helps.

Suggest a related project