[aklug] Re: Open-source SQL Backends

From: Shane Spencer <shane@bogomip.com>
Date: Sun May 08 2011 - 15:39:59 AKDT

Seems like you're asking for a list to chug through and think about.
All I can comment on is what I use in production:

PostgreSQL + PostGIS
Sqlite + Spatialite
Google BigTables
and.. files.

Also take a peek at Hadoop.. it's neatness is sneaky.

While you're at it.. you'll probably enjoy removing the need for
redundant queries as well as post process queries at some point by
caching or using a pub/sub and delayed event solution:


I like me some ZeroMQ and Redis.

I use ZeroMQ to allow an HTTP "feed" to time out while waiting for an
event to be received by the socket handlers. For example with my
Localelator project that allows people to publish geographically
related event data to a streaming map server. Google Earth contacts
the map server and requests a KML (Keyhole Markup Language) file every
0 seconds. Since Google Earth is nice and waits for responses in
order I can stall the response on my side until a timeout is reached
while waiting (not polling) for events to come in. For me and people
using my system this means that as soon as an event is published
within a subscribers viewport.. BAM.. it's there. No query required.

- Shane

On Sat, May 7, 2011 at 6:27 PM, Christopher Howard
<christopher.howard@frigidcode.com> wrote:
> I've always used MySQL just because it was what I learned first. I am
> wondering if there were are any good arguments for using something
> different. For example, PostgreSQL. Or maybe some other nifty one I
> haven't heard of.
> I looked to see if there was an SQL backend written in Haskell, but
> couldn't find anything production ready. Though, there is a connectivity
> layer called HDBC that looks helpful.
> --
> frigidcode.com
> theologia.indicium.us
> ---------
> To unsubscribe, send email to <aklug-request@aklug.org>
> with 'unsubscribe' in the message body.
To unsubscribe, send email to <aklug-request@aklug.org>
with 'unsubscribe' in the message body.
Received on Sun May 8 15:40:07 2011

This archive was generated by hypermail 2.1.8 : Sun May 08 2011 - 15:40:07 AKDT