Wednesday, March 23, 2011

OGH APEX Day 2011

Yesterday it the Dutch Oracle User Group (OGH) organized a full day APEX-only event. And what a day it was! With 250 attendees it was completely sold out. And I guess, if there had been more room, there might have been even close to 300 people there. So APEX gaines more and more interest - and faster and faster... 
And where did all those people came for?

Before lunch there were three general sessions. The first was by Tony Andrews and Nigel Blair of Northgate, talking about their 1500 Forms-to-APEX conversion project. They succeeded and therewith proved (again) that APEX is capable of running enterprise / large scale / mission critical applications. But as they started some years ago, they couldn't use all the new cool stuff, like Dynamic Actions, and therefor build an own framework. And that might require "some" work to bring it into the APEX 4 world. But that's the disadvantage of being ahead of the curve!

Then Hilary went on stage to tell - and show! - us the new APEX 4.1 stuff. There is a list of the things you might expect for 4.1 (see Statement of Direction), but to actually see (some of) it is always better. The new Themes/Templates using jQuery Mobile delivers an awesome result on a smart phone. Another good thing is that 4.1 will support not only Static Lists - as we know nowadays - but also Dynamic Lists! So it will be a lot easier to generate your menu's etc from a database table.
The validations and processes for Tabular Forms are improved. For instance, you can define validations for each row or once per page - using SQL or PL/SQL. And you can also trigger these validations for only updated and new rows or for all rows.
Also the Dynamic Actions are enhanced: you can use conditions within Dynamic Actions, so you don't need to create multiple similar ones.
The  number of Plug-in attributes will be raised up to 15 (still not enough, according to some). But even better, there will be new types of Plug-ins: for items in a tabular form, for Authentication and Authorization Schemes. Regarding the regular Forms: The use of ROWID will be supported and also using primary keys with more than 2 columns isn't a problem anymore. 
Also Websheets are revamped. The look-and-feel and navigation is improved. A thing that came rather strange to me is that sections within a page can also be based upon PL/SQL. And I thought that Websheets was aimed at the (experienced) end-user. But my end-users don't write PL/SQL code. Not even the experienced ones. I hope...
And of course someone asked the usual question - and the answer was "Calendar year 2011". (All things said/shown with the usual Oracle disclaimer).

Next John and Dimitri shared the stage. Doing a presentation (or an act?) about their newest idea: FoogleTwit. Within a few years, "The Social Network, part 2" will shine a light on this!  But it seems, that that name is first mentioned in a comment on a blogpost on Feb 10 this year. So there might be some law suits coming up...
The content was great though: They showed how APEX Evangelists run their projects.

After lunch there were three parallel tracks: Core APEX, APEX and ?, APEX at Work. The first one I attended was by Peter Raganitsch about the Translation Mechanism. In short: it works, but takes a lot of work and maintenance is not so simple. So if you can stay away from multi-lingual applications, you should. Otherwise, the best tip: Do your translations as far in the end as possible. So after running in production for a fair amount of time (so most bugs will be fixed by then).

Then it was my turn. I presented about "Charts and Dashboards". I showed a lot of Charts: First the regular once, then the slightly adjusted one and the completely revamped one. Some of the charts and dashboards demoed might require an additional Anycharts license (as Hilary pointed out). This was my first presentation where the demo and the presentation were tightly integrated: it was one and the same APEX application. You can see it here : apex.oracle.com/pls/apex/f?p=oghapexdag. You can click through the "slides" using the Next and Previous buttons at the bottom. And open up the Hide/Show regions where ever they pop up. Only the part that uses the APEX Listener Templates won't work...

The last presentation I attended was Dimitri's one about APEX and Locator / Spatial. The solution and demo he did was very impressive. This spatial stuff is even more powerful than I thought. But not so easy to comprehend though... It will take some time to get to know this stuff.

They day was concluded with some drinks and a nice dinner. It was a long day, but worth every minute! And, of course, a special thanks to the organizing committee. They did a hard job very well! 
Post a Comment