[Erp5-dev] How to make ERP5 work with PostgreSQL?

[bartek]

Jean-Paul Smets wrote:
> Jacek Medrzycki a écrit :
>> Duk Liu pisze:
>>> Hi all
>>> I wanna make ERP5 work with PostgreSQL instead of MySQL.
>>> Which module I should modify?
>>> Is there any entry talk about it I should reference?
>>> Is there anybody done it before?
>>> I have to finish it before next week, can I?
>>>
>> I think You should make a Business Template similar to
>> erp5_mysql_innodb_catalog, but working with psql.
> If someone made erp5_pgsql_catalog, it would be nice.
>> As far as I know, there is no such bt in public repository. Correct me
>> if I'm wrong.
>>
> 
> Some people decided to use PostgreSQL instead of MySQL but sadly, they
> never contributed anything public.
> Please note that when we measured PostgreSQL in the ERP5 context, we
> found that inserts were nearly 10 times slower than MySQL inserts (maybe
> in other contexts, PostgreSQL is better).
> 

So, all it takes is a rewrite of all methods in portal_catalog so that 
they comply with particularities of the Postgres syntax? Sounds ok. If 
all the z-methods which are in the skins are ok then it seems quite 
feasible.

I have a prospect client who is a Postgres fanatic, and not using 
postgresql is a deal-breaker, don't ask me why :)

Bartek

> Regards,
> 
> JPS.
>> J.
>> _______________________________________________
>> Erp5-dev mailing list
>> Erp5-dev at erp5.org
>> http://erp5.org/mailman/listinfo/erp5-dev
> 
> _______________________________________________
> Erp5-dev mailing list
> Erp5-dev at erp5.org
> http://erp5.org/mailman/listinfo/erp5-dev
> 


-- 
"feelings affect productivity. (...) unhappy people write worse 
software, and less of it."
Karl Fogel, "Producing Open Source Software"