Tuesday, February 06, 2007

Do it yourself asktom...

I was reading Scott Spendolini's blog this morning and he reminded me of something I forgot to announce.  After repeated requests over time - the application behind the asktom website is available for download.

You can read Scott's take on this here.  Basically - the APEX team is providing a set of "packaged" applications and other open source projects to anyone that wants them.

I would like to take a moment to thank two people for their help recently.  They are - Christina Cho:

U34215

and Marco Adelfio:

DSCN0322

the team that rewrote asktom for the purpose of making the "ask the expert" software available.  They had the unenviable task of taking a bit of software that evolved from my lovingly handwritten mod-plsql first version of asktom, into the first html/db application.  Where it got "stuck" in a time warp - stuck at version 1.4.something of html/db - a release that was never actually released.  It was not really upgradable - so they took it and redid it.

I've been very pleased with the results so far...

POST A COMMENT

18 Comments:

Anonymous Anonymous said....

Thanks a bunch Tom for releasing the application for download.

Thanks a bunch to the team behind this too.

I have been waiting for the downloads ever since you announced this on your blog a while ago :))

Hope to put it to good use and convince my user community more than ever before, on why and more importantly how we can harness the capabilities our existing 10gR2 database.

Probably the topic for another blog or query on asktom.. my firm's IT philosophy is why build when you can buy.. end state.. we have multiple solutions running on various "databases" and we interface data into our Oracle Financials database..

We could have built half those apps and run it on our existing Oracle database, with a way better GUI and more importantly.. much much better data integrity..

Better stop pouring my woes out on your blog

Thanks yet again for the wonderful service you have been providing to the Oracle community..

Ram

Tue Feb 06, 11:43:00 AM EST  

Anonymous Mark Brady said....

That's very cool. Not afraid of competition or is there a 'no compete' in the EULA? ;-)


I'm thinking the world needs another Dear Abby or Miss Manners.

Now where in the code to I insert Google Adsense.

Tue Feb 06, 11:46:00 AM EST  

Anonymous Andrea said....

I hoped it was able to deploy on Oracle XE... but unfortunately it does not...

Tue Feb 06, 12:55:00 PM EST  

Anonymous Wayne said....

Tom,

They deserve some time off for all that hard work. Tell them to take off next saturday and sunday.

Wayne

Tue Feb 06, 03:08:00 PM EST  

Blogger Vidya Balasubramanian said....

That's great work the site is refreshing and well organized now - will we see xml feeds for hot / popular questions soon?

great work!

Tue Feb 06, 06:21:00 PM EST  

Anonymous MVE said....

What do you think of APPS dropping support for mod_plsql based applications? Do you care?

Wed Feb 07, 02:19:00 AM EST  

Anonymous MVE said....

One more thing ... you are a Fire Fox fan right? Here's a great extension called Tidy Html Validator - https://addons.mozilla.org/firefox/249/

Once you start seeing those red X circles and yellow ! triangular marks on every page you develop, it will change the way you write HTML code.

HTML is, code after all; we just never had a good "instant" compiler to let us know we are doing something wrong.

On asktom.oracle.com home page alone there are 27 warnings and 1 error.

Wed Feb 07, 02:29:00 AM EST  

Blogger Jeff Hunter said....

Ah, but what is AskTom without Tom? It's just some HTML pages and a database.

Wed Feb 07, 09:19:00 AM EST  

Anonymous Marco said....

andrea - you can install Ask The Expert on apex.oracle.com (after requesting a workspace), then export the application without supporting objects to install into XE. You'll need to move the database tables yourself, but the app can run just fine on XE.

vidya - there are links to RSS feeds on the homepage

Wed Feb 07, 10:04:00 AM EST  

Anonymous Andrea said....

@Marco:

Thanks... great tip.
I'll test this soon!!!

Cheers,
Andrea

Wed Feb 07, 02:37:00 PM EST  

Blogger Joel R. Kallman said....

What do you think of APPS dropping support for mod_plsql based applications?

What does this mean? That Apps will not be supporting modplsql? Or that modplsql simply won't ship with Apps?

Wed Feb 07, 03:06:00 PM EST  

Anonymous MVE said....

> What does this mean?
> That Apps will not be supporting modplsql?
> Or that modplsql simply won't ship with Apps?

They dropped support for mod_plsql see:
http://dbatoolz.orapros.com/tp/1596.farewell_to_mod_plsql.html

Wed Feb 07, 05:30:00 PM EST  

Anonymous Marco Gralike said....

Roland Bouman on Webenabling OracleXE - You can, Free of cost http://rpbouman.blogspot.com/2006/02/webenabling-oraclexe-you-can-free-of.html

Wed Feb 07, 07:26:00 PM EST  

Anonymous Frank Zhou said....

The "AskTom" new website is really cool !! There are a lots of nice new enhancements.
I have a little suggestion :) Would you mind asking Christina Cho or Marco Adelfio to add a "Back" Button on the page ? ( Back to the previous page,
instead of returing to the home page ). I think that will be a userful gui enhancement and that can also reduce the database resource usage.
Thanks again !
Frank

Mon Feb 26, 05:42:00 PM EST  

Anonymous Marco said....

Frank -- I'm glad you like it. Can you clarify what you mean by Back to the previous page, instead of returing to the home page? I assume you don't mean duplicating the browser's Back button.

Tue Feb 27, 11:14:00 AM EST  

Anonymous Frank Zhou said....

Marco
Thanks for your reply !

Let me show you a little example.
Click the "1 - 15 Next" "Next" Button 4 times and you will see

"Previous 61-75 Next"

and then click any one of the subject on that page.
After I read that question/answer on that subject. I could not find a "Back" button on that subject page to return to

"Previous 61-75 Next"

So I have to click the "Back" button on the IE browser and return to

"1 - 15 Next"

I need to click the "next" button 4 times to get to "61 - 75" again.

Thanks

Wed Feb 28, 10:26:00 AM EST  

Anonymous Marco said....

So I have to click the "Back" button on the IE browser and return to

"1 - 15 Next"


That seems to be a quirk of IE (one of many reasons to go Firefox -- it takes you back to the right spot).

We added a Open links in new window option to the homepage, so if you check that box, you won't lose your place any more.

Wed Feb 28, 11:41:00 AM EST  

Blogger AliKhan said....

Gents, what workspace do i need to be in to deploy this app?

I am using version 3

Thanks!
Ali

Fri May 18, 08:01:00 AM EDT  

POST A COMMENT

<< Home