SQL Maestro Group / Products / SQLite / SQLite Maestro / Documentation

SQLite Maestro online Help

Editing connection properties

The tab allows you to change connection properties of an existing database profile. Here you can change the database and edit the database alias, an optional name to display the database in the Explorer tree and in all the application tools.

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.).

SQLite Maestro allows you to connect to SQLite servers directly, or via HTTP tunnel.

•	Direct connection is the most preferable connection mode.

•	HTTP tunneling is a technique used in conditions of restricted network connectivity including firewalled networks, networks behind proxy servers, and NATs. It is slower way than direct one. It is recommended to use if direct connection is impossible.

To connect to a remote server using a PHP script, you need to:

1.	Upload the connection PHP script to your website. The script is named sqlite_tunnel.php and can be found under the installation folder, usually C:\Program Files\SQL Maestro Group\SQLite Maestro.

2.	Select the I have to use HTTP tunneling radio button.

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: You are actually connecting to your database through the PHP script on the server, so in most cases the host/server name is "localhost" unless the target server is not installed on the same server as the Web server.