mySQL or PostgreSQL for E-commerce

Anon

I im currently workin on an E-commerce site, and im not sure what SQL should i use, i know that Postgre supports transactions, but on the other hand i like mySQL and i know it inside out, upside down, and right to left...

what should i do ?

Thanx

David Elrom

Anon

When money is involved you want a real database. I'd go with Postgre.

kparker

Go with PostgreSQL. The sql itself isn't that different, except of course for all those places that pg supports that sql standard (sub-selects, etc.)

toma42

I also would recommend postgresql but mostly because it supports transactions....a very important thing when it comes to money transacitons and databases.

The referential integrity is a huge plus too.

Anon

Thanx alot guys, looks like ill be using Postgre 🙂

Hey Tom (sound like u know what you're talking about)
i have no problem at all building the shopping cart, or the product DB, how would i implement the transaction into php/postgre (how would i connect to the merchant acount ?)

toma42

The SQL to start a transaction is 'Begin Transaction;' I believe. Just do that, do your queries...then 'commit;' or 'rollback;', depending on whether you had errors or not.

I don't know what you mean by a merchant account. If you mean credit card stuff...that's not my bag, baby! 🙂

Anon

Thats all very nice, but what will i gain from that?

i need to bill someone's credit card via the merchant acount...

help me PPL ! 😐

Anon

kparker

Ah. Don't confuse the dbms term "transaction processing" (which has to do with grouping an number of inserts/updates into a single "transaction" so that the database is not actually updated unless all the individual inserts/updates are able to be carried out, thus ensuring database integrity) with the "transaction" involved in processing credit cards. For that, look at cybercash, payflow (now part of verisign) etc.