News:

AbanteCart v1.4.2 is released.

Main Menu
support

Relational Database and transactions

Started by abantecart, January 07, 2012, 10:38:48 AM

Previous topic - Next topic

Do you think optional support of Relational Databse and Transactions will be popular?

Yes
3 (100%)
No
0 (0%)
Not sure
0 (0%)
Not my concern
0 (0%)

Total Members Voted: 3

Voting closed: April 06, 2012, 11:38:48 AM

abantecart

We think this is important to improve data integrity, performance on a larger scale.

Benefit: True relational database, data integrity, performance, benefit of transactions and roll back.

Disadvantage: Not supported by all hosting companies.

Feel free to post more.
Please  rate your experience or leave your review
We need your help to build better free open source ecommerce platform for everyone. See how you can help

Palamedes

I would assume that most major users of this product will likely have a slice or their own collocation and thus completely control over the backend..  I guess it comes down to which market segment you're aiming this product for..
~Pal

TopEcommerce

Any issues with hosts not allowing transactions?

Palamedes

It's less about the hosts and more about the databases they support..

If your hosts MySQL has the InnoDB (or BDB) engine then you have transaction support.. if you only have MyISAM as the db backend for your mysql install,  then you don't. 

It looks like right now AbanteCart installs by default as MyISAM which means no transactions.. (or foreign keys)
~Pal

abantecart

We have started to create relational and transactional InnoDB database at first, but researched showed that hosting mostly support MyISAM. This would be a problem.

We will watch future direction.
Please  rate your experience or leave your review
We need your help to build better free open source ecommerce platform for everyone. See how you can help

Nimitz1061

Quote from: abantecart on March 09, 2012, 11:58:50 AM
We have started to create relational and transactional InnoDB database at first, but researched showed that hosting mostly support MyISAM. This would be a problem.

We will watch future direction.

I would suspect that your research is flawed in some way.

InnoDB has been the default engine since at least MySQL 5.0 was released, thus transactional support should be available to any host using up to date installations.  Anyone who is not should not be considered a viable host for any ecommerce applications.

Transactions should be placed in use as soon as it is practical to do so.

David



Forum Rules Code of conduct
AbanteCart.com 2010 -