Is it possible to use SQLite as a client-server database?

Question

Are there any techniques or tools to work with SQLite on a medium size/traffic/concurrency DB environment?

Answer 1

As stated before, sqlite is not a client-server application, and it is not built for highly concurrent operations.

Nevertheless, you can make it "sort of client-server", if you use ssh.

ssh user@host sqlite3 databasefile "select * from table"

works.

Answer 2

No, SQLite doesn't present a network endpoint - it is only accessible via the filesystem. It does support concurrent access from multiple processes on the same machine but at a very coarse-grained level (DML locks an entire table). So you could have a dozen Apache httpd processes all with a SQLite database on the local disk open, all doing SELECTs and it would work just fine. But really, it's the wrong tool for the job - I'd use Postgres in this scenario.