Thursday, 2 April 2009

APEX on MacOSX

Well, I eventually got around to it and have APEX running on my Macbookpro with 10GR2.
Very nice. Building up an apex application is neat when you can do it where I live.

This leaves my dev environment all set up on mac now with:
  1. SQLDeveloper 1.5.4
  2. Apex 3.2
  3. Oracle 10gr2
  4. and Java with Eclipse :)
So, ok, whats weird or unusual about this setup you ask? Speed. The database and apex responses are instant on the macbook pro, and when I'm done I can export the app and deploy it on apex.oracle.com to share it with other folks.

Tuesday, 10 March 2009

Installing Oracle.....


Well, We do it alot and this is no exception. or is it...

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.

Tuesday, 27 January 2009

Moscow Develop Event

After several days of visa processing, I'm clear to go to Moscow. Spasiba Mockba!
I'm speaking on Wednesday 4th on our new data modeling tools.  I'm hoping to go through a presentation of the features by demo on the fourth starting with a reverse engineering of a couple of schema to a relational model and abstracting that into a logical model.  I want to show several views and slices of the model.
I also want to show a load of the property management capabilities such as naming conventions to constrain object names.
From there, we can push down and create a physical model, containing the attributes of that model, such as tablespaces, indices and multi dimensional objects.
Lastly, We'll complete the circle and do some DDL Generation.
On Thursday, I have set up two hands-on labs to allow attendees to work through a prescribed text showing much of the same features I'll discuss in the talk.
Technorati Tags: , ,

Tuesday, 6 January 2009

Back on the Chain Gang

After a great holiday season, its time to get back to the grindstone. We released SQL Developer 1.5.3 before Christmas which is our first translated release. Its just japanese right now and we'll be extending that to nine languages in 1.5.4.
The other major part of 1.5.4 I want to sweep up are as many issues as possible from our customers on the forums. Over the next few weeks, we'll be focusing on locking down as many of these as possible.
In terms of conferences, I'm off to Moscow in February as part of the series of Oracle Develop conferences. I'll be doing a couple of sessions on SQL Developer and hope to get under the covers to show exactly how you can build your own additions to it. I was watching Sue present at UKOUG and it was the one thing that struck me that people were looking for as heads were bobbing around the room.