172 reputation
15
bio website
location
age
visits member for 1 year, 10 months
seen May 8 '13 at 2:16

Jun
25
awarded  Popular Question
Feb
21
awarded  Notable Question
Jun
24
awarded  Popular Question
May
7
asked Do I need to use NVARCHAR rather than VARCHAR to properly store UTF8 characters in Oracle?
Apr
24
comment How to snapshot or version a relational database when data changes?
Want the answer to be database agnostic for the major relational databases -- mysql, postgres, oracle. I use several databases that all need to do this
Apr
23
asked How to snapshot or version a relational database when data changes?
Nov
19
awarded  Scholar
Nov
19
awarded  Supporter
Nov
19
comment How to correctly implement optimistic locking in MySQL
Thanks Craig. You were correct-- the developer was mistaken. Thanks for running this test.
Nov
19
accepted How to correctly implement optimistic locking in MySQL
Nov
18
comment Do isolation levels only apply to SELECTS and not UPDATES?
@CraigRinger Thanks for the info on how to flag the post
Nov
18
comment Do isolation levels only apply to SELECTS and not UPDATES?
It didnt appear I could move my post from SO over to this site. Can you please move the post from stack overflow over to this site? It seems as though it would get a better answer on the dba-specific site versus stack overflow.
Nov
18
comment Do isolation levels only apply to SELECTS and not UPDATES?
It would seem like a straight forward question that someone on dba.stackexchange.com could easily/quickly answer based on their knowledge an experience.
Nov
17
asked How does one correctly implement optimistic locking in MySQL?
Nov
17
awarded  Student
Nov
17
asked Do isolation levels only apply to SELECTS and not UPDATES?
Nov
17
comment How to correctly implement optimistic locking in MySQL
Indications are that one would want to do a select for update in order to deal with this situation: dev.mysql.com/doc/refman/5.0/en/innodb-consistent-read.html
Nov
17
comment How to correctly implement optimistic locking in MySQL
Are you certain? Its unclear that unless you set the transaction isolation level to a specific setting that you would actually see the other threads update. If you both enter the transaction at the same time, the second thread can very well see the OLD data when it goes to do the update. MySQL is not as robust in the ACID arena as say Oracle, hence looking for the best practices way to implement optimistic locking in MySQL that will prevent dirty reads/updates.
Nov
16
asked How to correctly implement optimistic locking in MySQL