B4J Tutorial Pocketbase CRUD REST API & SSE with PostMan and then HttpUtils

Hi

CRUD Examples Attached

PocketBase is an open source backend consisting of embedded database (SQLite) with realtime subscriptions, built-in users management, convenient dashboard UI and simple REST-ish API.



It runs on Linux, Windows and Mac, You can get it here, https://pocketbase.io/

We will look at each offering using HTTPUtils, thus covering the REST API both with postman & b4x.

Here we go.

PS: Do not forget to start the server

 

[amorosik]

We may not yet fully realize the implications of this technology
But even at first sight it is really very effective
Many thanks for generously sharing your technical skills

 

[Johan Hormaza]

How can I run the server on a MAC?

 

[Mashiane]

Open a command prompt and go to the folder pocketbase is installed in and perhaps try, ./pocketbase serve

I dont have a mac, sorry..

 

[giannimaione]

hello,

your examples attached work fine,

i click on "Connect2SSE" and "Subscribe 2 SSE",
and after update / create (from browser admin) a record, app response with:

Private Sub pb_SSE (Action As String, Response As Map)
    Log("pb_SSE")
    Log(Action)
    Log(Response)
End Sub

OK! PERFECT!

but after ~ 60 second it will response

Private Sub pb_Disconnected (Status As Boolean)
    Log("pb_Disconnected")
    txtOutput.Text = $"Disconnected: ${Status}"$
End Sub

from documentation of pocketbase

Establishes a new SSE connection and immediately sends a PB_CONNECT SSE event with the created client ID.

If the connected client doesn't receive any new messages for 5 minutes, the server will send a disconnect signal (this is to prevent forgotten/leaked connections). The connection will be automatically reestablished if the client is still active (eg. the browser tab is still open).

I get disconnected after 60 seconds, but not after 5 minutes
why?