Re: Hackage 2 and acid-state vs traditional databases

2012-09-07 Thread Ian Lynagh
On Thu, Sep 06, 2012 at 04:36:07PM -0400, Leon Smith wrote: That said, I think there would be some potential advantages of moving to SQL. My personal preference would for PostgreSQL, particularly because of the wealth of datatypes it provides, or can be added to it via already existing

Re: Hackage 2 and acid-state vs traditional databases

2012-09-07 Thread Leon Smith
On Fri, Sep 7, 2012 at 8:48 AM, Ian Lynagh i...@well-typed.com wrote: I think it would be best to use lowest-common-denominator SQL, so that one can set up a Hackage 2 instance with postgreq, mysql, sqlite, or another DB backend. While I think that's a laudable goal in theory, unfortunately

Hackage 2 and acid-state vs traditional databases

2012-09-06 Thread Ian Lynagh
Hi all, I've had a bit of experience with Hackage 2 and acid-state now, and I'm not convinced that it's the best fit for us: * It's slow. It takes about 5 minutes for me to stop and then start the server. It's actually surprising just how slow it is, so it might be possible/easy to get this

Re: Hackage 2 and acid-state vs traditional databases

2012-09-06 Thread Johan Tibell
On Thu, Sep 6, 2012 at 11:49 AM, Ian Lynagh i...@well-typed.com wrote: Someone pointed out that one disadvantage of traditional databases is that they discourage you from writing as if everything was Haskell datastructures in memory. For example, if you have things of type data Foo = Foo {

Re: Hackage 2 and acid-state vs traditional databases

2012-09-06 Thread Erik Hesselink
Hi Ian, We used acid-state (actually happstack-state) at Silk for our session store. We had the same problems you describe: slow shutdown/startup, high memory usage, unable to inspect the data. We recently switched to an SQL database. Just another data point. Erik On Thu, Sep 6, 2012 at 8:49

Re: Hackage 2 and acid-state vs traditional databases

2012-09-06 Thread Duncan Coutts
On 6 September 2012 19:49, Ian Lynagh i...@well-typed.com wrote: Hi all, I've had a bit of experience with Hackage 2 and acid-state now, and I'm not convinced that it's the best fit for us: * It's slow. It takes about 5 minutes for me to stop and then start the server. It's actually

Re: Hackage 2 and acid-state vs traditional databases

2012-09-06 Thread Leon Smith
On Thu, Sep 6, 2012 at 2:49 PM, Ian Lynagh i...@well-typed.com wrote: * Only a single process can use the database at once. For example, if the admins want a tool that will make it easier for them to approve user requests, then that tool needs to be integrated into the Hackage server

Re: Hackage 2 and acid-state vs traditional databases

2012-09-06 Thread Duncan Coutts
On 6 September 2012 21:06, Duncan Coutts duncan.cou...@googlemail.com wrote: On 6 September 2012 19:49, Ian Lynagh i...@well-typed.com wrote: * Only a single process can use the database at once. For example, if the admins want a tool that will make it easier for them to approve user