[ANN] SQLiteAdmin Version 1.3.4 Released

Peter Haworth pete at lcsql.com
Mon Dec 24 14:24:35 EST 2012


Folks,
I'm happy to announce the release of Version 1.3.4 of SQLiteAdmin,
available for download here <http://www.lcsql.com/sqliteadmin.html>.  The
release is free to all current users of SQLiteAdmin.

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.  Powerful 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.

Full details of these enhancements can be found in the User Guide and the
release notes<https://docs.google.com/document/d/1hqGISUPuuEHySsObs-taIds0a_pvQWoPNcUcOdeRWaY/edit#heading=h.g8scyjy1ag8c>
.

Pete
lcSQL Software <http://www.lcsql.com>



More information about the use-livecode mailing list