SimpleSQL is an HTTP API that allow complete control over a SQLite database.
One of the most compelling use case is to SimpleSQL to create completely static webpages that can operate against one database. This would allow to create very powerful webapp that don’t need a server backend. All the interaction with the database can happen directly from the client frontend code.
A common way to host a simple web app, is to use Github pages, which offer a free space for open source projects.
In order to use SimpleSQL you need to allow the browser to make CORS requests against
simplesql.redbeardlab.com. Doing so allow the browser to make HTTP requests against the
Fortunately github pages already allow it, so no step is necessary for the CORS.
SimpleSQL provide also a JS SDK, which makes writing application simpler.
In order to use the SDK is sufficient to import it adding the following line in the head section of your html pages.
Once imported the SDK it will be possible to invoke all the SimpleSQL functions, like:
SimpleSQL.newDatabase() to create a new database, or
SimpleSQL.command(db, "select 1;") to execute a command against one database.