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 choice of using an encrypted database or not for an application is not easy as the operation at database level can’t be reverted. But actually you still can "desencrypt" an encrypted SQLite database and vice versa, later if you change your mind. The main principle is that a new database file has to be created and the content of the old one to be transferred into the new one. This requires some manual operations but nothing too costly.
Here is a short procedure, that of course is supported by the SQLite Sorcerer. I will take the case where you have an encrypted database that you want to desencrypt.
- Create an empty non encrpyted database, the one that will receive the content of the encrypted one.
- Launch the comparison process (only to view both database files during the operation).
- Open your encrypted database in the second visualizer using the password or the encryption key.
- Get its SQL code.
- Copy it to clipboard.
- Open the query Panel of the new database file, in the 1st visualizer.
- Paste the copied code
- Remove (copy them in clipboard) trigger creation statements
- Execute the batch query
- Return to step 7 for each trigger creation statement
You should now have the same structure in both files
- Now, for each table of the encrypted file (in the second visualizer), open the table.
- Show its data.
- Export data to a file (keep default options).
- Once all table data are exported, import all csv files in the corresponding tables of the empty new file.
And you should now have a filled non-encrypted copy of your original encrypted database file, with the same structure and containing the same data. Just test your new non encrypted database, of course.
I can streamline this process in a future version of SQLite Sorcerer. A dump creation feature would be great but quite touchy because of data types or a "transfer to" feature may be…
This is now a little more than 1 year that I am working on the SQLite Sorcerer - my posts on multi-statements queries were actually a kind of preliminary study. Then a first release on April 2009, followed by regular releases. I work hard to provide a useful application with a bunch of features and a high level of quality. About the UI, this is just a question of taste and … fun.
Since the release of the version 1.5, I consider to change the way the application is distributed. Actually, I haven’t activated the auto-update feature of the application but it is there till the beginning - just commented - as it was supposed to be an exclusive privilege for donators. But this is really boring for users to uninstall and reinstall a new version to upgrade their favorite ( ) SQLite administration tool. Especially for those working with encrypted databases.
So I decided to activate this feature from now, for everybody. This is my Christmas present (with a few days late) for the few fans of the SQLite Sorcerer ;), to help them have a successful year 2010 with their local SQLite db. If you’re not already a fan, I hope this will help you become a regular user.
Just click the package on the right to get the app.
But there is still a limitation… yes, sorry. The certificate I use to sign the application has its expiry date on june 2010. I am not sure to be able to renew it (I use the offered certificate by Adobe as an AIR application publisher on the AIR marketplace) and I just hope the migration to a self-signed app will encounter no issue.
In the meantime, enjoy the app and don’t hesitate to send me feedbacks and ideas.
A new version is now available for download.
It contains lots of changes and improvements including:
- Renderers: I wanted to provide a new access to features so I decided to insert renderers in DataGrids and Trees.
- A History feature in the Query Panel
I hope you will like it.
Before installing a new version !!
I remind every SQLite Sorcerer users, that if you used a previous version to encrypt db files, you won’t be able to open them using the strong password. You will have to use the hashed key. This a due to the reinstallation of the application.
So before installing a new version, check your hashed key storage/repository. Then you can reencrypt your db with this new version and update your hashed key repository with the new key.
Only donators, who are able to update the application, can continue to use their strong password to open encrypted db.
The version 1.4 of the SQLite Sorcerer is just released !
Changes and more after the jump.
Continue reading »