search

nhoening / gritttt-rss

Implements 'cancelled' sharing-features of Google Reader for the excellent open-source RSS-Reader TinyTiny-RSS: share any page on the web via a bookmarklet and show your shared items in a widget on any website you want. Also allow to import shared&starred articles from Google Reader.
gritttt-rss.nicolashoening.de
Other
48 stars 4 forks source link

Transaction support #50

Closed nhoening closed 11 years ago

nhoening commented 11 years ago

If one INSERT statement fails for some reason, the previously imported ones should be rolled back. Very useful.

I'm not sure if Postgres and MySQL use the same syntax and since which versions they support it. Expert advice appreciated.

disconn3ct commented 11 years ago

https://dev.mysql.com/doc/refman/5.0/en/commit.html

They both can use "begin;" and "commit;".

nhoening commented 11 years ago

Thanks.

As for versions, it seems transactions in MySQL came with InnoDB, with an acquisition made in 2005 only: In October 2005, Oracle Corporation acquired Innobase OY, the Finnish company that developed the third-party InnoDB storage engine that allows MySQL to provide such functionality as transactions and foreign keys..MySQL 5.0 seems to be stable since 2009, so we can assume everyone has that, I think.

In postgres, I see transaction support back in 8.3 which is also old, from 2008.

Btw, both documentations seem to prefer capital letters. Do both work? Anyway, I'll use capital letters.