SQLite Maestro online Help
|Prev||Return to chapter overview||Next|
SQLite Maestro unites databases in groups at the Explorer tree. Database group is a pure logical structure and can be named by any convenient appellation (i.e. a database name, a database host, etc.).
As SQLite is implemented as an embedded database engine contained in a single DLL, SQLite databases usually are stored locally or in the shared folders. To connect to such a database, you should provide only a full database file name (e.g. C:\Data\SQLite\MyDatabase.db3) and (optionally) a password.
Though SQLite engine does not support network connections, SQLite Maestro provides you with a unique ability to manage remote SQLite databases using the HTTP tunneling technique. For this purpose, you need to have a webserver running on a computer that stores the database file. Of course this webserver should be accessible from your workstation and you should be able to upload files there.
To connect to a remote SQLite database using an HTTP tunnel, you need to:
Note 1. Do not forget to enable read/write permissions for a database file and read/write/execute permissions for the directory where the database file is stored.
Note 2 (only for SQLite 3 databases). The webserver PDO_SQLite library must be compatible (not earlier in the most cases) with the library the database was created with. If they are not compatible, you will get an error message "Could not retrieve table list from _database_name_ ... " on getting a table list at the connection script. If you've got the message, check the PDO_SQLite library version using, for example, the phpinfo() function, download a compatible library from the SQLite official website, get an SQL dump of the database and create a new one from the dump file with this library.