next »

[vsloathe]

Noah certainly thinks so. It's locking a table from a read when he executes a simple SELECT DISTINCT().

I've heard good things lately about postgresql.

[nutballs]

if you change to InnoDB from MyISAM it wont lock on selects.

[kurdt]

Have you checked non relational databases like Voldemort, Redis, CouchDB, etc. lately? I got tired of MySQL and started reading about those. Now I rarely use MySQL at all. It has it's place but more than often I find that key, value or document based databases are way more suitable solution for my uses. It takes some time to switch your mindset to key,value from schemas but it's really worth it.

[nop_90]

If you are from the python world,
ZODB http://zodb.org/ is way to go

If your data is more "reads" then writes
DURUS is way to go http://www.mems-exchange.org/software/durus/

Both are persistent object systems.

Have not tried this one
http://bitbucket.org/neithere/pymodels/wiki/Home
Seems to allow u to store objects in tyrant or other similar dbs

[isthisthingon]

Have you checked non relational databases like Voldemort, Redis, CouchDB, etc. lately? I got tired of MySQL and started reading about those. Now I rarely use MySQL at all. It has it's place but more than often I find that key, value or document based databases are way more suitable solution for my uses. It takes some time to switch your mindset to key,value from schemas but it's really worth it.

I've heard fantastic things about CouchDB. 

[kurdt]

I've heard fantastic things about CouchDB.

Yeah, it's been getting hyped up a lot. It is pretty awesome that you can just PUT JSON there and that's all you need. If you like what you hear about CouchDB, you should check CouchApp thing. It basically app/ideology that if you store views and documents in the database already, why not the whole app. I'm not sure how well it actually works but demos/videos make it look pretty cool. With CouchDB my only worry is security because it's so "young".

You might want to read about how BBC uses CouchDB - "We’ll probably get to 4 billion CouchDB requests tomorrow, 5 March 2010. Not bad for 32 CouchDB nodes running since last summer.".

[kurdt]

I've heard fantastic things about CouchDB.

Correction to what I said above. CouchDB is slow as hell and if you want CouchDB "style" DB but better, check out MongoDB. I really wanted to love CouchDB but after my friend pointed out few benchmarks about CouchDB and I checked out few others, it's just pointless to use it when there's MongoDB which is the same concept but way better done.

[lxp]