SQL Maestro Group / Products / SQLite / News / First public release of SQLite Maestro

First public release of SQLite Maestro

May 18, 2006

SQLite Maestro is a powerful solution for the SQLite server administration and development. It allows you to create, edit, copy, extract and drop all the database objects such as tables, views, etc., build queries visually, execute queries and SQL scripts, view and edit data including BLOBs, represent data as diagrams, export and import data to/from most popular file formats, and use a lot of other tools designed for the easiest and most efficient work with SQLite Server.

Our product versions are formalized according to the release date: the first figure of the product version stands for the year of release; the second figure of the version is meant to indicate the month of the current version release. Hence, the present version is 6.5. For more information apply to the corresponding news item.

While developing this new software product we tried to include the usable features available in the existing products and to provide it with unique functionality. Please consider the short list of SQLite Maestro 6.5 features below:

support for all SQLite server versions from 2.8 to 3.x.x provided;
easy database management: the conception of database profiles gives you an opportunity to connect to databases in one touch and work with the selected databases only. Of course, it is also possible to create or drop a database;
particular database object management: the application includes a number of convenient wizards and editors; database explorer allows performing all necessary operations upon databases and their objects (creating new database objects, editing existing ones as well as duplicating and renaming objects);
user-friendly interface: easy-to-use GUI provided by SQLite Maestro will make your SQLite database management and administration easy and efficient; data can be viewed either as tables or as summary cards; Object Manager and Object Explorer permits you to fulfill complex data manipulation tasks irrespective of your personal level of competence in this or that server feature;
building and executing queries: SQLite Maestro provides 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 and so on;
powerful BLOB viewer/editor: opportunity to view and edit the content of the BLOB fields in various representations such as hexadecimal dump, plain text, graphical image or HTML page; graphical representation of BLOB data supports the following image formats: BMP, Windows metafile, JPEG, GIF and PNG;
data export module: exports data from SQLite Server tables and queries to files of the 14 most popular formats including MS Excel, MS Access, MS Word, HTML, XML, PDF;
data import module: imports data to SQLite Server tables from files of the following formats: MS Excel, MS Access, XML, DBF, TXT and CSV.

The list of useful features implemented in the offered software can be continued. SQLite Maestro allows you, for example, to create a new table in a few mouse clicks, to get SQL dump of your metadata and data (even without knowing the syntax), to get a high-quality printable report for your database, to execute any SQL script, to copy a table from one database to another by drag-n-drop operations or by pressing Ctrl+C/Ctrl+V hot key combinations and a lot of other features.

We hope that you will enjoy working with your SQLite server with our new software!

Related links:

Back to news archive