Re: [sqlite] Simple web query tool

2017-02-04 Thread Cecil Westerhof
2017-02-04 5:54 GMT+01:00 Lindsay Lawrence : > > "Sqlite just does it's thing with a minimum amount of fuss and minimal > impact on system resources, can't rave enough" > > Yes! A while back, when I first tried what I outlined it worked so well I > took it a step further. >

Re: [sqlite] Simple web query tool

2017-02-03 Thread Lindsay Lawrence
> "Sqlite just does it's thing with a minimum amount of fuss and minimal impact on system resources, can't rave enough" Yes! A while back, when I first tried what I outlined it worked so well I took it a step further. With nodejs async io, streams and a bit of javascript glue code, it is

Re: [sqlite] Simple web query tool

2017-02-03 Thread Michael Falconer
> > Running the sqlite3 command-line shell via cgi works way better than you > may expect. > ​Yay verily, and that is really not doing a great tool justice. I've done a lot of similar things to what Lindsay outlines above both with web and application targets, Often these procedures are set up as

Re: [sqlite] Simple web query tool

2017-02-02 Thread Lindsay Lawrence
Running the sqlite3 command-line shell via cgi works way better than you may expect. The command-line shell has a small footprint and works well with stdio in batch mode. You can run a shell script that runs an instance of the cli shell and reads and runs a .sql file. The sql file and bash can

Re: [sqlite] Simple web query tool

2017-02-01 Thread Warren Young
On Feb 1, 2017, at 11:45 AM, Brian Curley wrote: > > internal file shares are all that's needed to > connect to a distributed file. …as long as your networked file system does locking properly: https://www.sqlite.org/lockingv3.html#how_to_corrupt

Re: [sqlite] Simple web query tool

2017-02-01 Thread Brian Curley
Would the SQLite Manager extension on Firefox suffice? I don't know the scope of your use case, but internal file shares are all that's needed to connect to a distributed file. You can achieve variables through a miscellaneous table and coalesce() as needed. Regards. On Wed, Feb 1, 2017 at

Re: [sqlite] Simple web query tool

2017-02-01 Thread Doug Currie
On Wed, Feb 1, 2017 at 11:10 AM, Jay Kreibich 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. While I wouldn't call it extremely simple, the

Re: [sqlite] Simple web query tool

2017-02-01 Thread Simon Slavin
On 1 Feb 2017, at 4:10pm, Jay Kreibich 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