Re: Shopping cart

On Wed, 22 Oct 2008 15:42:48 +0300
"Andrus" <kobruleht2(at)hot(dot)ee> wrote:

> > I think that anyway most of the popular prepackaged solutions
> > don't support transactions in the DB.

> Probably I do'nt need transactions.

You don't need transactions as much as you don't need a database
since you can work on flat file... but they are definitively comfort
when you've to keep your data coherent.

eg. what if a customer changes its order while it is closing it?

Surely you could add constraints and checks in your application...
but the DB seems a better place where to check if the data you're
storing are coherent.

As up to my knowledge Ubercart uses the workflow module to check
"constraints", but it doesn't exploit the features of the DB.

I'd say that a drupal cart will "mostly" work with PostgreSQL and
the changes you'll have to do to make it works may be minimal... but
somehow core is more DB friendly than most modules so you may have
some surprises.

Still no popular Free cart I know rely on DB coherency features
especially the ones written in PHP.

--
Ivan Sergio Borgonovo
http://www.webthatworks.it