Adam Blomberg <[EMAIL PROTECTED]> said:
> Hi,
>
> I've recently upgraded from 1.2.5 to 1.4, and it works great. Now, I would
> like to use Midgard at another site, where we are currently using PostgreSQL
> as our database backend. My question is simple, would it be feasible to
> patch Midgard so that it uses PostgreSQL instead of MySQL? I realise that
> any porting to PostgreSQL would include some hacking, but would it be
> extensive? On a side note, I think I've read somewhere that 2.0 will include
> a database abstraction layer, but unfortunately this particular project
> can't wait for that release.
>
> Thanks,
>
> // Adam
My guess at this, looking at other similar projects, and knowing a little bit
about the code......
most of the database calls are reasonably centrally located in the libmidgard,
(I think just midgard.c & 1 call in repligard.c)
a straight port of the Capi calls would probably be a matter of hours/days...
the difficulty may be in tracking down the incompatible SQL calls. - last time
I tried Postgres for coding it broke on
select * from article where id='12'; <- where the number is quoted...
other than that, some of the more complex date operations may be problematic -
but not a totally impossible task..
regards
alan
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
>
--
Technical Director
Linux Center (HK) Ltd.
www.hklc.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
