SQLite Maestro FAQ

SQLite Maestro is a powerful Windows database management solution for SQLite administration and development. The software provides you with graphical user interface (GUI) which allows you to make database operations easy and fast.

With SQLite Maestro you can easily create, edit and drop database objects, build queries as visual diagrams, execute queries and SQL scripts, manage data including BLOBs, manage SQLite security features, and use a lot of other tools designed for the easiest and most efficient work with SQLite.

Yes, of course. The latest fully functional trial version is always available for downloading.

Yes, you can. Feel free to choose a non-commercial license. Exact prices can be obtained on the purchase page.

Yes, certainly. You can get a volume discount purchasing 3 and more licenses for the same product as well as a cross-selling discount purchasing multiple different products at a time. Also you can get a great discount purchasing a bundle that includes SQLite Maestro.

You are to discuss reseller's policy with our sales department.

You may choose a non-commercial license if you use the software for non-commercial purposes in non-business, non-commercial environment. You should purchase a business license to use the software in a corporate, government, or business environment.

Single license means that a copy of the software is allowed to be used only on a single computer and only by a single user at a time. If you wish to use the software for more than one user, you will need a separate license for each individual user (click the "Order now" button to see volume discounts). Site license means that the software is allowed to be used without limitation on count of installations and users within one organization.

All our products and bundles are shipped with 12 months of free upgrades (minor and major ones) or with 36 months of free upgrades for a quite small additional fee.

A single license can be installed on a single computer. However, we offer a special allowance which authorizes you to deploy SQLite Maestro on both desktop computer and portable computer, laptop, or other mobile computer with a single license, as long as it is not being used simultaneously.

Product versions are formalized according to the date of release. For more information, please refer to the appropriate news article.

Yes, it is possible. Run installation_package.exe with /SILENT or /VERYSILENT command line parameter. When /SILENT is used the wizard and the background window are not displayed but the installation progress window is. When /VERYSILENT is used this installation progress window is not displayed at all.

SQLite Maestro can be used with SQLite server versions up to 3.x.x.

Yes, it does. SQLite Maestro supports the majority of features implemented in the latest versions of SQLite.

Yes. Most of operators implemented in SQLite latest versions are supported by SQLite Maestro.

Many people like SQLite server because it is small and fast. Users also find that SQLite is very reliable. Reliability is a consequence of simplicity. Our product is meant to make the work with the server even simpler and more efficient due to graphical user interface and a number of easy-to-use tools implemented.

The necessity of importing Raw data from CSV files is a common issue. Possible uses include website log analysis, sports statistics analysis, compilation of programming metrics, and analysis of experimental results. If you are not experienced enough to employ the command-line dataset analysis tool, you may try SQLite Maestro for the same purpose. Easy-to-use Import Data Wizard allows you to import data to a table from MS Excel, MS Access, DBF, XML, TXT or CSV files.

Theoretically, SQLite server admits databases up to 2 terabytes in size, and SQLite Maestro does not limit this value at all. But if your organization is going to work with large databases, it is more preferable for you to try another database engine. You can find the full list of administration and development tools for other servers on our Product page.

SQLite Maestro provides two powerful tools which allow you either to edit query text directly with syntax highlighting and code completion or to build a query diagram visually selecting tables and fields, setting links between tables, etc.

Generate Database Report Wizard allows you to print definitions of the database objects. To run the wizard, select the Tools | Generate Database Report main menu item. The wizard helps you to print all the database object or specify the Categories for printing according to the selected object type. The report does not include database data.

The Editor area is provided for working with the text of the query. For your convenience code completion is enabled. You can activate the completion list by pressing the Ctrl+Space key combination.

The reason is that you are trying to edit SQL definition within the SQL tab of the object editor. Bear in mind that this text is read-only. If you want to modify the object definition, use SQL Editor or SQL Script Editor tools.

SQL Editor provides you with an ability to execute multiple queries separated by a statement delimiter from the same editor tab. Queries are executed in a separate thread, so all SQLite Maestro features remain available during the execution.