[SQLite]

I wrote https://wapp.tcl.tk/ for occasions such as this. SQLite is built-in, of course.

One key feature Wapp is that identical code can be run as

+ CGI from Apache

+ SCGI from Nginx

+ As its own stand-alone webserver

So, for development work on your desktop you run it as a standalone webserver. It even pops up its root page in your webbrowser automatically when you launch it. Then, once you get things working there, you "scp" the one small source-code file that implements your application up into a CGI-enabled directory of you server, and is just works.