SQLEditor 1.4.4 was just released on Tuesday, the main feature improvement is the support for compound foreign keys. I posted a bit about this before and the final version is pretty much the same as I described.
Unfortunately there were a couple of bugs that slipped through relating to clicking objects. 🙁
These are going to be fixed in a point release that should appear soon.
The new version is available from the automatic update system or download here:
I picked up a copy of Wired UK yesterday and I started reading it this morning while I was eating my breakfast.
So far I’m impressed, it feels solid, there’s plenty of interesting looking stuff and I liked the infographics (which I spent some time interpreting). The pictorial on the 3d printer that uses regular paper was really clever too.
I hope to offer more thoughts on this once I’ve read more, but my first instinct is to subscribe for the year.
Which is good; because I was really hoping that it would be good, and it is.
The newest version of SQLEditor (1.4.4b1) now has support for compound foreign keys. This is something that people have been asking about for a while now, so I’m pleased that it got included.
There are some things that may need to be improved, but I’m fairly happy with the first revision of this.
Diagram showing compound foreign key
The compound foreign key object is a new table level object that you can add from the Object menu just like a field or index. Then you drag from the foreign key to the target table. Finally you use the inspector to create pairs of columns to link together.
When importing from a database SQLEditor will try to create field-to-field links on foreign keys with only 1 pair of columns unless you tell it otherwise. (There is a new preference to do this)
Support is fairly complete, SQL parsing, database import, database export and SQL export are all available so it should work fairly well. I think the only thing it doesn’t do is auto-create indexes, so you may need to do this by hand on referenced columns (for those databases that need this)
There is naturally a new inspector palette to go with the table object.
Compound foreign key inspector
This allows you to add pairs of columns using the + button at the bottom. Choose your columns using the little popup menus.
The whole thing is completely new, so please send in your thoughts to the usual address.
