Load SQLite database from remote SQL Server

[Kieran Blenkarne]

I would like to connect to a database for simple operations (select, insert ...). When I want to write a file everything works fine, but i would like to connect to a database that is NOT on the local machine. Is that possible to connect to a remote database with SqlLite? Thank you for your help.

[Zecho]

SQLite database files may be shared accross a network using a network filesystem. You don't really need an in-memory database, you can use SQL Server Express on your PC, or a unit-testing VM. These are alternative techniques for remote access to SQLite databases.

[Walby]

This is not the purpose of Sqlite is made to be small, lightweight form of local file. For this, it is better to use MySQL, which is made to connect to a remote server, without being too heavy.

[Aberto]

SQLite is a software library that implements a self-contained, transactional SQL database engine. SQLite allows you to represent your databases as ER diagrams, build queries visually, operate on all database objects, execute queries and SQL scripts, manipulate data (including BLOBs), SQLite is the most widely deployed SQL database engine in the world. The source code for SQLite is in the public domain.