Can two different DB types be used simultaneously??

fdgloworm

Okay. I am new to PHP/dynamic web building, but have done quite a bit of html stuff before. I am working on building a website that uses db heavily and needs good searchable capabilities - therefore chose pgsql - but I also need something that can handle user authentication, subscription fees, billing, etc. - and the only help I have found for that is based on mySQL db's. My question is this - is there help/code/program out there that will do this for pgsql? If not, can I run the site with the hardcore on pgsql and the billing/authentication on mysql?

fdgloworm

MarkR

It's an extremely bad idea to use two databases, although it's technically possible.

They're not THAT different from each other anyway, so any code should work.

Plus all new code being written in PHP should really be using a generic database interface. I recommend (in order of preference)
- PDO - built into PHP from 5.1.0 +
- PEAR:😃B - can be installed with the pear installer; some versions ship with PHP
- ADODB (NOT Microsoft ADO!!!) - confusing name, and I've not used it - but some people report success.

Anyone using the database-specific interfaces is just being silly.

Mark

fdgloworm

I thought it was bad to use two different db's, but I'm at a loss. I have found other software available (Profile Manager Premier) that will handle all my subscriber account details, from updating to subscriptions, but it only works with mySQL. I want that capability with pgSQL. Is there anything out there already? If not, is it possible to hand code it? I'm not sure how to handle the subscriptions - with expirations, going through a gateway, etc.

Any ideas? I would rather not use pgsql and mysql, but I'm not sure what else to do.

fdgloworm