What's new in SQLite Sorcerer 1.9
May 30, 2014
- Improvements / changes:
- Issue #11: File Open dialog needs ‘All Files (*.*) mask
New in SQLite Sorcerer 1.5.3 (Jan 26, 2010)
- Query Panel: you can use SQL statements snippets to accelerate the query definition.
- This is a quick and partial implementation of the feature at the moment.
- The plan is to integrate the ability to define your own snippets from an interface.
- Improvements / changes:
- A "IF NOT EXISTS" has been added in the SQL code of each CREATE statements.
- This aims to help the reuse of the code.
- Fixed bugs:
- It was possible to get SQL errors because of additional spaces or lines in the syntax. The SQL is now cleaned before execution.
New in SQLite Sorcerer 1.3 (Jun 23, 2009)
- New:
- Some UI modifications and performance improvements.
- Export is now possible using a comma as separator.
- It is now possible to import data from a CSV or TXT file.
- You can now filter data.
- use match case or fnid null/empty value.
- you can also use regular expression in your filter.
- the filter can be applied to all the tables, the displayed table or just a column.
- Improvements:
- There is no more context menu in the Schema tree for the root and the folders.
- The context menu is only available for items as tables, views, triggers and indices.
- Format of exported dates has been improved.
- Fixed bugs:
- When you selected a view, the sql was always shown. Now it can be the data table if you were on a the data table of a table.
- In the Query Panel, the cursor is now positionned at the end of the added field/table and not at the end of the SQL.
New in SQLite Sorcerer 1.21.2 (May 27, 2009)
- New:
- The root of the tree now displays the name of the database instead of "main"
- Can now see and open .sqlite files
- Encryption and rencryption is available
- You can use either a password or a hashed key to create and open your database
- A list of recently used databases is available beside the cauldron :
- Open by drag n’ drop or double click
- Somme UI modifications as
- added labels on buttons, as icons only were maybe not well understood
- added a clearer button to show differences when available
- a minimum size of the window has been defined
- added a button to export data (previously accessible only by right-click
- added some help icons
- Fixed bugs:
- Fixed a bug that kept the "Reset conflict clause" button disabled when the field form was open
- Fixed the bug that lost the cursor in the SQL area of the Query Panel while adding objects by double-click
- Fixed a bug that prevented the dropped item to be removed from the schema