Re: sql-ledger and MySQL

[kevin b. <kev...@bi...>]

hi klavs,

i know its not the answer you want - but databases have a habit of 
growing - and 4 or 5 years down the line when you are responsible for 
possibly dozens of companies accounts you will be glad you chose an ACID 
compliant DB such as postgres,

kev


Sergio A. Kessler wrote:
> ----- Original Message ----- 
> From: "klavs klavsen" <kl...@vs...>
> 
>>Hi everybody,
>>
>>I'm new to sql-ledger - I got pointed to it by my local LUG
>>(www.sslug.dk).
>>
>>I can see it only supports postgres, which is very unfortunate for me,
>>as my only server only has 64mb's of ram, and I'm running mysql (which I
>>use for my PHP) and a lot of other stuff on it already. This is my
>>reasoning for not wanting to embark on postgres ( please no flames :-).
>>
> 
> I'm running postgres on a 32mb machine, and it run well.
> 
> 
>>I found some links describing that it was "only" a specific type of SQl
>>statements that didn't work in MySQL and that it also had something to
>>do with MySQL's lack of transaction support.
>>
> 
> it's not only transaction support, is a lot of things...
> (UNIONs, subselects, JOIN, foreign keys, VIEWs, etc)
> 
> 
>>With the links I found, I could ofcourse just exchange the sql
>>statements as described and my version would probably be up and
>>running.. but I would very much like for whatever change, to be in the
>>main code, so that I wouldn't have to do the whole thing over again when
>>1.8.3 emerges, and so on.
>>
> 
> look, we are talking about money here, you don't want to run
> it in a database that is not ACID compliant, trust me, you don't
> *really* want...
> running a storyboard with mysql is fine, running a system that
> manage money is another thing altogheter...
> 
> hey, what's the problem of learning postgresql ?
> (for me pgsql was easier to learn than mysql, 
> and I aproached pgsql after mysql)
> 
> this book is good for begginers:
> http://www.postgresql.org/docs/aw_pgsql_book/index.html
> 
> /sergio
> 
> 
> 
>