News:

AbanteCart v1.4.2 is released.

Main Menu

Do you like AbanteCart? Please rate AbanteCart or share your experience with other eCommerce entrepreneurs. Go to Softaculous rating page to add your rating or write a review

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.

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..

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)

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.

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 -