Pocketbase
lazarus / 16-Databases

----------------------------------------------------------------------
steve612 · 2026-03-12 20:10

Hello team,

What is your opinion making a database application using Pocketbase
for backend?

Is it possible to use DbGrid will something like this. I am a beginner
please advice

Main reason is to avoid direct connection with database, but use
something between database and Application, in case you host online.

----------------------------------------------------------------------
PierceNg · 2026-03-13 00:30

Their how-to-use intro says,

QuoteThe easiest way to use PocketBase is by interacting with its Web
APIs directly from the client-side (e.g. mobile app or browser SPA).

It was designed with this exact use case in mind and it is also the
reason why there are general purpose JSON APIs for listing,
pagination, sorting, filtering, etc.
Other than the web API, there are also Javascript and Dart SDKs.

From Pascal, the API is your best bet. Then you're building a Pascal
SDK for Pocketbase, essentially. But
https://github.com/pocketbase/pocketbase/issues/945 was closed "not
planned" on providing an OpenAPI/Swagger API spec. So no automatic
code gen, meaning you'll have to wrap the APIs in Pascal manually.

Pocketbase is a simpler, one-server non-scalable clone of
Firebase/Supabase. The latter two have unofficial Delphi SDKs which
may or may not be usable with FPC/Lazarus.

----------------------------------------------------------------------
steve612 · 2026-03-13 16:50

Thanks for the information!

What is your opinion would building a public API for Lazarus would
help?

With local databases Lazarus is great but not secure hosting a
database over the internet with Lazarus that interacts with it. That
is the main goal.

----------------------------------------------------------------------
PierceNg · 2026-03-14 05:29

If you make a database open over the Internet then it will be
attacked. Here's a recent example; if no data of value was lost I
suppose one can lol it off: https://akselmo.dev/posts/they-broke-my-
server/

Services like Firebase and Supabase are backed by big money to buy the
people and tech to protect their databases. Other people build server-
side applications to expose a smaller (than databases) surface to
their data.

As for Pocketbase, are you planning to self-host or use their cloud
service?

If you are self-hosting, you may want to look into mORMot to program
both server- and client-side in Pascal instead.