XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. Xoops Development / 
  3. Feature Request 
  4.  / MySQL transactions
Register
1
kerkyra
MySQL transactions

  • 2008/10/16 9:14

  • kerkyra

  • Just can't stay away

  • Posts: 553

  • Since: 2005/2/14


hi, do you think MySQL transactions would be a good addition in the core of xoops? I know that in order for the transactions to work the db type should be InnoDB but i dont know what kind of implications would come with that...I haven't worked with MySQL transactions so far but seem to be quite a safe way to manipulate data in the db...your comments?
www.guidemap.gr - Beta is out...
2
ghia
Re: MySQL transactions

  • 2008/10/16 22:58

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


Transactions are at their best when complex database operations that involves many changements in different tables need to be atomised. Or all pass or no one. It prevents that updates are only partly done in eg a ledger system to avoid unbalancing, where always two accounts has to be modified, one to credit and one to debit.

I know some modules use it, but I assume that XOOPS itself doesn't need it, because it runs already for years without problems on ISAM.
3
kerkyra
Re: MySQL transactions

  • 2008/10/17 8:47

  • kerkyra

  • Just can't stay away

  • Posts: 553

  • Since: 2005/2/14


thanks for the reply mate!

So if someone needs to use transactions in a module it is possible with XOOPS no matter if the main tables run on ISAM? I mean, if i wanted to make a module with an innoDB database would transactions work? I reall dont have something in mind, :) I just found out about transactions in php a few days ago, I did a little research and just wanted to know if this could work with a XOOPS module and if there are any implications with the rest of the XOOPS core code or db.

cheers
www.guidemap.gr - Beta is out...
4
ghia
Re: MySQL transactions

  • 2008/10/17 12:14

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


MediaWiki is an example of a module using InnoDB, but I'm not aware to which extend.
5
phppp
Re: MySQL transactions

  • 2008/10/27 3:04

  • phppp

  • XOOPS Contributor

  • Posts: 2857

  • Since: 2004/1/25


Implemented in 3.0
6
kerkyra
Re: MySQL transactions

  • 2008/10/28 11:29

  • kerkyra

  • Just can't stay away

  • Posts: 553

  • Since: 2005/2/14


thats good news :) looking forward to it!
www.guidemap.gr - Beta is out...

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

229 user(s) are online (151 user(s) are browsing Support Forums)

Members: 0

Guests: 229

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Apr 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits