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

Subscribe to our news:
Partners
Testimonials
Ephraim Stevens : "I just wanted to re-iterate what a wonderful job your developers have done and what a wonderful product SQLite Maestro is. There are so many great things to say about it that I won't go into here. It saves an end user a lot of time on repetitive tasks. Keep up the excellent work over there".
Renaud Lepage: "I was searching for a powerful server management as well as data management application, that could also have the ability to use stored procedures (MySQL5). I was using many separate apps. And then I stumbled upon this application. It just got better. With ease-of-use, powerful management, a very good level of customization, great MySQL server management and the very lushed graphical interface, MySQL Maestro is a product to consider seriously. I chose MySQL and this, to SQL Server 2000 and the MMC-integrated server management, for use in a programming course. I'm telling you, MySQL Maestro is a very powerful tool. Try it, you won't regret it".

More

Add your opinion

SQL Maestro Group / 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