Subscribe to our news:

 Partners
 Testimonials
Johnattan Badden, Manager: "The software is easy to work with and most importantly, report management is extremely easy, even for a novice like me! I am able to create and edit my databases with a few clicks and easily maintain them afterwards. I highly recommend SQLite Maestro to educational institutions: it's easy and flexible, it is exactly what can be good for using in schools and colleges".
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".
More
Add your opinion
 Customers
|
SQLite Maestro online Help
Referential integrity trigger generator
SQLite Maestro allows you to enforce foreign key constraints using referential integrity triggers. To generate such triggers to a foreign key, use the Generate referential integrity triggers link of the foreign key node' popup menu at the Explorer tree. This command is provided to generate 4 triggers: 2 triggers will accomplish the referential integrity in the parent table (on update and on delete) and 2 triggers - on the child one (on insert and on update). Use the opened window to specify the triggers names and set foreign key Cascade options.

|
 Company news 
May 5, 2021
New version introduces new database encryption algorithms, support for generated columns, support for renaming and dropping columns using ALTER TABLE statement, and some other enhancements.
Nov 14, 2016
New version introduces support for FTS5 extension and expression-based indexes, new encryption algorithms in data grids, updated data export and data import tools, and some other useful things.
Jan 12, 2015
New version comes with support of user authentication and management, read-only database connections, colored tabs, and some other new features.
 Feature of the day
SQLite Maestro provides an ability to export your data to any of 14 available data formats.
SQLite Maestro provides you with Object Browser for sorting, filtering and grouping of database objects.
|
|