We have an Sqlite DB on our Linux/PHP production webserver. What is the best way to manage it remotely? I've found some server wrappers are available and some applications claim to offer remote access methods. Any suggestions?
+1
A:
SSH in and use the SQLite command-line client.
But...why are you using SQLite on a production webserver!? Even the SQLite website advises against this!
John Millikin
2008-10-10 02:09:30
Why can't it be used for production web server? See http://www.sqlite.org/features.html where they actually recommend it for this purpose.
mhawke
2008-10-10 03:12:42
I'm manipulating an existing client's Shopsite DB which uses SQLite behind the scenes. There's nothing inherently wrong with using SQLite in production for sites with low/moderate traffic. - http://www.sqlite.org/whentouse.html
Cory House
2008-10-10 03:24:22
+1
A:
Gindi's SQLITE client/server at Codeproject looks like an interesting and serious attempt at a wrapper.
ravenspoint
2008-10-10 11:39:11