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

Subscribe to our news:
Partners
Testimonials
David Lantz: "Thank you, this is by far the simplest, and most friendly utility for building db record system I have ever used. I wish I could get my systems guys at the office to purchase this for our company would be so very helpful and speed up a lot of work. I for one have used it for everything from a simple inventory record of my house, to a members record for my church just little pet projects and a test bed to test my own db builds and theories before having to hand code at the office..... it is a lot of fun to work with".
Marco De Luca: "I can handle now both version of SQLite Databases, 2.x and 3.x. Your SQLite PHP Generator is among the best tools I have seen".

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