Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
Mario Figueiredo: "I can safely forget all I know about SQL when using SQLite Maestro. It is that easy and intuitive to use. It is also nicely drawn with an easy and appealing interface that makes the sometimes boring tasks of database maintenance and administration more endurable.
The decision to support the non-commercial use of your software with a lower price is absolutely worth mentioning. For that alone, I thank you. For everything else, I say keep up the good work".
Ron D.: "I'm still very happy with SQLite Maestro and Data Wizard; makes my HTPC database much easier to manage".

More

Add your opinion

SQL Maestro Group / Products / SQLite / News / SQLite Maestro 16.11 released

SQLite Maestro 16.11 released

Nov 14, 2016

Prev Next
SQLite Maestro

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

New feature highlights:

  • SQLite Maestro has been successfully tested with the recent SQLite versions. The latest available library (3.15) is now included into the installation package (thanks to the wxSQLite3 team).
  • Support for the FTS5 extension has been implemented. FTS5 currently provides the best possible support for full-text search operations and includes various fixes and solutions for problems that could not be fixed in FTS4 without sacrificing backwards compatibility.
    FTS5 supportPicture 1. FTS5 support
  • Support for indexes on expressions has been added. Such indexes are useful to obtain fast access to tables based on the results of computations.
    Indexes on expressionsPicture 2. Indexes on expressions
  • Data Import features:
    • Starting from this version it is possible to import empty values as empty strings (while previous versions always imported such values as NULLs).
      Data Import: working with empty valuesPicture 3. Data Import: working with empty values
    • Default Data Import settings can now be set up in the Program Options dialog.
      Data Import defaultsPicture 4. Data Import defaults
  • Data Export: now it becomes possible to add current timestamp to the output file name.
    Data Export: adding current timestamp to output file namePicture 5. Data Export: adding current timestamp to output file name
  • From now on it becomes possible to execute custom SQL scripts in all database connections established by the software.
    Custom SQL scripts settingsPicture 6. Custom SQL scripts settings
  • Support for Adobe Reader DC has been added to BLOB Editor. Also the editor window now saves its size and position between times it is opened (for each table).
    BLOB EditorPicture 7. BLOB Editor
  • Support for a number of new encryption algorithms has been added to Data Grid. Now it is possible to encrypt the value of a text column, for example, by SHA512 or Haval224 algorithm with a couple of mouse clicks.
    Data encryptionPicture 8. Data encryption
  • Data Input Form: controls containing values of primary and foreign key columns are now marked with the 'gold key' and 'silver key' images accordingly. Controls containing values of required (NOT NULL) columns are marked with a red asterisk.
    Data Input Form: marking important controlsPicture 9. Data Input Form: marking important controls
  • Data Grid: To reset all grid settings to defaults, open the Data tab when holding the Ctrl key.

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


Related links:

SQLite Maestro home page
Download SQLite Maestro
Get SQLite Maestro Tour
Purchase your license of SQLite Maestro today!
Prev Next