supabase

https://www.b4x.com/android/forum/threads/b4x-xui-as-featurerequest-payware.163524/ In this example I show you how to use supabase as a backend for the AS_FeatureRequest quickly and easily. Supabase...

AS FeatureRequest is a lightweight, easy-to-integrate library that allows you to present a list of potential features to your users, enabling them to vote on the ones they find most valuable. By collecting and prioritizing user feedback, you can accelerate the development of the most desired...

https://www.b4x.com/android/forum/threads/b4x-supabase-the-open-source-firebase-alternative.149855/ Perform a function call. You can call Postgres functions as Remote Procedure Calls, logic in your database that you can execute from anywhere. Functions are useful when the logic rarely...

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