I'm pleased to announce the general availability of SQLiteAdmin, an SQLite database administration tool for Mac and Windows.
A 30-day demo of the application is available for download here<http://www.lcsql.com/products.html>. To mark the launch of SQLiteAdmin, I am making it available for $9.99 to any members of this list through May 16th. To take advantage of this offer, please send email to p...@lcsql.com <p...@lcsqlsoftware.com> and you will receive the purchase link by reply. Please make sure your email doesn't block messages from that address. SQLiteAdmin provides complete GUI access to all SQLite Data Definition Language functions. Convenience features include the ability to create multiple columns sharing the same properties in a table with a single mouse click, or to automatically create an index on the child column of a foreign key relationship. Extended Data Definition Functions provide the ability to add, delete, and modify any SQLite object and its properties. You can add, rename, and delete columns from existing tables and the changes will be reflected in all other schema objects such as indexes, triggers, and views. You can also add, modify or remove any table or column constraint. Extensive checking is done before any of these changes are made and all changes are done within the scope of a transaction which is rolled back if any errors occur. For complete security, you can request that SQLiteAdmin backs up your database before any Extended Data Definition Functions are executed A table browser tool is provided for data inquiry and maintenance purposes. Powerful filtering capabilities are available including the ability to choose which columns to display. You can define "virtual columns" to hold the results of any SQLite expression. Filter settings can be saved for future recall and execution. You can insert, duplicate, delete, and update (single or multiple) rows using SQLiteAdmin's fill-in-the-blanks approach. All or selected table rows can be exported to files with columns delimited by comma, tab, or any other character you choose, or as SQLite INSERT statements. External files in delimited format can be processed to insert data into a table and SQLiteAdmin handles embedded delimiter and carriage return characters in the column data without requiring them to be escaped. You can also process files containing INSERT or any other valid SQLite statements. Other tools include support for in-memory databases (including the ability to save them to disk), access and updating of all PRAGMA values from a list, access to tune up commands such as VACUUM, ANALYZE, and REINDEX, and an audit function that will suggest changes to your schema that may provide improved performance. In addition, you can manually enter and execute SQLite commands, including access to the sqlite3 "dot" commands, and single commands or sequences of commands can be saved for later recall and execution. I welcome any feedback, positive or negative, which might help me improve the product. Pete lcSQL Software <http://www.lcsql.com> _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
