Search Results

- SQLite version point to sqlite-jdbc-3.39.2.0 - Separate Category and Product handlers - FindHandler added for more search endpoints - Endpoints structure changed!
link: Updates: 25/08/2022 - Web API Server - v1.13 - Home page with Add, Edit and Delete Product (using Bootstrap modal and jQuery Validate) - Help or API d
link: Updates: 01/10/2022 - Web API Server - v1.14 - Manage Category in new page - Dynamic populate Category dropdown in add/edit product dialog - Improve J
link: I believe it is easy to achieve. :) Edit: I can't imagine using SQLite for the Web API server backend. I know it is possible but I like MySQL and Ad

From the link "SQLite is not a server": "If you want to stick with SQLite then you’ll need to put something in front of it that can handle requests from multiple client apps. The most obvious solution is to create a web service by using a web app with WebApplication.HandleURL (or HandleSpecialURL).
link: Sqlite works well with jRDC2 server which allows access using HTTP over the local network or Internet. It is extremely fast and secure. Check it out.
link: PC for server. I will often have 2 or 3 PCs using the system (cashier). At first, only the waiters will use the system on tablets or cell phones. In t
link: IMHO (again) - SQLite is great for mobile devices where one needs a DB. It comes pre-installed and is designed for them - NOT the backend server. MySQ

We had used a RDBMS (in distant past) called ValentinaDB SQLite Server. And it is working faultlessly even today!
link: Sorry to say but it is nonsense. SQLite is a very powerful database engine which is used by many servers. It is definitely a tool that developers sho
link: I like (or need?) to think... little. SQLite, if I'm not mistaken, was created to manage data on mobile devices, "personal" data. This is enough for
link: Should I use SQLite as my web server database? This has come up before and last week it came up again in the "Chit Chat" forum. The question has alre

Web server(Rest api using servlets)+sqlite is a solution to share data to android clients consuming rest api with httputils2.
link: Hi, I have a TV box running as a iot server, it is connected with an arduino via USB and communicate with other devices in mqtt. The server records

While SQLite is a great database, it is not suitable for a case where multiple processes access the same database directly. It will corrupt the database eventually. I guess that CubeSQL implements a server that serializes the requests. A similar thing can be done quite easily with jRDC2.
link: I have been exploring B4X for the last 2 week seriously although I have been looking since earlier this year. I think B4X programming tools is reall
link: Hi trisha! If cubeSqL is based on sqlite then is very likely that with the same jdbc driver you can connect both. Beside that, no you don't need an
link: Note: out of the box, jRDC2 does not support SQLite. You have to slightly modify it. A already modified version can be found here https://www.b4x.-jrd

Part #1: Get Started Part #2: Configure Settings Part #3: How Does the Project Work? Part #4: Server Handlers Part #5: Using Code Snippets Part #6: Add a New Field Introduction This tutorial is based on Web API Server 3. Installation Download and save Web API Server (3.00).b4xtemplate file into
link: Put this file in Objects folder and leave the SSL_KEYSTORE_DIR setting as <empty>. During production, you can use a real certificate or generate one u
link: Configure Static Files The ConfigureStaticFiles sub will take care of setting up the directory name and browse permission of static file folder. You

A member contacts me privately asking about putting SQLite database in other location instead of Objects folder. Here are the changes required: ## SQLite configuration: DriverClass=com.sqlite.JdbcUrl JdbcUrl=jdbc:sqlite:C:\\Users\\aeric\\AppData\\Roaming\\JRDC\\test.db Version 1.00: 'Class module
link: Version 1.10 is now released! What's New: New Homepage - Index page is now a default test page, with information such as DBType and status of databa
link: 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 Int

SQLite is not really a client server database such as PostgreSQL, MySQL, MSSql, etc. It is a local datastore that can be queried via SQL. The only way to connect to a remote SQLite database is through a form of drive/path mapping, but that even is not recommended by SQLite's website (https://sqlite.

To make it easy, I would say if you just need a standalone or offline database just for your B4A app inside an Android device, then SQLite is good to go. If you want to share the data or sync between more devices with another remote database server, then using MySQL as a database server is a better

Try search for sqlite + server project-template-jrdc2-server-sqlite-mysql-ms-sql-firebird-postgresql-dbf project-template-web-api-server project-template-user-login-server
link: Is it possible to connect a B4X-app to a SQLite database file that is located on a server, instead of using MySQL/MariaSQL? I have not found any exam

Powered by ColBERT