Thursday, January 20

Geek

Lockon StratosDB

Target database acquired.  Analysing.

Open source...  Confirmed, GPLv2.
Supports UNION, INTERSECT, EXCEPT...  Confirmed.
Supports full-text search...  Confirmed.
Supports XML...  Confirmed, SQL extensions, XQuery, XPath.
Supports arrays...  Negative  Maybe?
Supports user-defined types...  Confirmed.
Supports geospatial data...  Confirmed-ish.*
Supports graph structures...  Confirmed, RDF, SPARQL.
Supports Python...  Confirmed, both as client and scripting engine.
Supports HTTP, SMTP, POP, IMAP, NNTP...  Confirmed.  Wait, what?  I thought this was a database.

Openlink Virtuoso could bear further investigation.  The Openlink Blog looks satisfyingly full of technical stuffs.

I've also been taking a look at Cubrid, another interesting where-did-that-come-from** open source database.

* You can find a handy feature matrix here.  The open source version has all the features of the commercial release, except for clustering, replication, and geospatial data.  The lack of replication in the open source version is unfortunate, but in my projects I tend to go for application-level replication anyway. 

Funnily enough, I was just looking at the free (as in beer) version of Informix, and that does feature replication and clustering - only two nodes, but what do you want for free?


** Korea, as it turns out.

Posted by: Pixy Misa at 02:12 AM | Comments (6) | Add Comment | Trackbacks (Suck)
Post contains 187 words, total size 2 kb.

1 Looks like another fine example of JWZ's Law: "Every program attempts to expand until it can read mail. Those programs which cannot so expand are replaced by ones which can."

-j

Posted by: J Greely at Thursday, January 20 2011 05:27 AM (fpXGN)

2 Arrays? Really? Really?

Posted by: RickC at Friday, January 21 2011 03:04 AM (BJQk5)

3 What I want is both arrays and the ability to use said arrays as index components, so I can have:

...
category int[],
posted timestamp,
...
key category (category, posted),

Screw
normalisation!

Posted by: Pixy Misa at Friday, January 21 2011 12:02 PM (PiXy!)

4 Everybody loves arrays, right up until the day they need to fit a 13th piece of data in their 12-bucket array. Furthermore, everyone insists "it'll never happen to me," right up until it does.

Posted by: RickC at Saturday, January 22 2011 09:54 AM (YB9ey)

5 In Postgres, arrays are unbounded.  Well, you can bound them, but it ignores you.

Posted by: Pixy Misa at Saturday, January 22 2011 11:09 AM (PiXy!)

6 That sounds vaguely obscene, but I guess it works.

Posted by: RickC at Sunday, January 23 2011 10:17 AM (YB9ey)

Hide Comments | Add Comment

Comments are disabled. Post is locked.
43kb generated in CPU 0.02, elapsed 0.1558 seconds.
52 queries taking 0.1375 seconds, 287 records returned.
Powered by Minx 1.1.6c-pink.