EN
DE

Choose your SQL server:

Customers

Become a customer

Testimonials

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

Ron D.:
"I'm still very happy with SQLite Maestro and Data Wizard; makes my HTPC database much easier to manage".

Johnattan Badden, Manager:
"The software is easy to work with and most importantly, report management is extremely easy, even for a novice like me! I am able to create and edit my databases with a few clicks and easily maintain them afterwards. I highly recommend SQLite Maestro to educational institutions: it's easy and flexible, it is exactly what can be good for using in schools and colleges".

Jacob Lyohne, Director of Development:
"Regarding implementation, it is pretty self-explanatory and the SQLite Maestro manual is helpful for review and reference. We also found the on-line documentation useful and the software support staff readily available to answer our questions. Reports are very easy and quick to run and can be broken down into any number of statistical combinations".

Add your opinion

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

Download Buy

SQLite Maestro online Help

Return to chapter overview

Setting connection properties

The first wizard step allows you to specify the database connection properties that will be used on further connections.

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.

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

Return to chapter overview

Company news

Nov 12, 2008

SQLite Maestro 8.11 released

New version provides support for transparent database encryption, remote database management extensions and some interface improvements.

May 19, 2008

SQLite Maestro 8.5 released

Remote database management via HTTP tunneling, foreign keys support, column reordering and a lot of interface improvements.

Dec 10, 2007

SQLite Maestro 7.12 released

The main feature of this version is Database Designer, a tool to represent your database tables as ER diagrams.

Feature of the day

BLOB Viewer

SQLite Maestro allows you to view and edit BLOB data in several different representations.

Support for UTF-8 data

SQLite Maestro supports Unocode/UTF-8 data in grids.