SQLite Maestro 7.12 released

Dec 10, 2007

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

• SQLite Maestro has been successfully tested with the latest SQLite server versions. The latest available server library (3.5.3) is now included into the installation package.
  
  
• Support for attached databases has been implemented: now you can specify such databases in the Database Profile Editor to use their data in your SQL queries.
  
  
• Reindex and Vacuum commands have been added for tables and indexes.
  
  

• The main feature of the new version is the Graphical Database Designer - a case tool for managing your database in a few mouse clicks. This piece of our software is intended for creation of physical Entity Relationship Diagrams that represent tables in your SQLite databases.
  
  
  • Handy tools of Designer allow you to create new and edit existing tables and logical relations;
    
    
  • The Create Note, Create Text, and Create Link to Note tools allow you to decorate the diagrams;
    
    
  • Now you can quickly and easily print your database structure with a lot of options including header and footer, paper size and orientation, etc;
    
    
  • A rich set of options and settings give you a way to see your database in your own look and feel style.
    
    

  A diagram of your database can help you define operational aspects of your application logic that you might otherwise overlook. Also, a well-defined data diagram that accurately represents your tasks can be helpful in orienting employees to goals and operations.

• Database explorer: now it is possible to group database profiles according to your needs.
  
  
• The SQL Generator tool has been implemented. Use this feature to produce various SQL scripts (CREATE, DROP, SELECT, INSERT, etc) for the selected object. The result script can be saved to a file, copied to clipboard, and opened in SQL Editor or SQL Script Editor.
  
  
• Data Grid has been significantly updated:
  
  
  • The notification pane is now displayed after simple mode activation (filtering, grouping and sorting features are not supported in this mode). All the related settings can be customized in the Options dialog.
    
    
  • The Generate Query command has been added to the Table / View Editor. Use this command to copy current filter conditions to the SQL Editor window as an SQL query. It is also possible to copy filter condition to clipboard as WHERE clause using grid’s popup menu.
    
    
  • Now it is possible to encrypt the contents of the selected cell by the md5 algorithm (the corresponding item has been added to grid's popup menu).
    
    
• Object editors, SQL Editor, Database Designer, BLOB Viewer and other database-dependent windows: only connected databases are now displayed in the drop-down list.
  
  

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