database

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

Hello! Can you please tell me which SQLite data browser is preferable to use today? My database consists of several tables with a fairly complex structure with not very many records. I see a lot of bad reviews for the classic ""DB Browser for SQLite"", but maybe users didn't explore it well...

Hi there... This is a very simple but very helpful application (for those want to know B4X and use it for CRM,CRUD,business general apps etc) I wanna share it with you guys !!! Well a big reason for that price is in Greek Language... but not difficult to understand the code and what you can...

I'm using a custom type that consists of keys like title, text, datetime, keywords etc. My simple "database" is just a list of hundreds of these. The problem is that as for now I'm using their Unix times to identify them, and that was a big mistake, as due to how the app works there will be...

Hello, hope you are fine. At present I have a probleme that I did not have before updating b4a suite to 11.20. and I need professional help. Sub Process_Globals Public SQLite As SQL ' Database object Sqlite Version 3 End Sub Sub Service_Create Try ' # copy...