Friday, 27 February 2009

SQL Developer 1.5.4 coming soon

Working through the last issues with SQL Developer 1.5.4.  We've done a lot of work with this to address functionality that people required in the base product and now have translated it to 9 languages.
  1. English
  2. German
  3. Spanish
  4. French
  5. Italian
  6. Portuguese
  7. Chinese
  8. Simplified Chines
  9. Japanese
  10. Korean
Once we are happy with the current builds, we'll be out to users as soon as we can.  I also hope that this is the version to be adopted in the Oracle Database 11GR2 database

Image Authoring

I'd forgotten about GIMP. No, not the one in the movie, the image manipulation one.  Needed to touch up an image for SQL Developer with the correct copyright information and it just works.

Take the Splash Screen for SQL Developer.  Rewrite the copyright and  publish. This apps a keeper. :)

Wednesday, 11 February 2009

Prague Develop Event.

Well, its not as cold as it was in Moscow, but the welcome was just as warm.
We're here in Prague delivering the Oracle Develop event.

I'm here talking about our new modelling tool. Oracle SQL Developer Data Modelling which is available as an early adopter release on OTN.

Oracle SQL Developer Data Modelling is the latest product offering to join our Oracle Database Tools. SQL Developer Data Modelling has Entity Relationship modeling, Relational (Database Design), Data Type and Multidimensional modeling, full forward and reverse engineering and code generation. It includes importing from and exporting to a variety of sources and targets, provides a variety of formatting options and validates the models through a predefined set of Design Rules.

All in all, fills in one of last pieces of the database development cycle allowing us to model our databases before we go ahead and physically lay them out and create them. My personal favourite is the multidimensional modelling features.

Years ago, I was involved in a huge implementation of a warehouse which was all defined by hand; the fact tables, the dimensions and all the aggregates. This was fine at the time, but being able to go the database and extract the structure of it and show it as a model would have been great. Have a look at the image and the way the fact, dimension and aggregate objects are laid out.

Anyway, the talk today was great with loads of questions around how we'd handle Designer, Erwin and other formats, and why we just didn't use Rational or JDeveloper. There are a lot of answers for this in the FAQ.

For now, we have a couple more hands on labs where the attendees can get their hands on the software and ask questions about what they are doing.

Download it and try it and if you have questions, ping the forums and we'll help you get going.