Share My Creation Csv to SQLite program - klaus    Apr 24, 2023   (41 reactions)   tags: csv sql, Import, export 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... B4J Tutorial [WebApp] Concurrent access to SQLite databases - Erel    Nov 21, 2021   (14 reactions) 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... B4J Code Snippet [Project Template] jRDC2 Server (SQLite, MySQL, MS SQL, Firebird, Postgresql, DBF) - aeric    Jan 11, 2024   (16 reactions) 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 you can remove the images inside www/img or us... Bug? [EDIT: NO BUGS HERE] ExecQuerySingleResult (SQLite) - LucaMs    May 10, 2023 ExecQuerySingleResult seems to crash after a certain number of executions (in my case, in debug mode, about 25500) I placed some xxxxx in the log just for privacy reasons. java.lang.NullPointerException at sun.misc.FloatingDecimal.readJavaFormatString(FloatingDecimal.java:1838) at sun.misc.FloatingDecimal.parseDouble(FloatingDecimal.java:110) at java.lang.Double.parseDouble(Double.j... B4J Library SQLite JDBC - Library version updates - Claudio Oliveira    Aug 8, 2022   (15 reactions) 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... B4A Tutorial Android SQLite Viewer - Erel    Mar 18, 2018   (11 reactions)   tags: Lingui��as, Viewer, SQLite, Android 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... B4J Library Modded jRDC2 w/SQLite support and more - OliverA    May 28, 2020   (13 reactions) /threads/class-jrdc2-b4j-implementation-of-rdc-remote-database-connector.61801/) that supports SQLite.... '2020/05/28 Removed show-stopping bug in /test handler. Cannot close DB if it is SQLite. '... SQLite. If the DriverClass contains SQLite (case insensitive), then jRDC ' is configured for SQLite usage. SQLite does not use pools. Pool/non-pool handling gleaned ' from DBM.bas module of ABMaterial. 'Added CreateFile configuration option. This option is used for the SQLite backend '... B4A Library [B4X] SQLSearchView - SQLite based Search View - Erel    Aug 15, 2021   (20 reactions) 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... B4J Library [Class] [B4J] [SQLite] wmSQLiteSelectBuilder - a more or less graphical builder for SQLite SELECT statements - walt61    Aug 19, 2023   (20 reactions) 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... Share My Creation [Project Template] [Web] API Server - aeric    Dec 8, 2023   (67 reactions) ) Front-end (HTML, 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... open "config.ini". Comment the SQLite section and uncomment the MySQL section. 141155 6. Edit... the line '#AdditionalJar: sqlite-jdbc-3.39.3.0 and uncomment the line #AdditionalJar: mysql-connector... ' MySQL connector #AdditionalJar: mysql-connector-java-8.0.30 ' SQLite connector... Page: 1   2   3   4   5   6   7   |