» Home › Forums › Project Discussion › SOPAC ›

DB agnostic? Postgresql?

» Submitted by stompro on Thu, 09/25/2008 - 4:19pm

I'm curious if SOPAC uses MYSQL specific sql/features or if it will work with postgresql? I usually run my drupal sites on postgresql. How about the other components? (I know I should read the fine manuals before posting, I don't have an excuse).
Josh

‹ MyMillennium Congratulations! And... first! ›
Submitted by jblyberg on Thu, 09/25/2008 - 4:25pm.

Josh,
In theory, Locum could work with postgres since it depends on PEAR::MDB2 which is DB agnostic. Though, I can't say with certainty at this point that all of the individual queries would work, since I didn't run them all via MDB2's prepare function. I'd say that that would be something to strive for.

Submitted by jlambertson on Thu, 09/25/2008 - 4:48pm.

Was it insufficient for your needs?

Submitted by jblyberg on Thu, 09/25/2008 - 11:17pm.

No, postgres is a great RDBMS and would work very well. I think the issue is that MySQL is far more ubiquitous and it is more likely that a library would have MySQL expertise in-house than postgres.

Submitted by jlambertson on Fri, 09/26/2008 - 12:52pm.

Sorry, it looks like my comment was cut in half. I was wondering if the drupal database abstraction layer was insufficient for your needs, since the intent is to make all drupal installations db agnostic.

Submitted by jblyberg on Fri, 09/26/2008 - 1:29pm.

Well, in general, I find that the Drupal DB API is a little sparse, especially compared to a full-blown DB class like MDB2. But that's not really germane. Locum and Insurge are software libraries that have nothing to do with Drupal and so wouldn't have the Drupal API available to them.