supabase

https://www.b4x.com/android/forum/threads/b4x-supabase-the-open-source-firebase-alternative.149855/ Supabase now supports anonymous user login, the B4X library now too. https://supabase.com/blog/anonymous-sign-ins Create and use anonymous users to authenticate with Supabase Enable Anonymous...

Hello team, Last month i created a webapp using both of them. Everything working fine in debug and release mode in my pc (localhost:8081). When i upload at my ubuntu VPS, i encounter many errors. Here is a sample code that i use to store personal data to Supabase: Sub btnSave_Clicked(Target As...

Good morning team, Everything was working fine until i uploaded realeased jserver to VPS (fresh install). jServer was starting normally and webapp was visible but connection to supabase was unavailable. So i checked log files and here are the results: SupabaseAuth: User is logged out, this user...

https://www.b4x.com/android/forum/threads/b4x-supabase-the-open-source-firebase-alternative.149855/ It is possible to create a new data record and return it directly. Use the SelectData property Dim Insert As Supabase_DatabaseInsert = xSupabase.Database.InsertData Insert.From("users")...

https://www.b4x.com/android/forum/threads/b4x-supabase-the-open-source-firebase-alternative.149855/ You can use column aliases in Supabase. All you need to do is write the alias name, a colon and then the column name. 'AliasName:ColumnName Query.Columns("Name:Tasks_Name") Dim Query As...

Good afternoon, I am getting the following error when running Supabase Chat. ResponseError. Reason: , Response: {"code":"23503","details":"Key is not present in table \"users\".","hint":null,"message":"insert or update on table \"dt_Chat\" violates foreign key constraint...

Hello, I am doing my baby steps with Supabase and i will post here my findings in case someone needs them. 1) If you JOIN tables and filtering, then you will get results even it is equal with filter even it is not. So, in order to INNER JOIN tables and get only results that corresponds with...

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.

https://www.b4x.com/android/forum/threads/b4x-supabase-the-open-source-firebase-alternative.149855/ This is a simple B4X broadcast example with supabase as backend. Libraries AS_TextfieldAdvanced AS_Label Supabase V1.16+ Have Fun :)

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...

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...

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/...

https://www.b4x.com/android/forum/threads/b4x-supabase-the-open-source-firebase-alternative.149855/ 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...

https://www.b4x.com/android/forum/threads/b4x-supabase-the-open-source-firebase-alternative.149855/ LIMIT and OFFSET allow you to retrieve just a portion of the rows that are generated by the rest of the query. Official postgresql documentation...

https://www.b4x.com/android/forum/threads/b4x-supabase-the-open-source-firebase-alternative.149855/ You can order by just one column, or with multiple columns. Available sorting commands: desc To sort the records in descending order asc To sort the records in ascending order nullsfirst...

https://www.b4x.com/android/forum/threads/b4x-supabase-the-open-source-firebase-alternative.149855/ In the following example I make a join into the "public.users" table and need the column "username" from it. Dim Query As Supabase_DatabaseSelect = xSupabase.Database.SelectData...

https://www.b4x.com/android/forum/threads/b4x-supabase-the-open-source-firebase-alternative.149855/ 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...

https://www.b4x.com/android/forum/threads/b4x-supabase-the-open-source-firebase-alternative.149855/ Supabase Storage offers the functionality to transform and resize images dynamically. Any image stored in your buckets can be transformed and optimized for fast delivery...

https://www.b4x.com/android/forum/threads/b4x-supabase-the-open-source-firebase-alternative.149855/ This is a very simple tutorial on how to download a file and show the progress in a progressbar. With my small image there is not much progress, it makes more sense to use this function with...

https://www.b4x.com/android/forum/threads/b4x-supabase-the-open-source-firebase-alternative.149855/ This is a very simple tutorial on how to use the storage file options. Upload File Uploads a file to an existing bucket. Dim UploadFile As Supabase_StorageFile =...