database

  1. 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...
  2. M

    Android Question "Heavy work" and freezing - multithread?

    Hi everyone, I've an app that need to download an huge dataset. We are talking about making a http request the return a json of 8000 rows, that need to be stored in a local SQL DB in the device. Now.. the problem is the following: downloading and storing all the rows in the DB takes a while...
  3. S

    B4J Library Open street map viewer

    see https://www.b4x.com/android/forum/threads/open-street-map-viewer-gps.127827/ a B4Xlib for B4A and B4J to view Open Street Map
  4. S

    B4A Class Open Street Map viewer - GPS

    Hi, This b4Xlib contains a custom view (cvMap) which can display Open Street Map. The tiles are retrieved from the internet and cached in a database. You can add shapes and images on the map. UI : - Lat/lng Center of the map - Zoom Level - Compass Direction with rotation - Scale - Button...
  5. LucaMs

    B4i Library [B4X] lmB4XComboBox

    Version: 1.04 02/03/2021 https://www.b4x.com/android/forum/threads/b4x-lmb4xcombobox.116767/post-729765
  6. LucaMs

    B4J Library [B4X] lmB4XComboBox

    Version: 1.04 02/03/2021 https://www.b4x.com/android/forum/threads/b4x-lmb4xcombobox.116767/post-729765
  7. Mrk79T

    Italian DATABASE in remoto con B4A

    Buongiorno a tutti, dovrei realizzare una APP dove deve scrivere dei dati su un DATABASE che sto aprendo su ALTERVISTA. Ho frequentato un corso base di B4A tramite UDEMY, ora vorrei sapere se c'è un tutorial per vedere come accedere al DATABASE e come scriverci i dati una volta contenuto. Ho una...
  8. O

    Web/Database recommendations for prototype

    Greetings all To show proof of concept I need to make a simple web page, that connect to a database, which then the clients (B4A and B4I) connects to, in order to exchange data and receive tasks ect. I’m not much of a DB man (but I can if needed be hack my way through it), and certainty not a...
  9. A

    Android Question Example for LazyLoading from jRDC2

    Hi All, I can load/SELECT ALL data in a table from jRDC2 (mysql DB) with no problem, but I think this is not perfect in case of thousands of rows to return/SELECT from App performance standpoint, also I am aware that I can use LIMIT to limit the number of rows; however I am not sure how to...
  10. LucaMs

    B4J Library [B4X] lmB4XComboBox

    lmB4XComboBox is a b4x library (https://www.b4x.com/android/forum/threads/100383/#content). It works with B4A, B4J and B4i. It is a modified version of the Erel's original B4XComboBox and allows you to store in it a value for each text item. Not rarely (mainly handling DB data) you need a...
  11. rleiman

    Android Question Free database to lookup grocery item barcodes

    Greetings, I have a requirement from a customer who wants me to make an app that looks up the barcode from grocery items and extracts details such as the product name, photo of the product, etc. from a free trusted web site. I plan to use the b4aZbarBarcodeScanner to read the barcodes. When I...
  12. Scotter

    Android Question Basics of including database in my app?

    Hi - I've been out of the loop for a bit and wondering what the latest is in terms of including a database in my application OR being able to connect from a phone that is online to - say an instance of Postgres running on my server? Where is the latest documentation on this for B4A...
  13. Bruce Axtens

    Share My Creation Epoxy - proxy address manager REST

    Can be found on github. Written some years ago to manage proxy addresses and store reliability notes. In-memory database. REST-based. MIT license.
  14. ALBRECHT

    Android Question Sqlite Database options

    Hello, I like to get a suggest of method, regarding best practices for my App : 1/ i have an SQLITE db that contain general setting strings and language strings for its operation, and independent of user data. I systematicaly copy that DB from asset dir to Internal, so even after app updating...
  15. Pedro Caldeira

    B4J Question Best free Database for concurrent access

    Hello All, I am developing a multi side aplication that need to read/write to a database at the same time. With sqlite, I keep geting a database locked error, even with the pragma set to WAL. Is there a DB engine that is both free and that allow concurrent connections ? Thanks
  16. ALBRECHT

    Android Question Starting with MSSQL with jtds-1.3.1

    Hello, Im with B4X 9.30, working dev : Win10 I Want to connect with : External MSSQL DB Shared hosting : on Windows serv. 2012 Sorry im a newbie with MSSQL connecting script, but with that .jar : jtds-1.3.1.jar downloaded on : ttps://sourceforge.net/projects/jtds/files/jtds/1.3.1/ I dont...
  17. Mashiane

    B4J Library [BANanoSQLite] SQLiteDB PHP CRUD Class for BANano

    Ola UPDATE 2020-05-19: Please use this library instead Update: BANanoSQLite1 Example If you are opting for MySQL connectivity, BANanoMySQL is available here. My journey finally has led me to complete a basic wrapper that one can use for PHP SQLite access. Initially, we tried...
  18. Peter Simpson

    The art and science of password hashing

    Hello all, For a long time now whenever I create a bespoke database driven solution for a client I always make sure that the users database passwords and email addresses are encrypted using BCrypt with salt, that way I can tell my clients that their users details are securely stored in their...
  19. D

    Android Question Database Error

    I am learning how to use SQLite and DbUtils. I have written code that creates a db and a table. It then writes values to the table. However it does not seem to be able to retrieve them. Not too sure what is wrong with the code, as it is pretty much what is in the tutorial video. Here is the...
  20. 3

    Android Question mysql connection problem

    Hi I'm trying to connect to my sql server from android. I am at the beginning, that is, with the connection and I am already at rest I wrote this with my credentials but it never initializes Sub Button1_Click Dim db As MYSQL Dim L As List...
Top