[MTOS-dev] No transactions in MT / Data::ObjectDriver?

[Hirotaka Ogawa]

On Sun, Mar 2, 2008 at 4:49 AM, Alvar Freude <alvar at a-blast.org> wrote:
> Hi,
>
>
>  -- Hirotaka Ogawa <hirotaka.ogawa at gmail.com> wrote:
>
>  > Correct.  I think the reason is:
>  >
>  >  - Simplicity; (We just believe) any operations on MT::Object should
>  > be atomic as well as uniform.  That is, each MT::Object operations
>  > consists of single transaction section, and any MT::Objects, e.g.
>  > MT::Entry and MT::Session, have exactly same semantics on each
>  > operations.
>
>  In the meantime I have thrown a look at the SQL queries for adding an
>  entry for a blog. There are a lot of INSERTs for each entry and it is
>  obvious that everything of this should be done atomic inside one
>  transaction, otherwise it is easy possible to get a corrupt database.
>
>  In Addition: Because there are no foreign key constraints (e.g.
>  references) there are more possibilities to lose data integrity.
>
>
>  The result is, that MT can not guarantee anything from ACID.
>
>   <http://en.wikipedia.org/wiki/ACID>

I knew.  You asked the reason, so I replied just one of possible
answers.  I think the current implementation is not enough, too.

So, how do you define the transaction section being consistent with
current MT::Object APIs?  And how will you implement?

>  >  - Availability; InnoDB is not always available for users, unlike
>  > MyISAM, because of historical reason.
>
>  I think, it is no good idea to force everyone to be limited to a flat
>  file with SQL frontend like MyISAM.
>
>  What about using the features of a real RDBMS and fewer with MySQL/MyISAM?
>
>
>
>  > As you wrote, we can employ InnoDB and make transaction sections much
>  > larger, for example, each requests is served as a single transaction.
>
>  The same for PostgreSQL, which is usually faster and more secure then
>  MySQL.
>
>
>
>
>  Ciao
>   Alvar
>
>
>  --
>  ** Alvar C.H. Freude, http://alvar.a-blast.org/
>  ** http://www.assoziations-blaster.de/
>  ** http://www.wen-waehlen.de/
>  ** http://odem.org/
>



-- 
Hirotaka Ogawa makes no sense.
http://as-is.net/blog/