Jellybob's Journal: Journaliser

Journaliser is my current pet project, which will eventually be a (smaller) Live Journal style site.

I'm aware that there are loads already, but it's more a real site to develop a framework I'm doing for, then something I expect to get big.

Anyway - I just did (another) design for it, which I think may make it to the final site, so go take a look at it: http://www.jellybob.co.uk/~jon/journaliser/.

Jon

PostgreSQL or Oracle?

[GMontag]

Just wondering, does anybody know if there are already functions in Oracle or PostgreSQL to handle threading and commenting?

Might sound like a goofy question to some, but data mining is where I have done most of my work and never had to build a feature like that into an application.

Re:PostgreSQL or Oracle?

[Jellybob]

Threading and commenting as in commenting on people's stuff, and have a threaded conversation?

This is my first project with Postgre, since I've gotten sick of MySQL bodging stuff that should just work - never really had a reason to use it before, since I don't usually need a full blown database, just something I can retrieve information from quickly.

Re:PostgreSQL or Oracle?

[GMontag]

Threading and commenting as in commenting on people's stuff, and have a threaded conversation?

Yep. Perhaps linking to related previous stories could be fit into this too, idunno.

Re:PostgreSQL or Oracle?

[Jellybob]

I don't know of any functions that will help you with that... I tend to have a class that does a recursive search for children of the current comment, with a table something like this:

id (INT, SEQUENCED)
parent (INT)
item (VARCHAR, something along the lines of "news.23")
owner (INT)
body (LONGTEXT)

Related stories I guess you could either do by linking them to the item, or if you feel adventureous [no, can't work out how to spell that] (if you do data mining, it's probably not much of an adventure), you could