network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 6 months |
| seen | May 8 at 2:16 | |
| stats | profile views | 7 |
|
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 |
