OTN Discussion Forums : Blog or Wiki applications built using ...

.Richard.

Posts: 96
Registered: 12/23/98

Blog or Wiki applications built using APEX
Posted: Apr 16, 2007 7:41 AM

I have been tasked with finding a ready-made solution that we can use as a developers' scrapbook where development team members can store useful hints/tips, code samples, coding standards etc etc

An APEX solution would be best (something similar to Carl Backstrom's APEX demo app, maybe) since it's familiar territory and it would keep the sys admins happy - but I'm open to other solutions.

A non-APEX solution would have to be Windows based, with no server-side requirements.

I quite like TiddlyWiki (http://www.tiddlywiki.com) but it's not multi-user. There is a 'groupauthoring' plugin for it (http://tiddlywiki.bidix.info/) but it requires use of Ruby scripts on the server.

Online blogs like blogspot would be great, but The Business wants to keep everything in-house.

So, has anyone built a blog or wiki-type application using APEX that they would be willing to release 'into the wild'? Or is there another solution that I've missed ...

Cheers
Richard

Tony Miller

Posts: 473
Registered: 02/08/07

Re: Blog or Wiki applications built using APEX
Posted: Apr 16, 2007 1:50 PM

in response to: .Richard.

Reply

Check the library of built applications offered by the apex developers. You should be able to build what you need from one of them as a starting point...

.Richard.

Posts: 96
Registered: 12/23/98

Re: Blog or Wiki applications built using APEX
Posted: Apr 18, 2007 8:04 AM

in response to: Tony Miller

Reply

Thanks for the pointer.
I was really hoping to find a blog/wiki application already built rather than have to do it myself. Lazy, I know

Tony Miller

Posts: 473
Registered: 02/08/07

Re: Blog or Wiki applications built using APEX
Posted: Apr 18, 2007 8:30 AM

in response to: .Richard.

Reply

I understand, but isn't that 3/4 of the fun, coding it to EXACTLY what you need?

Thank you,

Tony Miller
UTMB/EHN

fac586

Posts: 1,196
Registered: 01/18/99

Re: Blog or Wiki applications built using APEX
Posted: Apr 19, 2007 7:55 AM

in response to: Tony Miller

Reply

I'm also on the lookout for a blog app. Can be rough and ready as I'm mainly interested in using it to generate an RSS feed for a proof of concept. If - as Tony says - I'm in for all the fun of DIY, can anyone at least give a boost with a blog data model/design pattern?

danusgov

Posts: 65
Registered: 06/09/04

Re: Blog or Wiki applications built using APEX
Posted: Apr 20, 2007 8:26 AM

in response to: .Richard.

Reply

I wonder how hard it would be to take the source code for WordPress and "Oracle-ize" it?

Dan

wbfergus

Posts: 1,059
Registered: 05/11/99

Re: Blog or Wiki applications built using APEX
Posted: Apr 20, 2007 8:39 AM

in response to: danusgov

Reply

Well, whoever winds up doing something, how about co-ordinating with Carl (since he should almost be done with Collaborate now).

See: http://forums.oracle.com/forums/thread.jspa?threadID=415236&start=0&tstart=0 for a related thread.

Bill Ferguson

Patrick Wolf

Posts: 1,812
Registered: 04/24/00

Re: Blog or Wiki applications built using APEX
Posted: Apr 20, 2007 8:58 AM

in response to: fac586

Reply

Hi Paul,

if you are just looking for an example how to generate an RSS feed with APEX, have a look at the "Ask the Expert" application. I think it has such a feature. http://www.oracle.com/technology/products/database/application_express/packaged_apps/packaged_apps.html#ASK

On http://asktom.oracle.com/sdillon/rss.html you will find some RSS examples how they did it on asktom.oracle.com

Patrick

Check out my APEX-blog: http://inside-apex.blogspot.com
Check out the ApexLib Framework: http://apexlib.sourceforge.net

fac586

Posts: 1,196
Registered: 01/18/99

Re: Blog or Wiki applications built using APEX
Posted: Apr 20, 2007 9:48 AM

in response to: Patrick Wolf

Reply

Patrick

I'm looking for an app to provide data so I can utilise the asktom example...that part of the concept is already proved!

carl.backstrom@...

Posts: 3,792
Registered: 06/05/02

Re: Blog or Wiki applications built using APEX
Posted: Apr 20, 2007 10:02 AM

in response to: fac586

Reply

Hello,

Here is an example of the beginnings of the wiki application, to edit add a subject just login it uses open credentials,

http://apex.oracle.com/pls/otn/f?p=2757:709

the code as it stands here can be downloaded here (it differs slightly from the demo version as i've actually done some dev work on it)

http://oracle-apex.svn.sourceforge.net/viewvc/oracle-apex/wiki/

Feel free to download add critic etc, I defiantly am still looking for someone that knows regex really well it would help greatly speed development along.

There will be movement on this and the forum application as I finally have a bit of time to work on these again, of course anyone that wants to help is greatly appreciated.

Carl

fac586

Posts: 1,196
Registered: 01/18/99

Re: Blog or Wiki applications built using APEX
Posted: Apr 20, 2007 10:23 AM

in response to: carl.backstrom@...

Reply

Carl

I failed to realise that wiki app + regexp Help! thread indicated that a text-to-HTML converter also suitable for a blog app was in the pipeline. Not familiar enough with the sharp end of wikis and blogs obviously.

I was vaguely intending to pick up the Java implementation of Markdown and give it a PL/SQL wrapper (unfortunately not suitable for Oracle XE). In the remote possibility that you weren't aware of Markdown, maybe looking at the source for some of the implementations would be of help.

A PL/SQL port of Markdown would be a useful addition to the toolkit.

carl.backstrom@...

Posts: 3,792
Registered: 06/05/02

Re: Blog or Wiki applications built using APEX
Posted: Apr 20, 2007 10:29 AM

in response to: fac586

Reply

Hello,

Nope it wasn't a remote possibility, I've never heard of markdown I'll definatly check it out, no need to reinvent the wheel.

My only concern is I want to follow the syntax used in twiki ,http://twiki.org/, but hey if I can plug the java library in as a stopgap till a pl/sql version can be implemented that would allow me to focus on other parts of the functionality.

Carl

charlieslist.biz

Posts: 9
Registered: 05/20/07

Re: Blog or Wiki applications built using APEX
Posted: May 26, 2007 3:14 PM

in response to: Tony Miller

Reply

Tony,

Can you please give me the URL to this - "library of built applications" ?

Thanks

charlieslist.biz

Posts: 9
Registered: 05/20/07

Re: Blog or Wiki applications built using APEX
Posted: May 26, 2007 3:19 PM

in response to: carl.backstrom@...

Reply

Hi Carl,

I am looking for come very similar to what you have got here.
http://apex.oracle.com/pls/otn/f?p=2757:709:5803666064490741::NO:709:TOPIC:Home

would you be able to give me the entire application? Since you said, I went to source forge, but I founf only some sql scripts (.sql's)

thanks
charlie

Dimitri Gielis

Posts: 1,859
Registered: 04/21/07

Re: Blog or Wiki applications built using APEX
Posted: May 27, 2007 12:23 AM

in response to: charlieslist.biz

Reply

Location Library of built applications?

I suppose you mean Packaged Applications and Sample Code?
You find that here: http://www.oracle.com/technology/products/database/application_express/packaged_apps/packaged_apps.html

Dimitri