Android Example [B4X] Supabase - Realtime

[B4X] Supabase - The Open Source Firebase alternative

Supabase is an open source Firebase alternative. It provides all the backend services you need to build a product. Supabase uses Postgres database with real-time capabilities. Basically, supabase provides an interface to manage postgres database that you can use to create table and insert, edit...

www.b4x.com

This is a very simple tutorial on how to use the Realtime module. A more detailed tutorial is coming soon.

Step 1
Click in your project on "Project -> Build configurations -> Conditional Symbols"
Put SupabaseRealTime and click ok

Step 2
Check in the libraries tab the following libs.:
B4A: WebSocket
B4I: iWebSocket
B4J: jWebSocketClient V2.0+

Step 3
Initialize the SupabaseRealtime class

Sub Class_Globals
    Public xSupabase As Supabase
    Private Realtime As SupabaseRealtime
End Sub

#IF B4J
Private Sub xlbl_Connect2Realtime_Click_MouseClicked (EventData As MouseEvent)
#Else
Private Sub xlbl_Connect2Realtime_Click
#End If
 
    Wait For (xSupabase.Auth.isUserLoggedIn) Complete (isLoggedIn As Boolean)
 
    If isLoggedIn = False Then
 
        Wait For (xSupabase.Auth.LogIn_EmailPassword("[email protected]","Test123!!")) Complete (User As SupabaseUser)
        If User.Error.Success Then
            Log("successfully logged in with " & User.Email)
        Else
            Log("Error: " & User.Error.ErrorMessage)
            Return
        End If
 
    End If
 
    '********Realtime part************************
    Realtime.Initialize(Me,"Realtime",xSupabase) 'Initializes the realtime class
    Realtime.Connect 'Connect to the supabase realtime server
 
    Wait For Realtime_Connected 'Client is connected
    Log("Realtime_Connected")
 
End Sub

Supabase provides a globally distributed cluster of Realtime servers that enable the following functionality:

[B4X] Supabase - Realtime Postgres Changes

https://www.b4x.com/android/forum/threads/b4x-supabase-the-open-source-firebase-alternative.149855/ Listen to Postgres changes using Supabase Realtime. https://supabase.com/docs/guides/realtime/postgres-changes Setup https://www.b4x.com/android/forum/threads/b4x-supabase-realtime.156354/...

www.b4x.com

[B4X] Supabase - Realtime Broadcast

https://www.b4x.com/android/forum/threads/b4x-supabase-the-open-source-firebase-alternative.149855/ Send and receive messages using Realtime Broadcast https://supabase.com/docs/guides/realtime/broadcast Setup https://www.b4x.com/android/forum/threads/b4x-supabase-realtime.156354/ Listening to...

www.b4x.com

[B4X] Supabase - Realtime Presence

https://www.b4x.com/android/forum/threads/b4x-supabase-the-open-source-firebase-alternative.149855/ Share state between users with Realtime Presence. https://supabase.com/docs/guides/realtime/presence Setup https://www.b4x.com/android/forum/threads/b4x-supabase-realtime.156354/ Sync and track...

www.b4x.com

Supabase Dashboard
You need to turn on the realtime feature for each table, a description can be found here:

Realtime | Supabase Docs

Send and receive messages to connected clients.

supabase.com

 

[OliverA]

In B4J there are problems in the websocket library and java 11.

Have you tried the recommended JDK 14 found here: https://www.b4x.com/b4j.html ?

 

[Alexander Stolte]

Have you tried the recommended JDK 14 found here: https://www.b4x.com/b4j.html ?

Unfortunately, does not work either. Has already been treated unsuccessfully in the following thread:

jWebSocketClient - cant connect

I get the following error message if i try to connect to "wss://b4x.com:51041/smiley/ws" Waiting for debugger to connect... Program started. 2023-10-11 09:54:11.167:INFO::JavaFX Application Thread: Logging initialized @3000ms to org.eclipse.jetty.util.log.StdErrLog...

www.b4x.com

 

[OliverA]

Has already been treated unsuccessfully in the following thread

All the issues with B4J WebSocket client come from trying to connect to the latest jServer that is included in B4J, which in turn is based on Jetty 11. Is the Supabase endpoint based on Jetty 11+? If not, you may be testing for the wrong thing. Have you tried the WebSocket test sites mentioned by @Erel here: https://www.b4x.com/android/forum/t...t-connect-at-first-attempt.142267/post-901816

 

[Alexander Stolte]

Is the Supabase endpoint based on Jetty 11+? If not, you may be testing for the wrong thing.

Well what should I test, the code that works under java 8 does not work with higher versions.
And I can't do more than call ws.connect with the websocket url.

Have you tried the WebSocket test sites mentioned by @Erel here: https://www.b4x.com/android/forum/t...t-connect-at-first-attempt.142267/post-901816

Does not work.

 

[OliverA]

Does not work.

I tried it also (today) and noticed it did not work. I put in a wish for an updated version. Currently, jWebSocketClient is based on jServer3. That may be the issue...

 

[Alexander Stolte]

Works now with B4J thanks to @OliverA and @Erel

For B4J you need the jWebSocketClient lib. V2.0+

jWebSocketClientV2

I wish for a jWebSocketClient library (that can have a different name, so as to keep the jWebSocketClient library that's based on Jetty3) that is based on the latest Jetty revision that is included in the latest B4J. This may resolve the Web Socket connect issues found on this forum when it...

www.b4x.com

I am working on a small example project where you can create chat rooms and then write to each other in real time. There I will still notice the one or the other optimization possibilities.

 

[Waldemar Lima]

Awesomeeeee.

but need change :

Private Sub xlbl_Connect2Realtime_Click_MouseClicked (EventData As MouseEvent)

by

Private Sub xlbl_Connect2Realtime_MouseClicked (EventData As MouseEvent)

 

[Waldemar Lima]

I detected a bug.
If I try to log in incorrectly, without first having at least 1 successful login, the messages below occur (apparently, when the login is successful, a supabaseauthtoken.dat file is created)
After the login is successful, this error no longer appears in cases of invalid logins.

however, if I delete this supabaseauthtoken.dat and try again with an incorrect login, the same error occurs again....

 

[Alexander Stolte]

Private Sub xlbl_Connect2Realtime_MouseClicked (EventData As MouseEvent)

is fixed, thanks

After the login is successful, this error no longer appears in cases of invalid logins.

is fixed in the next version, thanks

 

[Alexander Stolte]

Update

• Add section "Filter"
• Example Project updated

 

[Waldemar Lima]

What am I doing wrong?
Shouldn't realtime_data work just by creating a table and triggering its realtime?




code snippet:

    Realtime.Initialize(Me,"Realtime",xSupabase) 'Initializes the realtime class
    Realtime.Connect 'Connect to the supabase realtime server
    
    Wait For Realtime_Connected 'Client is connected
    Log("Realtime_Connected")

    'Subscribe to all database changes on dt_Chat with room_id = 3
    Realtime _
    .Channel("public","dt_Chat","") _
    .On(Realtime.SubscribeType_PostgresChanges) _
    .Event(Realtime.Event_ALL) _
    .Subscribe

    Wait For Realtime_Subscribed 'Successfully subscribed
    Log("Subscribed to topic")
    

End Sub

Private Sub Realtime_DataReceived(Data As SupabaseRealtime_Data)
    
    Log("working ?")
    
    If Data.EventType = Realtime.Event_UPDATE Then 'A record in the database was changed
        
        For Each k As String In Data.Records.Keys
            Log($"Column: "${k}" Value: "${Data.Records.Get(k)}""$)
        Next
        
    End If
    
End Sub

 

[Alexander Stolte]

What am I doing wrong?

You need to turn off RLS or define RLS rules.

 

[Waldemar Lima]

I'm thinking about creating an example using this Supabase module with jserver...
and I see that there is a file: supabaseauthtoken.dat, is this to maintain the Project Settings, or is it to maintain the current user's authentication token?

 

[PoppaBart]

What is the most effective way to keep a connection active indefinitely, in this example here, I did a test leaving the application active, however, for a long period of time without activity in supabase... and I get a timeout connection error.

Is there any way to deal with this by preventing the system from crashing or suddenly stopping working thanks to this disconnection?

 

[PoppaBart]

What have you set the Access token (JWT) expiry time limit to. A search of supabase tokens came up with this.

Supabase tokens are valid for a maximum of one week, or 604,800 seconds1. The default token expiry is 3600 seconds, or one hour

 

[Alexander Stolte]

Can you please create new threads for questions? If someone is also looking for these things, they won't find anything. And it's also nicer not to make threads pages long. Thank you.

and I see that there is a file: supabaseauthtoken.dat, is this to maintain the Project Settings, or is it to maintain the current user's authentication token?

As the name suggests, everything is saved there by your current logged-in user. (AuthToken,RefreshToken and so on)

 

[Waldemar Lima]

Can you please create new threads for questions? If someone is also looking for these things, they won't find anything. And it's also nicer not to make threads pages long. Thank you.

Of course, I'll create it now.
Thank you for the support!