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

[Günther 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

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.

Günther


Am 06.08.2009, 02:16 Uhr, schrieb Mattias Bengtsson  
<moonlite at dtek.chalmers.se>:

> On Thu, 2009-08-06 at 00:04 +0200, Günther Schmidt wrote:
>> Hi Don,
>>
>> I actually meant an SQL database written in Haskell, same as Derby or
>> HSQLDB in Java.
>>
>> I'm currently using Sqlite3 with HDBC but would prefer one entirely in
>> Haskell (but still SQL though, because of persistence and performance).
>
> SQL is just a query language and the use of it is, as far as i can tell,
> orthogonal to the need for persistence and performance.