database

  1. 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...
  2. 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...
  3. 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.
  4. 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...
  5. 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
  6. 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...
  7. Mashiane

    B4J Library [BANanoSQLite] SQLiteDB PHP CRUD Class for BANano

    Ola 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... Distributing and Accessing SQLite Databases However, the...
  8. 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...
  9. 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...
  10. 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...
  11. 3

    Italian connessione a db sqlserver su server aziendale

    Buonasera, vorrei col mio telefonino creare un app che mi permetta di farel' update di dati che ho su un database aziendale. Di solito su VB.net usavo laconnessione OLEDB o SQLclient esiste qualcosa di simile? Quindi una volta aperta la connessione fare le query, le update ecc in sql. Ho...
  12. I

    Android Question About duplicate entry in a database

    Hi, i don't know how to detect a duplicate entry on my database. I obtain a Job.Success = false but a don't know how can i know that is not success for this reason :( Can you help me?
  13. DonManfred

    B4A Library ExternalLogger (using Google Room Database)

    This is a wrap for this Github-Project. ExternalLogger External logger library for android applications. You can save logs in any component in your app (Activity, Service, Fragment). The data will be stored in memory even after exiting the application or turning off the device. You can access...
  14. E

    Android Question Database file added in apk file

    Is it Possible to add a Database File (Sqlite) in Andriod Application. If yes how it is possible. My requirement is this database file install in my Andriod Device during installation of APK file. So that I can read,edit, modify its content.
  15. Scotter

    Android Question Wanting advice: Making multiplayer card game

    I'm wanting to make a multiplayer card game and looking for advice or ideas before I spend eons making the same mistakes other people already made :) I've already prototyped a database in MS Access. I will export to something like mySQL or SQL Server, depending on various factors. I have a...
  16. carlos7000

    Spanish ¿Cómo actualizo una base de datos?

    Hola a todos. Me pregunto si alguien me puede ayudar con unas lineas que me permitan comparar, al iniciarse el programa, la base de datos del dispositivo contra la que se encuentra en File.DirAssets, y si es una versión anterior, reemplazarla con la una nueva, todo esto, antes de que el...
  17. J

    Android Code Snippet Concept for VERY fast temporary IO

    SubName: N/A its simply a concept/idea that would appear very easy to implement, with possibly great benefits for performance. But totally untested, only created it and put a file in it, and it acted just like normal storage. Description: Historically, I have seen my IO access on storage around...
  18. PatrikCavina

    Other SQL History tables

    Hi to all, I'm building database structure in SQL, i want hold history of change in record in tables that have many to many relationship. Tables are A, B and AB_Map where AB_Map table is the link table between A and B. Considering table B immutable (records inside table B never change so table B...
  19. MegatenFreak

    B4J Question Using jSQL to Lock a mySQL table for writing

    Hello. I'm writing an app that allows several computers to add new orders to the database. To avoid any conflicts, I want to make sure that when one system is adding a new list of orders, no others can interrupt and will have to wait for the first one to finish up. I understand that the most...
  20. Cornelius Smit

    Android Question GPS Running and tracking in background

    Good day are there any sample application in B4A to do gps tracking and updating a database even when the screen is locked.The app needs to start when the device boot and update at all times.
Top