<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:times new roman,new york,times,serif;font-size:12pt"><div>I'd be very interested to see a rdbms implementation in Haskell ... perhaps a port of sqlite<br><br>Regards,<br>Kashyap</div><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;"><br><div style="font-family: arial,helvetica,sans-serif; font-size: 10pt;"><font face="Tahoma" size="2"><hr size="1"><b><span style="font-weight: bold;">From:</span></b> Don Stewart <dons@galois.com><br><b><span style="font-weight: bold;">To:</span></b> Günther Schmidt <gue.schmidt@web.de><br><b><span style="font-weight: bold;">Cc:</span></b> haskell-cafe@haskell.org<br><b><span style="font-weight: bold;">Sent:</span></b> Thursday, August 6, 2009 6:07:48 AM<br><b><span style="font-weight: bold;">Subject:</span></b> Re: [Haskell-cafe] Re: SQL Database in Haskell?<br></font><br>
gue.schmidt:<br>> Hi,<br>><br>> well I tried to do some stuff in memory, and the app ended up using a <br>> couple of gigs. I not only have a very large amount of dynamic data, CSV <br>> files, but also quite a large amount of static data, and wasted 3 months <br>> trying to do this all in-memory. The problem was finally solved once I <br>> used SQLite and SQL.<br>><br>> The other day I had one last go at trying to compile the static data in a <br>> literal list in my haskell code. That was 80.000 rows, it was just not <br>> even possible<br><br>Don't compile in static data (or if you do, use -Onot, so that GHC won't<br>try to analyze it)!<br><br>Use some kind of binary on-disk storage.<br><br>> As far as I'm concerned this discussion is settled in favor of SQL once <br>> and for all.<br>><br>> The part I didn't like about SQLite is encryption, you need to buy that
<br>> extra and then hope that it fits the current version and future ones too. <br>> HSQLDB or Derby for Java give you this option and also with in-memory <br>> database, alas they are for Java only.<br><br>You might also want to look at the HAppS disk-backed persistence model,<br><br><span> <a target="_blank" href="http://hackage.haskell.org/package/HAppS-State">http://hackage.haskell.org/package/HAppS-State</a></span><br><br>Or the holumbus distributed storage layer,<br><br><span> <a target="_blank" href="http://hackage.haskell.org/package/Holumbus-Storage">http://hackage.haskell.org/package/Holumbus-Storage</a></span><br>_______________________________________________<br>Haskell-Cafe mailing list<br><a ymailto="mailto:Haskell-Cafe@haskell.org" href="mailto:Haskell-Cafe@haskell.org">Haskell-Cafe@haskell.org</a><br><span><a target="_blank"
href="http://www.haskell.org/mailman/listinfo/haskell-cafe">http://www.haskell.org/mailman/listinfo/haskell-cafe</a></span><br></div></div></div><br>
</body></html>