postgresql

  1. Alexander Stolte

    Android Example [B4X] Supabase - Database Joins

    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...
  2. Alexander Stolte

    Android Example [B4X] Supabase - Database CRUD

    https://www.b4x.com/android/forum/threads/b4x-supabase-firebase-alternative.149855/ This is a very simple tutorial on how to use the CRUD options. A more detailed tutorial is coming soon. CREATE Dim Insert As Supabase_DatabaseInsert = xSupabase.Database.InsertData Insert.From("dt_Tasks") Dim...
  3. Alexander Stolte

    B4A Library [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...
  4. V

    B4J Question another PostgreSQL + B4J Qn from a newbie

    after tested a few framework for cross platform app development tool, shortlisted Flutter/Dart & B4X/B4J. I am able to get the flutter to connect to a localhost postgresql database and hoping to do the same for B4J. After going thru 7 pages of PostgreSQL related thread using the search tool...
  5. G

    B4J Question Multi Tenant

    Hi. I am running multiple tenants by schemas in postgresql. How would it be with B4X to connect to the schema according to the corresponding customer. Client_1 is for Customer_1; Client_2 is for Customer_2; Client_3 is for Customer_3; Each customer has its users, restrictions, etc. Each tenant...
  6. amorosik

    B4J Question [B4X] jRDC2 - To use another db server where to modify the code?

    For use with Microsoft Sql Server, Postresql, Firebird, and so on, where is it necessary to change the code to keep it working correctly?
  7. Alexander Stolte

    B4J Question jRDC2 PostgreSQL how to call procedures

    Hello, how can i call procedures in jRDC2 on PostgreSQL? I call it so: CALL myprocdeure(?,?) but jRDC2 says: org.postgresql.util.PSQLException: ERROR: procedure sdbspget_checkuser(character varying, character varying, character varying, character varying) does not exist Hinweis: No procedure...
  8. Diceman

    B4J Question Problem using UUID parameter in PostgreSQL SQL statement

    I have a PostgreSQL SQL statement like: private SqlStr as String EmployeeId = "ef8ba4b3-7898-4240-aa8f-a0586ed04fb7" SqlStr = "select * from employee where employee_id=?" Params = Array As Object(EmployeeId) rs = SQL.ExecQuery2(SqlStr, Params) This will throw an exception...
Top