Poll

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

Author Topic: Relational Database and transactions  (Read 8926 times)

Offline abantecart

  • Administrator
  • Hero Member
  • *****
  • Posts: 3968
  • Karma: +243/-9
    • View Profile
    • Ideal Open Source Ecommerce Solution
Relational Database and transactions
« on: January 07, 2012, 10:38:48 AM »
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.
We need your help to build better free open source eCommerce platform for everyone.
See how you can help

Offline Palamedes

  • Newbie
  • *
  • Posts: 36
  • Karma: +5/-0
    • View Profile
    • RandomStringOfWords
Re: Relational Database and transactions
« Reply #1 on: March 06, 2012, 10:34:02 PM »
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

Offline TopEcommerce

  • Newbie
  • *
  • Posts: 6
  • Karma: +0/-0
    • View Profile
Re: Relational Database and transactions
« Reply #2 on: March 08, 2012, 09:01:21 AM »
Any issues with hosts not allowing transactions?

Offline Palamedes

  • Newbie
  • *
  • Posts: 36
  • Karma: +5/-0
    • View Profile
    • RandomStringOfWords
Re: Relational Database and transactions
« Reply #3 on: March 08, 2012, 06:59:28 PM »
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

Offline abantecart

  • Administrator
  • Hero Member
  • *****
  • Posts: 3968
  • Karma: +243/-9
    • View Profile
    • Ideal Open Source Ecommerce Solution
Re: Relational Database and transactions
« Reply #4 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.
We need your help to build better free open source eCommerce platform for everyone.
See how you can help

Offline Nimitz1061

  • Full Member
  • ***
  • Posts: 190
  • Karma: +21/-0
  • No matter where you go, there you are...
    • View Profile
Re: Relational Database and transactions
« Reply #5 on: July 06, 2012, 10:53:43 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