SQLite Maestro 12.11 released

Nov 26, 2012

SQL Maestro Group is happy to announce the release of SQLite Maestro 12.11, a powerful Windows GUI solution for SQLite server administration and database development. Please consider the list of new features implemented in this version since the last official release:

Server management extensions:

• SQLite Maestro has been successfully tested with the recent SQLite versions. The latest available library (3.7.14.1) is now included into the installation package (special thanks to the wxSQLite3 team).
• Support for some advanced FTS4 options has been added. Also all full-text search tables are now marked with a special image in the Explorer tree to improve the usability.

  Picture 1. Support for FTS4 options

• Support for the XML data type has been implemented. The values of this data type now can be inserted/updated in a modal editor with the XML syntax highlighting.
• Support for binary stored GUIDs has been added. To instruct SQLite Maestro how to interpret values of the GUID data type, select the appropriate option in the Edit Database Profile dialog.

  Picture 2. Support for binary stored GUIDs

• Starting from this version the Get SQL Dump tool by default generates multi-insert statements for SQLite 3.7.11 and higher.
• All the missing SQLite functions and pragmas have been added to the Code Completion list that can be invoked by pressing Ctrl+Space in any editor.
• The .sqlite file extension has been added to the Select Database dialog.

Interface improvements:

• This version comes with Report Designer, a simple-to-use and elegant tool to prepare data for reading, viewing, and printing in a polished look.

  Picture 3. Report Designer

  Use this tool to create database reports using drag-and-drop functionality and rich formatting options. To invoke the window, use the Main Menu | Tools | Report Designer menu item.
• The Start Page has been redesigned in order to provide quick access to recently connected database profiles and display the latest company news.
• SQL Editor features:
  • Now on executing several statements from a single editor tab (did you know about such a possibility?), the corresponding result tab is marked with an appropriate image.

    Picture 4. SQL Editor result tabs images

  • Starting from this version you can copy the selected text from any editor to Clipboard as a ready-to-use string written in one of the following programming languages: C#, C++, Delphi (Object Pascal), and Java. This feature is accessible in the Export section of the editor area popup menu.

    Picture 5. SQL Editor: copy selected text as a string written in programming language

• Database Explorer: now it is possible to assign a custom color to a certain database profile. For example, you can mark development and production databases in different colors in order to prevent casual metadata or data changes in the production. The desired color can be selected at the Options tab in the Edit Database Profile dialog.

  Picture 6. Colored profiles in the explorer tree

• Check editor: an ability of editing check condition in a separate window has been added.
• Hints for foreign key columns now include the name of the parent table.

  Picture 7. Foreign key column hint

• Drag-n-drop from Windows Explorer to SQL Editor and SQL Script Editor has been added. Now to open a file in one of these editors, just drag it at Windows Explorer and drop at the editor area.
• The performance of SQL Script Editor has been significantly increased especially on large script editing. In addition to this the name of the file loaded to the editor area is now displayed at the right bottom corner of the window.
• Script Runner has been slightly changed in appearance and performance:
  • Now the name of the database the script to be run on is displayed at the top of the window, the name of the script file may be quoted, and the script files in the UTF-8 encoding may optionally start with a byte order mark.
  • Starting with this version it's possible to execute archived scripts directly from .zip files. The tool unpacks zip archives to temporary files by itself for further executing.
• Data Grid features:
  • Now it is possible to display images directly in the grid. To enable/disable this view mode or change the image fitting, use the Manage inline images item of the column popup menu.

    Picture 8. Data Grid: inline images

  • Multi-column lookup editors become available. Such editors modify values of several columns in the record simultaneously in order to guarantee referential integrity.

    Picture 9. Multi-column lookup editor

  • Data Input Form has been significantly improved. Now it simplifies the input of data with lookup menus for columns linked with foreign keys and a calculator for DECIMAL columns.
  • Now the headers of primary and foreign key columns are marked with the 'gold key' and 'silver key' images accordingly. The existence of any column marked with a gold key in the dataset means that you can modify/delete the records of this dataset without risk of updating/deleting several records at a time.

    Picture 10. Key columns in the data grid

• Data Import features:
  • From now on it is possible to import data from CSV files that contain multi-line strings.
  • A possibility of setting the correspondence between source and target columns by column name has been implemented (previous versions allow you to set such a correspondence only by column index).

    Picture 11. Setting column correspondence

• Data Export: now it is possible to specify decimal and thousand separators for the generated files (when applicable).
• The progress windows are redesigned in the modern style and become more informative.

  Picture 12. Progress window

In addition to this, several bugs have been fixed and some other minor improvements and corrections have been made.

Related links:

Back to news archive