[ANN] Version 1.3.4 of SQLiteAdmin Released

[phaworth]

I'm happy to announce the release of Version 1.3.4 of SQLiteAdmin, available for download at www.lcsql.com. The release is free to all current users of SQLiteAdmin and new licenses are available for $24.99.

SQLiteAdmin provides powerful database administration and data manipulation tools for SQLite databases. All standard SQLite commands are supported plus extended Data Definition functions not available in standard SQLite which allow you to modify your schema in any way while preserving the integrity of your data. Powerful Data manipulation features provide you with the ability to carry out ad-hoc INSERT, UPDATE, and DELETE operations. Flexible data filtering functions allow to display subsets of your data. Various utilities are available to check the integrity of your database, suggest possible schema changes for performance improvement, and export and import data in several formats

This release includes several minor bug fixes plus a couple of enhancements, both in the Browse View.

After displaying rows, right clicking on any column will display the minimum, maximum, average total and count of unique values.

When defining a new filter, you can include a runtime prompt instead of a fixed value for any column. This is particularly useful when creating a filter to be stored for later use allowing you provide a different value for a column each a filter is executed.

Two types of runtime prompts are available. One will simply prompt for a text value (with a default), and the other will prompt for a selection from an option menu. You can specify the contents of the option menu in terms of an SQL expression, and foreign key situations are automatically identified and handled correctly.


Pete
lcSQL Software