[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...
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
- nullslast
B4X:
"Tasks_Id.desc"
B4X:
Dim Query As Supabase_DatabaseSelect = xSupabase.Database.SelectData
Query.Columns("*").From("dt_Tasks")
Query.OrderBy("Tasks_Id.desc")
Wait For (Query.Execute) Complete (DatabaseResult As SupabaseDatabaseResult)
xSupabase.Database.PrintTable(DatabaseResult)
B4X:
"Tasks_Id.desc,Tasks_Name.asc"
B4X:
Dim Query As Supabase_DatabaseSelect = xSupabase.Database.SelectData
Query.Columns("*").From("dt_Tasks")
Query.OrderBy("Tasks_Id.desc,Tasks_Name.asc")
Query.Limit(1)
Wait For (Query.Execute) Complete (DatabaseResult As SupabaseDatabaseResult)
xSupabase.Database.PrintTable(DatabaseResult)