database

  1. 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...
  2. 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...
  3. 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.
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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
  11. 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...
  12. 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...
  13. 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...
  14. Guenter Becker

    Android Question Can not copy/open database?

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

    Android Question NO TABLE BUT THE TABLE EXISTS :android.database.sqlite.SQLiteException: no such table: pvpt ...

    Hello. Developing an app for weeks, I run it many times without any problems, bringing new features every week. This day, it stops running with this arror: What is interesting is that I never changed anything about the pvpt table for a long time. I work on other activities. My starter...
  16. Guenter Becker

    B4A Library extDBUtils

    Warm welcome to the audiance I hope you are well. Since Erel published DBUtils development of database driven app has become much easier. Very good job done! But who says that good work could not be polished up to get better? Every time I am using DBUtils I have to develop addional...
  17. adriano.freitas

    Android Question "This app was created for an older version of Android and may not work properly..." message

    Helo! I'm starting programming with B4A. When my first app runs, it checks if the database exists. If it doesn't exist, create it. If there is, use it. Everything works, however, when the database does not exist and he has to create a new one, the mobile application generates a message that...
  18. A

    Android Question "Name already used please try another name!" how to fix this?

    im makeing a app to database record and when i input a name "John" for example and there is already a record in database john its says "Name already used please try another name!" how can i remove it? im using dbequest manager and jrdc btw Sub GetSelectedRecord (NameSelectedItem As String)...
  19. SMOOTSARA

    Android Question Add columns to the sqlite table

    Hello friends 🌹 I have a sqlite database "master.db" with a table "table1" The columns of the table are: " ID, first_name, last_name" I want to check if there is no "phone_number" column, add it and save a data in "phone_number" column . (with coding sqlite commands in the program) 1_How...
  20. S

    Android Question Import or read db with 1.000.000 and more records

    Hi, i have a csv file with 1.000.000 and more records. My initially idea is read and copy the records into my sqlite database, because i want my records locally, but the file is too big and the app crash (450 mb). What is the best way to copy locally or it's better to read remotely this file...
Top