From a HTML JS PHP Website to an Installable Desktop Application

1

DB Browser for SQLite

Nothing prevents you from using an external online DB as long as it is reachable, its configuration will let users connect to it and you are ok with a desktop application that needs internet to work. You could even serve APIs to do so. But if you need a portable DB inside the application, that will work locally and even without connection, you can use SQLite which is an embedded database that runs on the host machine storing everything on a single file, so it can lies inside the project folder itself. In order to use that I suggest you download SQLite browser (https://sqlitebrowser.org/). This tool will help you managing your SQLite DB, creating tables, editing records, and run queries. If you already built a small website with a MySql database, chances are you just have to dumb your db, run query to create it with SWLite and change the connection type to the DB. The rest will work as it was or will need a slight refactoring.

#Databases #Database Management #MySQL Tools 195 social mentions

2

Inno Setup

At this point we have a portable program to run, we could in fact create a shortcut to the Myapp.exe file, put it anywhere and all should work as an application. But that’s not the goal. We want an installable desktop application that anyone can install and run on pc. To achieve that we need another tool: Inno Setup (https://jrsoftware.org/isinfo.php). This is a free software that will transform our Myapp folder into an installable .exe file. So, download and install this software https://jrsoftware.org/isdl.php After installing, if the software didn't open automatically, open it and choose Create a new script using the Script Wizard (that’s the simplest way to go), then click next. This wizard is pretty self-explanatory, I’ll just point out some details that could be tricky:.

#Package Builder #Package Distribution #Website Builder 46 social mentions