Re: sql-ledger and MySQL

[Sergio A. K. <ser...@ho...>]

----- 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