database

  1. yustas1955

    Обновление базы данных

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

    Share My Creation Radio Frequency Channel Monitor - Logger for Tine Spectrum Analyzer (TSA)

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

    Android Example [B4X] Supabase - INSERT or UPDATE a record and return it

    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")...
  4. Guenter Becker

    Wish New Properties

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

    Android Example [B4X] Supabase - Realtime Postgres Changes

    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/...
  6. 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...
  7. F

    Android Question Update .db File from CODE ||| Actualizar archivo .db desde codigo

    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...
  8. 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...
  9. 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...
  10. C

    Wish InfluxDB client library

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

    iOS Question Reading data from a table with FLOAT datatype fields

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

    Android Question Firebase RealTime Database tag name

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

    SithasoDaisy: Mashy Teaches TailwindCSS using b4x (with eBook)

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

    Android Question Retrieve simple value from web Server

    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...
  15. Guenter Becker

    B4A Library TDDBUtils Functions to handle SQLite and SQLCipher

    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...
  16. Guenter Becker

    B4A Library TDDButils Database Management for SQlite and SQLiteCipher

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

    B4J Question jMongo - a few questions

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

    Android Question What is the best SQLite data browser to use?

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

    Share My Creation Simple Database Application in B4J (a Catalog for Car Parts)

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

    Android Question Can I modify a custom type, while it's already used in a database list?

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