HTML Compiler and sqlite?

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

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

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

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

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

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

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.

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

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

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

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

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

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

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

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

Bryce Beattie

Any chance you might someday build in a way to directly work will sqlite databases? I'm starting to put together a solution that uses appGetCmdOutput to run sqlite3.exe commands and parse the output, but there will be some quirks. I think they could be avoided if the app could access the db via the dll instead.

DecSoft

Hello Bryce,

Right now we are really, really busy, preparing the first public release of the new DecSoft App Builder, so, it's not possible to promise nothing right now, and, it's not our style to lie to the people saying "yes" to all... without the intention to do nothing...

After the publication of the new DecSoft App Builder, we want to improve DecSoft HTML Compiler: it's our intention, but, we don't decide what exactly we want to do. So, at that time, we will take a look at SQLite and what we can do around it.

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

Bryce Beattie

Fair enough, thanks. Best of luck with the new App Builder!

DecSoft

Thanks Bryce! :-)

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

Amin Mousavi

Bryce Beattie, PhoneGap has a SQLite plugin that you can install on App builder and use. I have not used in AB myself to give you the details but since I am using other phone gap plugins here, you should be okay. On a general note though, I recommend you to stick to objects and arrays and store them in local storage if your data is small. Running SQLite and the errors is causes when building the app on cordova is a pain in the neck. So after a few month of use we got rid of it and wend back to good and easy to use objects and local storages. Hope it helps

Bryce Beattie

Amin, thanks for the heads up. Right now, I'm mostly using HTML Compiler rather than the App Builder, And I've come up with 2 solutions to use databases. The first was because I had a large dataset in sqlite format, so I wrote an interface that uses the command line version of sqlite, and parses out the text it returns. That one has some issues, but works well enough fetching data, which is what I really needed it for.

The second solution was to use an in-memory javascript database that has some concept of persistence built in. I'm using loki.js, and all I had to do was write a handler that takes a serialized version of the database and reads/writes it to a file via HTML Compiler's file functions. This wouldn't be ideal for an enormous database, but it's been working great for the projects I've been working on. I should probably post that code somewhere.

Amin Mousavi

Is it mandatory for your purpose to handle the data on the client side? I find managing the large amount of data on the client side frustrating! Great to know you have sorted the issue out :)

DecSoft

Hello to all,

This post is just to mention that with the new generation of DecSoft HTML Compiler, now it's possible to deal with SQLite databases using the SQL.js library. Take a look at this release information post.

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.