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

Subscribe to our news:
Partners
Testimonials
Kym Harper : "Beautifully presented tools (and web site) and great service. I will be sending links to many other individuals who should be interested. Wishing you every continued success and thank you again".
Jonathan Oakes: "This is a lovely application. It's easy to hook into my own bespoke applications. It's very powerful, yet really quite simple to use. Thanks for this".

More

Add your opinion

Customers
SQL Maestro Group / News / All company 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