[Haskell-cafe] Re: SQL Database in Haskell?

[CK Kashyap]

I'd be very interested to see a rdbms implementation in Haskell ... perhaps a port of sqlite

Regards,
Kashyap



________________________________
From: Don Stewart <dons at galois.com>
To: Günther Schmidt <gue.schmidt at web.de>
Cc: haskell-cafe at haskell.org
Sent: Thursday, August 6, 2009 6:07:48 AM
Subject: Re: [Haskell-cafe] Re: SQL Database in Haskell?

gue.schmidt:
> Hi,
>
> well I tried to do some stuff in memory, and the app ended up using a  
> couple of gigs. I not only have a very large amount of dynamic data, CSV  
> files, but also quite a large amount of static data, and wasted 3 months  
> trying to do this all in-memory. The problem was finally solved once I  
> used SQLite and SQL.
>
> The other day I had one last go at trying to compile the static data in a 
> literal list in my haskell code. That was 80.000 rows, it was just not  
> even possible

Don't compile in static data (or if you do, use -Onot, so that GHC won't
try to analyze it)!

Use some kind of binary on-disk storage.

> As far as I'm concerned this discussion is settled in favor of SQL once  
> and for all.
>
> The part I didn't like about SQLite is encryption, you need to buy that  
> extra and then hope that it fits the current version and future ones too. 
> HSQLDB or Derby for Java give you this option and also with in-memory  
> database, alas they are for Java only.

You might also want to look at the HAppS disk-backed persistence model,

    http://hackage.haskell.org/package/HAppS-State

Or the holumbus distributed storage layer,

    http://hackage.haskell.org/package/Holumbus-Storage
_______________________________________________
Haskell-Cafe mailing list
Haskell-Cafe at haskell.org
http://www.haskell.org/mailman/listinfo/haskell-cafe



      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.haskell.org/pipermail/haskell-cafe/attachments/20090806/fde023fd/attachment.html