Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
Ephraim Stevens : "I just wanted to re-iterate what a wonderful job your developers have done and what a wonderful product SQLite Maestro is. There are so many great things to say about it that I won't go into here. It saves an end user a lot of time on repetitive tasks. Keep up the excellent work over there".
Mario Figueiredo: "I can safely forget all I know about SQL when using SQLite Maestro. It is that easy and intuitive to use. It is also nicely drawn with an easy and appealing interface that makes the sometimes boring tasks of database maintenance and administration more endurable.
The decision to support the non-commercial use of your software with a lower price is absolutely worth mentioning. For that alone, I thank you. For everything else, I say keep up the good work".

More

Add your opinion

Customers
Download Buy

SQLite Maestro online Help

Prev Return to chapter overview Next

Connection parameters

 

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 database, you should provide only a full database file name (e.g. C:\Data\SQLite\MyDatabase.db3) and a password (only for encrypted databases).

 

To read and write encrypted databases, SQLite Maestro uses the free wxSQLite3 library that is included into the installation package. This means it can operate only with encrypted databases created by itself or by any other tool that uses the same library. Unfortunately, our software cannot connect to databases encrypted by any other library because different SQLite security extensions use different algorithms, which are not compatible with each other.

 

SQLite engine does not support network connections, however SQLite Maestro allows you 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.

 

 More about connection via HTTP tunnel

 

To connect to a remote SQLite database using an HTTP tunnel, you need to:

 

1.Upload the connection PHP script to your website. The scripts are named sqlite_tunnel.php and sqlite3_tunnel.php for SQLite databases versions 2 and 3 accordingly and can be found under the installation folder, usually C:\Program Files\SQL Maestro Group\SQLite Maestro.

 

2.Turn ON the I have to use HTTP tunneling checkbox.

 

3.Enter the connection PHP script URL, e.g. www.yoursite.com/files/sqlite_tunnel.php. You can test the connection before the profile is created. Just use Test script using default browser to open connection script in your browser, enter all the required connection parameters and use the Test connection button.

 

 

4.In case using of a proxy server use Configure tunnelling options to open the HTTP tunnelling options window and specify your proxy server connection parameters and HTTP authentication.

 

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.

 



Prev Return to chapter overview Next