DecSoft Support - SQLite plugin and offline database use

SQLite plugin and offline database use

Take a look at some frequently asked questions about us and our products!

Apache Cordova's official plugins are supported out of the box and there are hundreds of plugins ready to use.

DecSoft NeoPlugins are available in both runtime and designtime flavours to keep your apps as small as possible.

Create modern HTML apps and games at another level making things impossible to do even by modern HTML apps and games.

DecSoft App Builder include a convenient Command Line Compiler, so you can compile your apps from the console.

DecSoft App Builder integrates an Open AI assistant in order to assist you while developing your apps.

Compile, convert your modern HTML apps and games into Microsoft Windows executable programs without dependencies.

Save money by purchasing our NeoPlugins bundles. Five, Ten and even the complete NeoPlugins collection at an incredible price!

Save time, resources and money creating apps for Android, iOS and more with the same base of code.

Design for small screen devices but deploy also (without changes) in larger devices like tablets.

DecSoft NeoPlugins put your VisualNeo projects into another level with +1,000 new actions for your apps.

Create multiplatform apps with DecSoft App Builder, including Android and iOS with the same base of code.

DecSoft HTML Compiler include a convenient Command Line Compiler, so you can compile your apps from the console.

DecSoft HTML Compiler is easy to use: set your project's options and compile your apps and games in a nutshell.

Create apps and expand their capabilities by using the world's popular programming language: Javascript.

Take a look at our YouTube channel and subscribe to be notified about new videos!

Ryan Sytsma

So, here is my use case for my app.

I am writing an application for a company in British Columbia Canada that contracts with the electrical utility. I created a web application that takes in the contract given to my client, and parses it out into individual tasks. They will have the tasks accesible by the Android device. Some of the work they do takes them into very remote areas of British Columbia and so I need to be able to download records to take offline.

I have already written a web api in C# and I am retrieving records into AB fine.

One contract will have about 500 related tasks and between 5,000 and 9,000 task detail rows.

I have seen some people here using Pouch DB and I am curious of anyones experience in offline data.

Ryan

DecSoft

Hello Ryan,

I have not experience using PouchDB (maybe other customers can post here something about) even when here in this forum it's possible to find some posts related with PouchDB. The main problem with offline data is that the browsers vendors (probably with good reasons) don't allow us to use the file system, so, we can't store database files, etc. We can use the app's local storage, but, maybe it's not enough (even when it's quite powerful).

Talking about Android and other platforms the above problem do not exists, that is, in this case we can access the file system using some Apache Cordova plugins, in fact, we have actions ready to use like "FileRead" and "FileWrite". Just this can be a possible way to store not only text files, but also JSON files, for example, so we can load it and use it in our apps in an "offline" way.

We can't forget the server's databases, since they can offer us all their power, and we can just use certain scripts in the server side in order to communicate with that databases and work with them. I don't have experience using some Apache Cordova SQLite plugin, but I am sure that must works as expected, so, if our targers are Cordova platform's and not the browsers (even when we can provide another approach in this last case) we can think to use an Apache Cordova plugin to deal with SQLite... or maybe another kind of client databases too.

Purchase one or more licenses of our products if they are useful to you!

Everybody can read the DecSoft support forum for learning purposes, however only DecSoft customers can post new threads. Purchase one or more licenses of some DecSoft products in order to give this and other benefits.