Re: native xml processing vs what Postgres and Oracle offer
Date: Fri, 21 Nov 2008 06:07:20 -0800 (PST)
On Nov 10, 2:17 pm, salmobytes <salmoby..._at_closenuf.org> wrote:
> I'm thinking about starting a hobby project.
> I wrote a files-based Bulletin Board years ago.
> I'd like to convert it to a more database-like system, so
> password-identified users could edit old posts.
> Forums are inherently hierarchical and hierarchies are
> tough with relations. I have modeled relational hierarchies in
> the past, with what Joe Celko calls "path enumeration."
> That works, but it's a bit ugly and making indexes on loooong
> path-strings that all start off the same way is messy.
> I'd rather work directly with hierarchies: with XML.
> For native XML processing you can work with SleepyCat,
> Exist or even Xindice (or expensive proprietary products
> like Mark Logic or Ipedo).
> But Oracle and Postgres have a way to stuff XML blobs
> into a column now, and also a way to query with XPath
> over those XML blobs
> The native XML databases (SleepyCat etc) all require running a tomcat
> server, while postgres is a bit easier to setup and install.
> PUNCHLINE QUESTION, sort of.
> I've worked with SleepyCat, Exist and Tomcat.
> It's pretty powerful stuff and it has a lot to offer.
> Mapping between GUI and data is oh so easy with
> hierarchies, compared to relations. But what about
> performance? I've never worked with Oracle/Postgres
> XML XPath querying. And I've heard rumors it's dog slow
> above a certain size/traffic threshold.
> Any comments? Anybody done much with Postgres/XML?
> Have any comparisons to SleepyCat?
Haven't we finally done with XML? I thought it was JSON a-go-go these days? Received on Fri Nov 21 2008 - 15:07:20 CET