Oct 11

Transaction Isolation Levels

Database 4,030 Comments »
What’ll happen when multiple database transactions are reading/writing records at the same time. Will their operations be strictly serialized by using locks, or just work on the same data copy without any sync restiction?
The answer is: that depends on the transaction isolation level we use. ANSI defines 4 isolation leves (from fatest to safest):
  • Serializable
  • Repeatable Read
  • Read Commited
  • Read Uncommited

There’s a wiki page (http://en.wikipedia.org/wiki/Isolation_(database_systems) explains the isolation levels in detail, with intuitive examples.

Tagged with:
Oct 11

Testing Tomboy BlogPoster

General 3,016 Comments »
“Tomboy Blogposter is a Tomboy plugin to post notes to a blog from for instance Wordpress, Blogger or LiveJournal, or (hopefully) any other AtomPub enabled website.”

Note:
1. Don’t forget to firstly enable the plugin and config the preference
2. For WordPress, the URL you want to config is <blog_url>/wp-app.php/posts, and don’t miss the https:// prefix in <blog_url>
3. For Blogger or LiveJournal, reader the author’s blog post to find out how to config the URL.

The author’s blog post:
http://flukkost.nu/blog/tomboyblogposter/

Tagged with: •
preload preload preload