Wednesday, July 22, 2009

My session @ OOW : The first of all 1800+ sessions....

I just received an e-mail from the OOW Content Team. They've managed to schedule my session at Sunday morning from 8:00 - 9:00. So that's officially the kick off for the event...
Two advantages for this early hour: I will probably wake up at 4:00 AM anyway due to the expected jet lag (just like all the other Europeans that will fly in on Friday or Saturday, so no excuse for you guys!). And I will have finished my duties one hour after the event starts, so I can enjoy the show without worrying about my presentation!
Hope to see you all at this early - and probably inconvenient - time...

Wednesday, July 15, 2009

Ended up 10th at Oracle OpenWorld 2009 Vote-a-Session

My abstract "It's great to integrate: Combining Oracle Forms and Oracle Application Express" for the upcoming OOW ended up 10th (out of 150). That's one place up compared to last years voting! So a big thank you to all 99 people who voted for me (98 if I count myself out).
And just like last year it proves that APEX has a very strong community: 5 of the top 10 sessions are APEX-related (8 of the top 30: around that number seem to get an invitation).
So thanks again and I hope to see you all in San Francisco in a couple of months!

Thursday, July 02, 2009

APEX 3.2 Oracle Forms to APEX conversion in Oracle Scene

The new issue of Oracle Scene (the official UKOUG Magazine) out. I am very proud that one of the articles is written by ... me! It is even on the cover page!
For all the folks out there who don't have a subscription, you can read my article here.
Let me know what you think of it!

APEX FLoating Developer Toolbar

During the APEX 4.0 session at last ODTUG a question was raised: "Can we have a floating developer toolbar" (the thing at the bottom of the page with a.o. the 'Home' and 'Debug' link). There is no need to wait for APEX 4.0 to get that (if it will be implemented as a new feature), you can have it NOW!
If you put the next piece of code in an HTML Region in Page 0 (or in your Template, whatever you like), the toolbar gets sticked to the bottom of your browser like glue...

I guess it only works for FireFox, but that doesn't matter, because that's the tool we're all using anyway, aren't we? Oh, yeah, and you need jQuery...

Oracle SQL Developer Data Modeler available - but not for free....

Almost covered by yesterdays FMW 11g stampede, the production version of SQL Developer Data Modeler is available on OTN.
As expected (see this and this last years blog entry) this is not a free tool like SQL Developer or JDeveloper. It is a for-cost option of SQL Developer, and requires a separate license. And what are the license costs (as of yesterdays Pricing List): $3000 + $660 per year per Named User.
It looks really good. The functionality is about the same as the modeling part of good old Oracle Designer (it can even import the definitions from a Designer Repository). The full Internet Developer Suite costs $5800 + support per user. But then you get the all Designer functionality + Oracle Forms + Oracle Reports...
Is it worth the $3000? I don't have an opinion on that yet, do you?

Wednesday, July 01, 2009

The buzz around APEX 4.0

During last weeks ODTUG Mike Hichwa presented APEX 4.0. This seemed to be the best attended session (apart from the 'real' keynotes) with over 200 attendees, so a lot of people wanted to know where their favorite development environment is heading!
Mike demoed some really cool new stuff - I will discuss these later on - and skipped (even more) nice features, with Declarative Tabular Forms, AJAX Client-Side Validations and Improved Error Handling make the top 3 of most interesting ones. See the pic of the slide for a complete list.

There has been more blogging about Websheets last year, even with movies. But every time you see it live, it is amazing. Just copy data from a CSV, paste it into the APEX Builder and you're done! No Tables, Triggers, Primary Keys, etc needed: everything is automatically managed in APEX$xxx tables. You can update the data in line (like a Tabular Form), you can do mass update, create an LOV on the fly and add columns. You can also add Attachments, Notes and Tags to a record. The history is automagically kept, so auditing is out-of-the-box. You can define the properties of a column, move columns up or down, define column groups and even validations: all at runtime! So the (already thin) line between the Builder and the Runtime version of an application will get more vague.
But even Websheets will have its limitations: The Page Flow is limited and also the control over the Look & Feel is less exhaustive as with 'normal' APEX Pages: No use of Themes and Templates (more or less similar with the Interactive Reports).

Dynamic Actions
With Dynamic Actions you can Enable/Disable and Show/Hide Items dependent on the values of other Items. Things you nowadays need to code in (one line) of Javascript, will be declarative. That means not only less manual code, but - more important - easier maintenance, because these declarations will be stored in the APEX Repository and thus be available through APEX Dictionary Views.

In APEX 4.0 all charts will use the - much better looking - AnyCharts 5.1 version. Not quite clear if also the new chart types (like Gantts) can be declaratively created.

REST Web Services
In APEX 4.0 you also the use of REST Webservices is declarative. There was a short - but impressive - demo how to use Yahoo Maps within APEX.

Another main new feature are the Plug-Ins (previously called 'Custom Item Types'). You can compare these Plug-Ins to Widgets or - in the good old Oracle Forms environment - Pluggable Java Components (PJCs). Just register it within the Repository and you can use it wherever you like. The idea is that there should be a central 'Plug-In Registry' where every APEX Developer can register his Plug-In and make it available for download (free or for a fee). Oracle has no plans of managing / checking / controlling that registry due to legal restrictions (although just referencing source files didn't help Napster or The Pirate Bay ;-) ). The demo showed just registering / uploading a sql file containing the Plug-In (an Amazon style star rating) and the absurd easy way to use that Plug-In in a Form. Soon Patrick will be blogging about the technical details.

Improved Application Builder
Also the APEX Application Builder itself is revamped. The navigation is more intuitive, Interactive Reports are used all over the place and there is a general 'Search' function. That'll make developing with APEX even more productive...

Improved Interactive Reports
And even the, already fantastic, Interactive Reports got a make-over, with added functionality, like e-mail notification, compound filter expression (so you can use brackets and OR's in a filter) and - one long lasting request - shared saved reports!

Release Date??
As I can see for the search terms that hit my blog, "APEX 4.0 Release Date" is a very hot topic. Of course the Oracle APEX posse didn't gave a fixed date. And if they did, there is always the 'safe harbor'/disclaimer page as the first slide of the presentation. But in one of the presentations a 'date' was mentioned: End of 2009! So I will set my expectation to 2010Q1...