Category: APEX
November 6

XFILES (Part 2) – APEX Newbie Enhancement Requests

Its not yet “the breeze” I hoped for in regard to “Installing XFiles” on APEX. I am missing parts of the source that XFiles in APEX is build upon and although I know where I can get it, it is not easy to implement it “The APEX” way. For example XFiles is depending on XDB Utilities, packages and methods in PL/SQL, that makes life easier while working with XMLDB and/or have implemented some of the best practices ideas of the XMLDB Development team and others. To do it, installing those, the “neat way”, it should be created in a different Oracle schema and not in the APEX workspace user owner (other database schema’s might enjoy them as well in the database).

A DBA View on Things…

APEX doesn’t have, AFAIK as a newbie, yet a proficient way to make this easy to install, or at least what I thought could be done, via a single packaged install. First of all, as said, there are dependencies to other “outside” packages and privileges. APEX doesn’t checks this but just fails and show a nice report with the failed statements (nice implementation) but would it not be even nicer to have a pre and post installation workspace import pages that checks on criteria needed and/or set by the creator of the APEX application before and afterward, the workspace SQL file is even imported. Ever have used, for example the latest, Oracle Software installer… That kind of thing but be a nice asset. There is now to much stuff, I hope that I actually implement correctly / as the APEX application creator, mend it to be.

An example. Apparently this XFiles demo application has been progressed in his source since the mentioned OOW 2008 Mark & Carl demo. It needs the database compatible parameter to be set to0 Oracle Database version 11.2.0.1.0 to actually work in respect to demonstrated the Application Security for APEX build upon XMLDB Access Control List Security (ACL’s) features, as demonstrated by Mark during Oracle Open World 2009 (Managing XML Content with Oracle XML DB and Oracle Application Express).

The first page, the XFiles APEX login page, hints this security feature implemented (check box with “Application Principle”)…

APEX Xfiles Login Page with Application Security features

Click on the picture to enlarge

Read the postXFILES (Part 2) – APEX Newbie Enhancement Requests
November 1

XFILES (Part 1) – In Remembrance of Carl Backstrom

There is a demo application out there for Oracle XMLDB, called XFILES, that demonstrates the Oracle XML database functionality. During Oracle Open World 2008 I attended a presentation of Mark Drake, Sr Product Manager XMLDB and Carl Backstrom, called “Oracle Application Express and Oracle XML Database: A Match Made in the Database“. Mark had build the XFILES demo application, until that time, with the tool-set he knew best, Java/JavaScript & PL/SQL.

Mark Drake and Carl Backstrom during their session on Oracle Open World 2008

In his final/last post on his blog site, called OOW recap (Pt 2), Carl described this session and the XFILES demo application:

The session I helped out with a bit was Mark Drake’s Oracle Application Express and Oracle XML Database: A Match Made in the Database. This session had it’s beginning’s way back at Web2.0 Expo where Mark and I shared a demo booth. XMLDB has a standard sample/demo called XFILES which is a simple yet full featured file management system using all XMLDB features. But it requires using a java server and is kinda slow , well I think it’s slow but I might be biased.

So I was like hey Mark! you should build this in APEX since we are both built in features of the database. And lo and behold the his session was born. I helped on and off with building the demo application , and it was a big learning experience, both with the features XMLDB provides as well as were APEX does not leverage them well, something we will be working on improving.

Mark at OOW asked if I could sit in so if there was any specific APEX questions, and hey I’m a people person so of course I said yes. The session was very well attended with many people in the audience already familiar with APEX and/or XMLDB. Mark covered the basics of XMLDB and I quickly went over APEX basic’s and then it was all demo.

I really think the application demo and explanation of how things were created was a hit, it showed the power of XMLDB as well as how APEX can leverage it’s features directly out of the database. Just the number of hands that came up with people saying things like

  • Hey I just built that a month a go and yours is cooler.
  • Hey I need to build that in the near future and these are great ideas.
  • Hey can I have that application?

shows that this session hit a sweet spot. A couple things I got from this is that people like that APEX can directly leverage built in database features and want more of it easier, and secondly I need to really make time to clean up that XFILES application so it can be a packaged application.

Read the postXFILES (Part 1) – In Remembrance of Carl Backstrom
September 30

Oracle Open World 2009 – XMLDB Sessions and Presentations

Its time to enlist. It really is. At least regarding the XMLDB related sessions and presentations during Oracle Open World 2009. As far as I have seen today, the hands-on workshop has almost no seats left and more than half already enlisted for my XMLDB New Features and XMLDB Performance related presentation.

Oracle Open World doesn’t have much XMLDB related sessions, until now from the 1800+ sessions, I only counted a dozen or so. If you want to have a peak of the ones I found, have a look at the following Oracle OTN XMLDB Forum thread.

I enlisted for most, as long as they didn’t interfere with my presentation schedule, if not only that I am very anxious about Mark Drake’s presentations about Google API mashups etc combined with the XMLDB functionality in the database and the, probably extended version of how to build an APEX content management system based on the versioning and filler capabilities of the XMLDB Repository. During OOW 2008, Carl Backstrom, helped and co-presented this APEX / XMLDB joined venture and, alas, this demo app. of the XFILES light weight XMLDB CMS based on APEX, never had (at least yet AFAIK) the chance to be a hit on the apex.oracle.com demogrounds or the OTN XMLDB main page after the source code had been cleaned-up.

For those who might enjoy a photo’s from that presentation with Mark and Carl during Oracle Open World 2008:

Read the postOracle Open World 2009 – XMLDB Sessions and Presentations