Hi! SQL Maestro Group announces the release of SQLite Maestro 10.5, a complete Windows GUI solution for SQLite database management. The new version is immediately available at
http://www.sqlmaestro.com/products/sqlite/maestro/ New features ================= 1. This release has been successfully tested with all the latest SQLite versions as well as with 64-bit operating systems including Windows 7 x64. The latest available library (3.6.23) is now included into the installation package. 2. Support for native foreign keys has been added (SQLite 3.6.19 and higher). To enable/disable this feature, use the corresponding option within the Create Database Profiles or Edit Database Profile window. This option also affects the automatic creation of referential integrity triggers: they are NOT created if it is turned ON and vice versa. 3. Table Editor: a possibility of importing data from Clipboard has been implemented. It is supposed that columns within the data block are separated by the tabulation symbol, records are separated by newlines and the first line of the data block contains column headers. 4. The Update Existing Records option has been added to the Data Import wizard. If this option is turned ON, the records will be either updated or inserted. 5. Data Analysis tool features the following things: 5.1. Starting with this version it is possible to use a wide spectrum of aggregate functions such as maximum, minimum, average value, etc. for subtotals (the only available function for the previous versions was sum of values). 5.2. A possibility of sorting data by summary columns has been added. This means, for example, the product you'll see first is not the one which starts with an A or Z, but rather the one that has the most or least sales. 5.3. You can also specify the number of top rows that are displayed to view, for example, only a specific number of best-selling or worst-selling products for each year, month, customer, etc. This will help you to concentrate on only the most important information and avoid being overload with a lot of superfluous data. 6. The Script Runner window can now be invoked directly from the Tools menu. Also the productivity of this tool has been significantly improved. 7. Data Grid: the "Clone current record" command has been added to the popup menu. Use it to add a new record which is substantially similar to an existing one. 8. BLOB editor: starting with this version it is possible to select a BLOB column to edit directly within the editor window. 9. The "Case Insensitive" option has been added to data grid filter settings (ON by default). 10. Some other minor improvements and corrections. Full press-release (with explaining screenshots) is available at: http://www.sqlmaestro.com/news/company/sqlite_maestro_10_5_released/ Background information: ------------------------ SQL Maestro Group is engaged in developing complete database admin and management tools for MySQL, Oracle, MS SQL Server, PostgreSQL, SQLite, DB2, Firebird, SQL Anywhere and MaxDB providing the highest performance, scalability and reliability to meet the requirements of today's database applications. Sincerely yours, The SQL Maestro Group Team http://www.sqlmaestro.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users