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

Subscribe to our news:
Partners
Testimonials
Ron D.: "I'm still very happy with SQLite Maestro and Data Wizard; makes my HTPC database much easier to manage".
Svetlio Mitev: "I am really sure that you guys can make the best PHP code generators to be found worldwide".

More

Add your opinion

Customers
SQL Maestro Group / Products / SQLite / News / SQLite Maestro 21.5 released

SQLite Maestro 21.5 released

May 5, 2021

Prev Next
SQLite Maestro

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

New feature highlights:

  • SQLite Maestro has been successfully tested with the recent SQLite versions. The latest available library (3.35.5) is now included into the installation package.
  • Added new database encryption algorithms. From now you can encrypt your database using the following encryption algorithms: ChaCha20, AES128, AES256, SQLCipher and RC4 (thanks to SQLite3 Multiple Ciphers project).
    Create database wizard: selecting encryption algorithmPicture 1. Create database wizard: selecting encryption algorithm
    The "Manage database encryption" window has been updated. Now it is possible to specify the encryption algorithm for a database.
    Manage database encryption commandPicture 2. Manage database encryption command Manage database encryption windowPicture 3. Manage database encryption window
    Note: In the previous versions of the software the AES128 encryption algorithm was used to encrypt databases.
  • Support for generated columns has been added (SQLite 3.31). Values of such columns are automatically computed based on a predefined expression. Both stored and virtual columns are supported.

    To create a generated column, just provide the generation expression in the Formula edit box.

    Managing generated columnsPicture 4. Managing generated columns
    In Data Grids and Data Input Forms generated columns are marked by a green calculator.
    Generated columns in the Data GridsPicture 5. Generated columns in data grids
  • Support for renaming (SQLite 3.25) and dropping (SQLite 3.35) columns using ALTER TABLE statement has been implemented. Previously, to implement such operations it was required to create a new table with the updated structure, copy data from the original table to the new table, drop the original table and then rename the new table to the name of the original table. Now, it is done with a single command.
    Renaming columnPicture 6. Renaming column Dropping columnPicture 7. Dropping column
  • Starting with this version TRUE and FALSE default values are recognized in a data grid. TRUE and FALSE constants has been added also to the list of predefined default values of boolean fields.
    Predefined default values for boolean fieldsPicture 8. Predefined default values for boolean fields
  • The Statistics tab has been added to the Edit Database Profile dialog. Here you can find such information as profile creation time, total number of connections, last connection time, and so on.
    Database Profile StatisticsPicture 9. Database Profile Statistics

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

Related links

Prev Next
Back to news archive