HTML Compiler and sqlite?

DecSoft NeoPlugins pone sus proyectos de VisualNeo en otro nivel con +1.000 nuevas acciones para sus apps.

Cree apps multiplataforma con DecSoft App Builder, incluyendo Android e iOS, con la misma base de código.

DecSoft App Builder incluye un conveniente Compilador por línea de comandos para compilar sus apps desde la consola.

¡Eche un vistazo a nuestro canal de YouTube y suscríbase para recibir notificaciones sobre nuevos vídeos!

Ahorre dinero comprando nuestros paquetes de NeoPlugins. ¡Cinco, Diez e incluso nuestra colección entera a un precio increíble!

¡Eche un vistazo a algunas de preguntas más frecuentes sobre nosotros y nuestros productos!

Cree modernas apps y juegos HTML a otro nivel haciendo cosas que incluso las modernas apps y juegos HTML no pueden.

Compile, convierta sus modernas apps y juegos HTML en programas ejecutables sin dependencias para Microsoft Windows.

Diseñe para pantallas pequeñas y distribuya también (sin cambios) en dispositivos como tablets.

Cree apps y expanda sus capacidades usando el lenguaje más popular del mundo: Javascript.

Los plugins oficiales de Apache Cordova se incluyen de serie y hay cientos de ellos disponibles para su uso.

DecSoft HTML Compiler es fácil de usar: personalize su proyecto y compile sus apps y sus juegos rápidamente.

Los NeoPlugins de DecSoft tienen versiones "designtime" y "runtime" para reducir el tamaño de sus apps.

DecSoft HTML Compiler incluye un conveniente Compilador por línea de comandos para compilar sus apps desde la consola.

Ahorre tiempo, recursos y dinero creando apps para Android, iOS y más con la misma base de código.

DecSoft App Builder integra un asistente de Open AI para ayudarle mientras desarrolla sus apps.

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!

Todo el mundo puede leer el foro de soporte de DecSoft para aprender del mismo, sin embargo, sólo los clientes de DecSoft pueden abrir nuevos hilos. Compre una o más licencias de productos de DecSoft y obtendrá este y otros beneficios.