database

Hello B4X Community, I'm excited to share a new library I've wrapped for B4A developers. FrostPocketBaseMobile is a B4A wrapper around the Pocketbase-mobile library by Rohit Sangwan. This wrapper brings the power of a Pocketbase Server to your B4A projects, allowing you to easily integrate a...

Good Day hopping you are all well, I have a question concerning Database and Resultset. For Example if I am performing an SQL INSERT or UPDATE the data saved in the database ist changed but the data in the resultset is not! I understood that this objects are independend from each other and that...

Good Morning to you, as I understood the database itself and the Resultset are two independent Objects. INSERT/UPDATE DELETE will change the Database Data but the Resultset Data is not synchronized and is not effected by those actions. To solve this I save the SELECT statement and after doing...

Здравствуйте. Я только что начал заниматься с b4a. Я создал базу данных на компьютере. И одновременно создал аппликация для тестирования учеников. Хочу добавить или обновить базу с помощью аппликация. Помогите мне пожалуйста. Заранее благодарю за помощь.

Hi, I've built an app that uses the tiny spectrum analyzer to monitor preset channel amplitudes and logs them to an sqLite database. Before running the program open up B4J and set the parameters for your system in the networkPars module. 'Static code module Sub Process_Globals Private...

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

Dear Developers on 2023 and before you did a good job. Special Thank you goes to Erel based on his competent and excellent managing of the Forum Posts. This are my whises: Additional Database Properties to each View, ColumnName string, ColumnType string Additional Identification Property 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/ 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...

So basically what im trying to do is after that i have created some tables in a database, add some values to this tables is update all .db file. I already had initialize my SQL .db file and check if its no duplicate and stuff like that. All works like a charm but when i close my app, this...

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

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

Hello Everyone, I want to put a library on the wish list, for an iot application , it would be nice to have the possibility to connect to InfluxDB. This is a timerseries database. https://github.com/influxdata/influxdb-client-java Thanks in advance, Coldrestart.

Hi all I have a table in my database with fields datatype FLOAT. I'm reading values from these fields like this Dim rs as ResultSet Mytxt.Text=rs.GetDouble("BP1") MyTxt is B4XView If the value in this field is lower than 90 MyTxt.text shows whatever we have in this field. For example 45.3...

Hello, How can I control the tag of each input of the nosql database of firebase using B4a code: as example I need to change Tag name to "3000" instead of (-LUiRLRDm6WunRN01ohA) and...

Get SithasoDaisy for $15 here. Welcome to the SithasoDaisy world. Check $5 WebApps https://www.b4x.com/android/forum/threads/sithasodaisy-webapps-5-each.145871/ Join on Telegram Get the eBook See it in action on Netlify or See it from a FlipBook SithasoDaisy is a library of components...

Hey there, I'm struggeling with a very, kinda too simple Task. How should i retrieve a value from an external source? I have a Button whitch needs to be clicked in Order for the value to bei shown. The value is a simple String. Should i Just Put that String in a static html file hosted in a...

Library: TDDBUtils.b4xlib Language: B4A Version 1.8 Manual: Version 1.5.2 (did some checks and improvements, added SQLCipher tutorial) Status: Work in Process (C) This library is free for non commercial use other use see manual. New to 1.8: optimized code fixed some errors Added grouping and...

Name: TDDBUtils Type: b4a, b4xlib Version: 1 (C): TechDoc G. Becker Royalty Free for Personally/Commercial use for B4X Board Members This additional B4A library makes the live of standard Database Management for SQLite (unencrypted) and SQLiteCipher (encrypted) Databases a little bit easier...

Hi there How do I execute and get results of the following? Q1. On inset, i want to somehow execute getInsertedCount and get its result. Q2. On update, do similar with getModifiedCount Q3. On delete, do similar with getDeletedCount Q4. Can one use ResumableSubs with jMongo? Thanks in advance