Android Example [B4X] Supabase - Supachat chat example app

[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 simple B4X chat example with supabase as backend.


Setup Supabase

create table
  public."dt_Rooms" (
    id bigint generated by default as identity,
    name text not null,
    created_at timestamp without time zone not null default now(),
    created_by uuid not null default auth.uid (),
    constraint dt_Rooms_pkey primary key (id),
    constraint dt_Rooms_created_by_fkey foreign key (created_by) references auth.users (id)
  ) tablespace pg_default;

create table
  public."dt_Chat" (
    id bigint generated by default as identity,
    room_id bigint not null,
    created_at timestamp without time zone not null default now(),
    created_by uuid not null default auth.uid (),
    message character varying not null,
    constraint dt_Chat_pkey primary key (id),
    constraint dt_Chat_created_by_fkey foreign key (created_by) references users (id),
    constraint dt_Chat_room_id_fkey foreign key (room_id) references "dt_Rooms" (id) on delete cascade
  ) tablespace pg_default;

We need a join on the auth table, this is not possible, so we need to create a new public.users table and create a database function, so we can call it in a database trigger:

Supabase table joins with auth.users

Can we do a join with a table in a schema that is not public? for example, join the auth.user with Public.user? If not, are there any work arounds? Thank you.

www.b4x.com

dont forget to turn on Realtime and set your RLS permissions

Libraries

• AS_TextfieldAdvanced
• AS_Label
• Supabase

Have Fun

 

[Alexander Stolte]

When you register, we create an anonymous account, the email address and password are randomly generated. If the user deletes and reinstalls the app, they must register again.
Supabase unfortunately does not yet support anonymous login, hence this workaround

 

[Alexander Stolte]

Example project has been updated due to the breaking change in V1.19

 

[byz]

hi,@Alexander Stolte ,i got an error in b4j when i run the chat example.where link i should to down jetty_b4j.jar

 

[Alexander Stolte]

link i should to down jetty_b4j.jar

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

 

[byz]

thank your answer, i test again.
?This error is caused by not checking jserver, not jetty_b4j.jar the file. It's easy to misunderstand for newbies.
thanks again. Alexander Stolte，its run.....