[Vtigercrm-developers] postgres support in v5

[Dhr. R.R. Gerbrands]

Hi Jeff,

I agree with you, giving more people a choice which db to use at the start
of implementing VtigerCRM highlites the best part of using OpenSource.
Having implemented VtigerCRM at several clients of mine on a online
webserver works fine.
Being able to use a different db backend for integration with others apps
would be great.
Just to make it clear I need both databases for this: mysql and postgressql.
If at some point we would be able to use firebird as well, well that will be
the day for me :-)

Regards,

Remco Gerbrands




-----Oorspronkelijk bericht-----
Van: vtigercrm-developers-bounces at lists.vtigercrm.com
[mailto:vtigercrm-developers-bounces at lists.vtigercrm.com]Namens Jeff
Kowalczyk
Verzonden: dinsdag 25 april 2006 4:41
Aan: vtigercrm-developers at lists.vtigercrm.com
Onderwerp: Re: [Vtigercrm-developers] postgres support in v5


Richie wrote:
> I would like to know your views on supporting Postgres in vtiger CRM 5
> GA please.

I think there is consensus that postgresql support is important and that
someone would step up to provide it. Alternatives to mysql for different
reasons to different people: licensing, stability, management utilities,
integration with other apps already in other backends, etc.

But I'll suggest one reason that makes it an imperative to merge
postgresql support, as in right now, before tagging vtigercrm-5.0.0beta1:

   There is likely to be no reliable support for an end-user to migrate to
   another database backend once you start using vtigercrm in production.

Consider: is anyone preparing adodb migration code, or suggesting we rely
on mysql<->postgresql dumpfile translators, for something as complex as a
vtigercrm dataset that's been used in production on Mysql for several
months. How many relational tables is vtigercrm now?

Even if it can be coaxed from one dumpfile format to another, we don't
have automated testing to tell for certain if the data integrity is
preserved. One could conceivably go quite a while before noticing anything
wrong with a converted dataset.

I think that a sensible user will choose the database backend they prefer
at the beginning of a deployment, and stick with it. Therefore, vtigercrm
needs to support more backends sooner rather than later.

_______________________________________________
This vtiger.com email is sponsored by Zoho Planner. Still scribbling down
your To-Do's on bits of paper & palms of your hands? Try the AJAX enabled,
personal organizer online, Zoho Planner for FREE instead!
http://zohoplanner.com/?vt

----- Scanned for virus and spam