Customers
SQLite Maestro online Help
Prev  |
Return to chapter overview | Next  |
What's new
11/10/2008 - SQLite Maestro 8.11 released
Server management extensions:
| • | Support for transparent database encryption has been implemented. You can use either SQLite Encryption Extension by Hwaci (if you have it) or a free wxSQLite3 library, which is already included into the SQLite Maestro installation package. The libraries are compatible with each other by API calls, but a database encrypted using one library cannot be read by another one. |
| • | Remote database management has been significantly updated. Now it is possible to connect to remote SQLite 3 databases as well as store the connection script in a password protected directory. |
Interface improvements:
| • | Data grid features the following things: |
| o | Starting with this version it is possible to use the lookup editor for a column, which is linked by a foreign key with a (single) column from another table. The editor displays the contents of parent table’s columns within the drop-down window. |
| o | A possibility of displaying data in the master-detail form has been incorporated into the Table Editor (multiple detail pages can be displayed for a single master row). Use the Show/Hide details link at the editor’s navigation bar to activate/deactivate this view mode. |
| o | Filtering, grouping, and sorting features become available for text columns. |
| • | Data Import Wizard: now it is possible to truncate the table before importing. |
| • | Get SQL Dump Wizard and Extract Database Wizard now can generate multi-row INSERT statements. Also both the wizards have been redesigned to increase the usability. |
| • | Data Export, Data Import, and Get SQL Dump wizards now store their size and position. |
5/19/2008 - SQLite Maestro 8.5 released
Server management extensions:
| • | The main feature of the new version is a possibility of connecting to remote SQLite databases via HTTP tunneling. The technology works as follows: |
| o | 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. |
| o | Test the script in your web-browser (optionally). |
| o | 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. |
Interface improvements:
| • | 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. |
12/10/2007 - SQLite Maestro 7.12 released
Server management extensions:
| • | 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. |
Interface improvements:
| • | 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. |
| o | Handy tools of Designer allow you to create new and edit existing tables and logical relations; |
| o | The Create Note, Create Text, and Create Link to Note tools allow you to decorate the diagrams; |
| o | Now you can quickly and easily print your database structure with a lot of options including header and footer, paper size and orientation, etc; |
| o | A rich set of options and settings give you a way to see your database in your own look and feel style. |
| o | 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: |
| o | 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. |
| o | 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. |
| o | 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. |
09/20/2007 - SQLite Maestro 7.9 released
Server management extensions:
| • | Since this version it is possible to cancel a long running query execution (SQLite 3.x.x) and data fetching (all versions of SQLite). |
| • | SQLite Maestro does not lock connected databases anymore i.e. it is possible to connect to such databases using another software product e.g. the second instance of SQLite Maestro. |
| • | The contents of BLOB fields containing graphics is now saved correctly. |
Interface improvements:
| • | The SQL Formatter for DML statements (SQL Formatter for DML statements (SELECT, INSERT, UPDATE and DELETE) is implemented. It can be invoked through the Format SQL link on the SQL Editor's navigation bar (Ctrl+Alt+D shortcut). |
| • | BLOB Viewer: it is now possible to save all BLOBs from a table to a given directory. |
| • | Now our software displays execution time for lengthy operations. |
| • | Data Import Wizard: the speed of loading of Excel files was significantly increased. |
07/03/2007 - SQLite Maestro 7.7 released
Server management extensions:
| • | The most important thing added in this version of SQLite Maestro is support of UTF-8 data. For databases in UTF-8 encoding it is necessary to specify, which string fields are used to store Unicode data (available options are "Only nvarchar(xx) fields" and "All the string fields"). For databases in UTF-16 encoding no such actions required. |
| • | Create database wizard: now it is possible to specify the encoding (UTF-8 or UTF-16 for the new database). |
Interface improvements:
| • | It is now possible to execute SQL scripts after connect and before disconnect to/from a database. |
| • | Some new features are incorporated into SQL Editor and SQL Script Editor. Now it is possible: |
| o | comment/uncomment selected text (Shift+Ctrl+. / Shift+Ctrl+, shortcuts respectively). If no text is selected, the whole line will be commented. By the way, it is not necessary to select commented text to uncomment it, just press Shift+Ctrl+, having the cursor inside the commented text. Both kinds of comments (single-line and multi-line) are supported; |
| o | convert selected text to different cases (lower, UPPER, and NameCase); |
| o | export the contents of the editor to RTF and HTML formats (to file or to clipboard); |
| o | print/preview the contents of the editor. |
| • | The Copy to SQL Script Editor command is added to all object editors (available in the Navigation Bar on the SQL tab). Use it for quick copying object’s SQL definition (DDL) to the SQL Script Editor for future modifications; |
| • | Data grid: some advanced filtering abilities were implemented (see Main menu | Tools | Options | Data grid | Filter); |
| • | Explorer tree: the Browse command is added to lists' popup menus (runs the Object Browser tool). |
3/20/2007 - SQLite Maestro 7.3 released
Server management extensions:
| • | SQLite Maestro was successfully tested with the latest SQLite server versions up to 3.3.13. |
Interface improvements:
| • | SQL Editor: now SQLite Maestro can edit even very large SQL files. Also the speed of editor's work has been significantly improved; |
| • | SQL Editor: queries' tabs can now been displayed at the all sides of the editor (bottom, top, left or right); |
12/11/2006 - SQLite Maestro 6.12 released
Server management extensions:
| • | None in this version. |
Interface improvements:
| • | The tabbed interface is implemented in addition to classic MDI (see screenshot). You can choose your favorite UI in the Options dialog; |
| • | SQL Script Editor: if a user opens a file larger than 100K, SQLite Maestro will suggest him to execute the script file without opening it in the editor. Of course it is also possible to execute any script file using this way: just press the "Execute script from file" link on the Script Editor navigation bar and specify the filename; |
| • | Create Profiles Wizard: we've added an option for converting new object names to lower/upper case; |
| • | Data grid: the speed of data loading was significantly increased. |
11/17/2006 - SQLite Maestro 6.11 released
The new version of SQLite Maestro, a powerful Windows GUI solution for SQLite server administration and database development, has been released.
Please consider the list of all the new features implemented in SQLite Maestro 6.11:
Server management extensions:
| • | Current version was successfully tested with all the latest SQLite versions up to 3.3.8; |
| • | The Make primary key and Clear primary key commands are now accessible anywhere in the software (Table Editor, Explorer Tree, Object Browser, etc). |
Interface improvements:
| • | We have implemented the Data Analysis, a tool to represent your data as OLAP cubes; |
| • | The Table Editor interface is improved: now all the subitems i.e. fields, indexes, and triggers are displayed at the main editor tab. We found this layout more comfortable; |
| • | BLOB Viewer/ BLOB Editor: the text pane provides now several types of text highlighting (Plain text, HTML, JScript, CSS, PHP, XML, SQL, and SQLite DDL). Also it is possible to find and replace a text fragment of a BLOB column data; |
| • | It now available to refresh schema object list whenever an object depends on other objects e.g. refresh table list on view creation or foreign key creation/editing; |
| • | The Insert key is now a shortcut for creating a new database object from the Explorer tree. |
In addition to this, several bugs were fixed and some other minor improvements and corrections were made.
07/10/2006 - SQLite Maestro 6.7 released
The new version of SQLite Maestro, a powerful Windows GUI solution for SQLite server administration and database development, has been released.
Please consider the list of all the new features implemented in SQLite Maestro 6.7:
Server management extensions:
| • | added support Check constraints (SQLite 3.3); |
| • | improved Index Editor: implemented index sort ordering and index collating sequence (SQLite 3.3). |
Interface improvements:
| • | SQL Editor improvements: now you can execute each query in a separate thread in order to continue your work with the software while the query is executing. The Procedure Editor is also improved for the purpose of executing the routine asynchronously; |
| • | SQLite Maestro wizards windows are resizable now for more usability; |
| • | the server version can now be viewed from the tool tip of the database node; |
| • | added an ability to edit object properties directly from the explorer tree without opening the object editor; it helps you to make your work with your SQLite database objects faster; |
| • | added an ability to rename an object directly from the explorer tree without opening its editor; |
| • | added more key shortcuts: a new query can be created in SQL Editor through the Ctrl+N stortcut and deleted through the Ctrl+R shortcut. |
In addition to this, several bugs were fixed and some other minor improvements and corrections were made.
06/09/2006 - SQLite Maestro 6.6 released
The new version of SQLite Maestro, a powerful Windows GUI solution for SQLite server administration and database development, has been released.
Please consider the list of all the new features implemented in SQLite Maestro 6.6:
Server management extensions:
| • | not in this version. |
Interface improvements:
| • | We have implemented the Object Browser tool, which operates like Object Manager, but includes some additional features such as properties grouping, filtering, and sorting. For example it is easy to find all the tables, which have more than 10 fields or all the domains based on INTEGER type in a few mouse clicks. You can also open several objects' editors simultaneously as well as drop all the selected objects by a single operation; |
| • | All the system objects such as autoindexes now can be displayed in a different color (purple by default). The color can be set in the Options window (the Explorer tab); |
| • | The connected databases are now displayed in bold everywhere (object editors, Object Manager, Object Browser etc); |
| • | The Describe Object command is now included into the popup menu of each object as well as into navigation bars. Use it to specify the object's comment without opening its editor; |
| • | The F8 and Shift+F8 key shortcuts now can be used to open/execute queries in the SQL Editor. F9 and Shift+F9 work too. |
In addition to this, several bugs were fixed and some other minor improvements and corrections were made.
05/18/2006 - First public release of SQLite Maestro
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 date when they are released: 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 the 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 the 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; |
| • | powerfull database object management: the application includes a number of handy wizards and editors, database explorer allowing you to perform 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 allow 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: exporting 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: importing 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.
To summarize all the features available in SQLite Maestro, we hope that you will enjoy working with your SQLite server!
| Prev |
Return to chapter overview | Next |
