Search Results

SQLite Viewer is an open source application that allows you to view the contents of SQLite databases right from your Android device. http://www.b4x.com/basic4android/images/sqliteviewer_1.png http://www.b4x.com/basic4android/images/sqliteviewer_2.png Choosing the database file is done with an external file manager or with agraham's FileDialog. After choosing a database file, you will see a list with the database tables. Choosing a table will open the second activity which shows...

This code snippet is based on tutorial TextEditor - Save and load external files here. This is my answer to this question. Instead of writing a text file, we can make use of the same idea to backup and restore our SQLite database. Check post #4 for restore database. Sub Class_Globals Private Root As B4XView Private xui As XUI Private SQL1 As SQL Private FileHandler1..., "backup.db"), "application/vnd.sqlite3", timestamps & ".db") Wait For...

B4XTable Sample 1 A sample project to demonstrate loading SQLite data into B4XTable Android Devices data (JSON) downloaded from Internet GitHub: https://github.com/pyhoon/B4XTableSample-B4X B4XTable Sample 2 Another sample project to demonstrate loading SQLite data into B4XTable Sample Customers... as Map Store the data into SQLite database Perform CRUD functions like add, retrieve, edit, delete... shows how we can interact and work with B4XTable by connecting it to a SQLite database. In fact...

.NoClassDefFoundError: Failed resolution of: Lnet/sqlcipher/database/SQLiteDatabase; at anyhwheresoftware....ClassNotFoundException: net.sqlcipher.database.SQLiteDatabase ... 19 more ** Activity (main) Resume...

117753 This library is based on B4XSearchTemplate. The difference is that instead of building an in-memory index, it uses a SQLite database. It is relevant when you want to search large collections. I've tested it with a collection of almost 400k items. It starts immediately and the search is fast. The idea is to build the database once with B4J and then add the database file to the project. SearchView.BuildDatabase builds the database. Note that it uses MAX_LIMIT and...

We are all familiar with AI Embeddings. They are the base in RAG (Retrieval Augmented Generation) for AI. This library converts SQLite and every database into a vector database. The embeddings of the chunked text must be saved as text (the json list toCompactString) in SQLite and the other non vector DBs. This means that you can do RAG without accessing external databases (or using in B4J also other non vector databases) directly in your iOS, Android, Window/Linux/Mac app. It contains all four...

Some users asked here for a simple SQLite project as an example to make their first steps in SQLite... are explained in the B4XSQLiteDatabase Booklet. Attached three small projects: - SQLiteLight1 A very... - Delete an entry - Display next and previous entry - SQLiteLight2 A simple project with some more... - LastName - City - SQLiteLight3 Same as SQLiteLight2, all functions are the same. The differences...) -- uncomment this line : CreateDataBase - SQLiteLight4 Multi table example: The database has three...

A couple of weeks ago, Klaus set me up with a new SQLite Project. I had a working B4A SQLite project with perfect column sorting which he converted to SQLite but with B4X pages now involved. From the very start, I was unable to get the columns to sort when the headers are clicked. It seems as though plenty of code is included with the new project which appears to enable the table to sort properly, but something is blocking the sort function. I have tried for weeks checking lines of code...

After running some faulty code I ended up with a faulty entry in the SQLite SQLite_Master table. This was a table name called NON_CLINICAL.db.JOURNEYS. This name is faulty and was causing all sorts of problems. Note that is not a table name that is accessible with normal SQL. Now it is not that easy to get rid of this faulty row in SQLite_Master, but this simple SQL did the trick: drop table "NON_CLINICAL.db.JOURNEYS" Note the double quotes around the faulty table name. This got rid...

Hi all, which could be the preferable way to export some data from an internal sqlite table? A bit of context. An app stores some data in one or more tables while the DB is initialized in DirInternal. A SELECT statement is needed to extract only some data. Columns are of different data types (mainly INTEGER and TEXT), but Text columns can contain multiline text (i.e. CRLF separates those few rows saved in a given Text field). BTW, multiline text comes from a Preference Dialog Multiline input...