A new version of SQLite Sorcerer has just been released.
This minor version embeds just 1 enhancement and 2 bug fixes. The performance improvement for the loading of CSV files is good, between x4 and x10 faster than in v1.8 and earlier. So I really hope that the users who needed to import large CSV files will be satisfied by this result and will be able to work more efficiently with SQLite Sorcerer.
Here is a great release for the SQLite Sorcerer. It brings lots of important changes including:
- Parameterized queries: type your query with some @param or :param. They will be recognized and associated to an existing table field. You can then select a value in a combox and execute your query for different values…
- Item transfer: open 2 databases and transfer tables (with or without data), views, triggers, indices by a simple drag and drop…
- Drag and drop actions are implemented in the schema tree: you can copy items, create a trigger or an index on a table by drag and dropping it on the correct folder.
- Cursors will help you determine what actions are possible or not…
- New options: include or not data during your copy/transfer actions, edit your parameters with a combobox or a simple text field
- The Query Panel can’t be detached any more, its is now more integrated with other views…
- Use the CTRL key while dragging an item to edit its SQL definition in the Query Panel.
- Access to the issue tracker (on BitBucket.org) from the About dialog box.
You can have a look on the complete release note in the Release notes section.
The SQLite Sorcerer, our dear Darry BotAIR, will soon get 2 new abilities: "parameterized queries" and "transfer" between databases (items as tables(+data), views… ).
Just a short post to announce to all SQLite Sorcerer’s users that I created a repository on Bitbucket.org for the application. The main goal for me is to improve my source code management practices, prepare the opening of the code (someday) and to allow you to report and track your issues or requests. As usual, I will do my best to solve them.
The issue tracker is public so you can use it. The code remains private.
SQLite Sorcerer’s issue tracker
This link will be available directly from the application (clicking the ‘About’ button) in the next release.
I am very happy with bitbucket / tortoiseHg, this just change my coding life :). If you don’t know Mercurial (the source code management system behind) or feel some difficulties with SVN, I encourage you to give it a try. Here is good tutorial I found.
Just a sort post to announce the availability of the version 1.6 tonight (Paris time). BUT there will be a problem in the update process due to a mistake in the certificate migration used to package the v1.5.8… I really dislike this feature.
So, to install the v1.6, you will have to uninstall the v1.5.8 before. I am really sorry for this especially for users who manipulate encrypted databases and who are used to open db file with their prefered password. Check you have all your hashed keys stored somewhere before uninstalling the current version. You can regenerate them with the v1.6 by reencryption if necessary.
I also remind you that the SQLite Sorcerer is no more signed so don’t be scared (not too much) by the ugly red icons in the install screens.
Now better news, here is the content of the v1.6 that you can download from here:
* Some options can be set in a new popup form
- The option of "Edition column position" allows to display data of tables with a large number of columns if set to ‘left’
* Snippets can be defined in this same new option form. Snippets are pieces of code you can use in the Query Panel to ease your query definitions
Improvements / changes:
* Small enhancement of the trigger creation dialog
* The "conflict" column is displayed.
* You can now check the autoCompact property at db creation.
* A explain mode can be selected in the Query Panel before executing a query. This seamlessly adds a EXPLAIN or EXPLAIN QUERY PLAN in your query.
* Only one button to execute queries: single or batch. As a consquence, you should be able to open a sql file and execute it directly whatever it contains (triggers or not especially)
* Files with wrong extension are no more accepted by the cauldron.
* Fixed the trigger creation in the Query Panel (as simple or in batch queries).
* When the sql code of the database is copied and pasted in the Query Panel, it should now be correctly formatted.
* Fixed a bug preventing the last deleted item to be removed from the Schema.
* Fixed a bug that locked the Data View after deleting a record.
* Differences results are back in the detached Query Panel.
* The ComboBoxes in the trigger and index creation dialog should now be correctly binded.
* A newly created view should now appear immediately in the Schema tree.
* You should now be able to define an import mapping with csv file with no header.
* The displayed structure of a table (field list) shouldn’t be updated after an error.
* It’s no more possible to open more than 1 query window at a time.