SQLite Maestro 8.5 released

May 19, 2008

SQL Maestro Group is happy to announce the release of SQLite Maestro 8.5, 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:

• The main feature of the new version is a possibility of connecting to remote SQLite databases via HTTP tunneling. The technology works as follows:
  
  
  • 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.
    
    
  • Test the script in your web-browser (optionally).
    
    
  • Enter the script URL in the Create Profiles Wizard, Create Database Wizard, or Edit Database Profile dialog. Of course you should select the "I have to use HTTP tunneling" option in any of these windows.
  
  
• Foreign keys are now extracted from databases and considered in Create View Wizard and Database Designer. As SQLite does not enforce foreign key constraints, the possibility of generation referential integrity triggers has been implemented.
  
  
• Starting with this version it is possible to reorder columns for existing tables.
  
  
• The Quick Connect mode has been implemented. Use it to skip metadata refreshing when connecting to a database (for example, to execute a query or SQL script).
  
  
• Support for TIME and DATETIME data types has been added to Field Editor.
  
  

• A French localization is now included into the installation package.
  
  
• This version of our software is fully compatible with large fonts (120 DPI).
  
  
• Database Explorer: the Data management group has been added to table and view nodes popup menus. Use this group items to run Data Export, Data Import, and Get SQL Dump wizards for the selected table or view without openning its editor. The Empty Table command has been moved to this group too.
  
  
• Extract database wizard: common database properties and program info are now included into the result scripts.
  
  
• SQL Editor: a popup menu has been added to each query tab. Using this menu you can create a new query, close existing one, save the query to profile, etc even if editor's navigation bar is closed.
  
  
• SQL Script Editor: Script Explorer has been significantly improved. Now it works much faster and more exactly.
  
  
• SQL Script Editor settings: the "Use script runner for large scripts" option has been added.
  
  
• Create Database Wizard, Create Profiles Wizard, and object creation wizards become resizable.
  
  
• Data import wizard: the interface for adding and editing of replacements has been slightly improved.
  
  
• Database Designer settings: the "Show hints" options has been added. Also it is now possible to select the default graphic file format to export diagrams as images.
  
  
• The F11 key is now used to show/hide the Explorer tree.
  
  
• Data grid options: it is now possible to restrict maximum column width.
  
  

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