Search Results

SQLite databases are very easy to use as they don't require any additional software or configuration. SQLite support for concurrent access is not comparable to server based databases... there aren't many writings (ExecNonQuery). B4J v2.00 adds support for concurrent access to SQLite... classes. Don't use a ConnectionPool with SQLite database. - When you create the database you need to...) You only need to set the journal mode to wal once. Read more about wal mode: https://www.sqlite.org/wal...

Attached you find a small project to convert csv files to a SQLite database. The program: - detects automatically between the two separator characters ',' ';'. - determines... csv / Time to convert. The CsvToSQLiteExe file is still the old file, a new file with Java 11 is too big. I left also the previous version zip file. EDIT: 2021.09.18 Added the use of SQLite transaction, suggested by Diceman in post #6. EDIT: 2021.01.29 Added an exe file: CsvToSQLiteExe.zip...

As I don't use SQLite (or any other SQL) all the time and am no database expert, it's...: BCTextEngine, DesignerUtils, jControlsFX9, jSQL, XUI Views - Non-core libraries: sqlite-jdbc-3.39.2.0 (or newer) - Modules from the project's root folder: Arrows.bas, wmSQLiteSelectBuilder.bas, wmWiLNetChart.bas - Files from the project's Files folder: BBCV.bjl, wmSQLiteSelectBuilder.bjl Example... (https://www.sqlitetutorial.net/sqlite-sample-database), and the attached file 'saved_example...

/threads/class-jrdc2-b4j-implementation-of-rdc-remote-database-connector.61801/) that supports SQLite... bug in /test handler. Cannot close DB if it is SQLite. ' '2020/04/24 Changes: '... GetIPAddress to access IPAddress configuration. 'Added support for SQLite. If the DriverClass contains SQLite (case insensitive), then jRDC ' is configured for SQLite usage. SQLite does not use pools... configuration option. This option is used for the SQLite backend ' (if used). If set to True or set...

Updates jRDC2 Server v2 is available jRDC2 Server Template Version: 1.12 (based on jRDC2 version 2.23) Create a new project and run it! To be accompanied with jRDC2 Client Template Introduction: To be edited 147014 Version 1.00 : 9KB Version 1.11 : 127KB Version 1.12 : 127KB Version 2.00 (beta) : 127KB Note: If you think the latest version is big, you can use version 1.00 otherwise yo...

Hi everybody! This thread is supposed to get all SQLite JDBC library version links together so as to find and download them easier. As a heavy B4J+SQLite user, I'm always looking forward to... to it! Sqlite-jdbc version 3.25.2 (2018.10.01) available for download HERE Implements UPSERT, ALTER TABLE ... RENAME COLUMN and added the Geopoply module. Sqlite-jdbc version 3.27.2 (2019.03.15) available for download HERE Upgrade to SQLite 3.27.2 Sqlite-jdbc version 3.27.2.1 (2019.03.20...

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

sqlite-jdbc-3.7.2.jar is the default SQLite JDBC library comes with B4X IDEs installation... is, it is a dependency for B4XTable for B4J. Recently, I tried to execute a SQLite query in B4J which... available in newer version of SQLite 3.25+. Even though I have specified #AdditionalJar to newer version of SQLite JDBC library, I am getting the following error: java.sql.SQLException: SQL error or... I renamed sqlite-jdbc-3.7.2.jar so the project cannot find or ignore this library. Then I got...

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

, CSS, JS, Bootstrap) Support MySQL and SQLite database (Can be modified for MS SQL or SQL Express) Separate SQL queries file (queries-mysql.ini and queries-sqlite.ini) Sample database auto-generated for... the SQLite section and uncomment the MySQL section. Edit the root password at line #45 (second last line). Save the file. 141155 In B4J project, comment the line '#AdditionalJar: sqlite-jdbc-3.39...-connector-java-8.0.30 ' SQLite connector '#AdditionalJar: sqlite-jdbc-3.39.3.0 #End Region...