Blog

Archive for the 'SQLEditor' Category

SQLEditor 3.0.2 with experimental Redshift support

Thursday, July 7th, 2016

Today SQLEditor 3.0.2 was released which offers some bug fixes, slightly better javascript error logging and new experimental Redshift support.

SQLEditor should now recognise the redshift JDBC drivers and it also has a redshift specific dialect.
Currently the dialect is absolutely identical to postgres, but further improvements are in development.
As a warning, it’s not really ready for prime time yet, and more testing is to be done.

Feedback is really welcome.

Download v3.0.2 (58MB zip)

SQLEditor 2.8.2

Tuesday, June 17th, 2014

A new version of SQLEditor is released. Version 2.8.2 [56MB zip file]

Things of note in SQLEditor 2.8

The SQL parser has had quite a bit of work done on it for this release, which should mean fewer parsing oddities, particularly with keywords. This was originally reported as a bug involving the word ‘source’ as an identifier. You can now use ‘source’ as an identifier without problem. 🙂

There are several improvements to table renaming, and objects are better at preventing duplicated names.

Another significant improvement is the rewrite of the document state code. This handles things like when the document needs to be saved and when it is marked edited. Previously documents appeared as ‘edited’ immediately upon opening, but now they only appear as edited when they actually have been edited.

As part of the state change rewrite, undo for object properties should be more solid and label color editing should be more reliable.

There are also various other improvements and bug fixes.

Hopefully this should be a good release.

What happened to 2.8 and 2.8.1?

2.8 reached beta, but several bugs were identified, particularly in object naming and auto increment. These were fixed and 2.8.1 was released.

2.8.1 was a full release version, but a build issue caused two help files to be omitted from the build. This generated an exception when attempting to view them.

SQLEditor 2.7.1

Wednesday, February 26th, 2014

I’m happy to announce SQLEditor 2.7.1 (zip file, about 55MB). If you have automatic updates turned on, this update should appear the next time SQLEditor checks for updates.

As well as various bug fixes, this release also has a nice new feature where you can drag an entire SQLEditor document into another SQLEditor document and the contents will import everything in the first document into the second document.

 

You can also do this with SQL files and SQLite database files. In this second video I’ve got a SQLite database file and I drag it into the SQLEditor window. (Then I moved the second table a bit)

 

SQLEditor 2.7.1 (zip file) is available to download immediately.
It’s a free upgrade for all SQLEditor 2.x customers.

SQLEditor 1.x users can upgrade from 1.x at a good discount.