I need record level locking in a database, and I need it quickly, without having a huge learning curve or added cost of administration. What do folks out there recommend. Does Postgres allow record level locking? I am on a linux platform, and refuse to use any MS products, so don't go there. Additionally, I need to be able to easily export database content as both SQL statements and in some sort of delimited text file format. I can do the latter with Zope, of course, but it is fairly slow and expensive. MySQL does all of that nicely, but doesn't have record level locking. Please respond to me as well as the list. --sam -- Sam Gendler Chief Technology Officer - Impossible, Inc. 1222 State St. Suite 250 Santa Barbara CA. 93101 w: 805-560-0508 f: 805-560-0608 c: 805-689-1191 e: sgendler@impossible.com
Sam Gendler writes:
I need record level locking in a database, and I need it quickly, without having a huge learning curve or added cost of administration. What do folks out there recommend. Does Postgres allow record level locking?
Yep. In fact it goes quite a bit further: http://www.postgresql.org/docs/user/mvcc.htm
I am on a linux platform, and refuse to use any MS products, so don't go there.
It uses a BSD license so it's even more libre/lucre free than MySQL.
Additionally, I need to be able to easily export database content as both SQL statements and in some sort of delimited text file format.
Er... do you mean ' I need to be able to easily export database content using both SQL statements and dumping to some sort of delimited text file format.'?
I can do the latter with Zope, of course, but it is fairly slow and expensive. MySQL does all of that nicely, but doesn't have record level locking.
Or transactions, or constraits beyond NOT NULL and UNIQUE, or triggers or rules, or arrays or a dozen other things you'll wonder how you ever did without when you where using MySQL :-) John.
On Sun, 5 Mar 2000, Sam Gendler wrote:
Does Postgres allow record level locking?
Yes, it is called MVCC - MultiVersion Concurrency Control. Oleg. ---- Oleg Broytmann Foundation for Effective Policies phd@phd.russ.ru Programmers don't die, they just GOSUB without RETURN.
participants (3)
-
John Morton -
Oleg Broytmann -
Sam Gendler