On 1 Feb 2017, at 4:10pm, Jay Kreibich <j...@kreibi.ch> wrote: > I'm looking for an *extremely* simple web tool that will allow me to > configure a dozen or so stored queries, which people can then select and > run on an internal server. If the system supports a query variable or two, > that would be fantastic, but I don't even need that. Any thoughts? Or do > I dust off the PHP tutorials and spend an afternoon throwing something > together?
I never found one, and ended up writing my own for a similar need, which I cannot share because it belongs to my employer. PHP backend, using the sqlite3:: library which is a very thin shim over the standard C API, so there’s nothing to learn. JavaScript front end, in .html and .js files stored on the server. HTML5. Given who I’m writing to I don’t need to tell you to sanitise your inputs. My backend compares the IP address of the server the request comes from and the IP address of the server it’s running on. If they don’t match it assumes it’s a hacking attempt. I took a few other precautions like that. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
