The Cache: Technology Expert's Forum
 
*
Welcome, Guest. Please login or register. September 23, 2019, 01:50:21 AM

Login with username, password and session length


Pages: [1]
  Print  
Author Topic: Time to Kick MySQL to the Curb?  (Read 4032 times)
vsloathe
vim ftw!
Global Moderator
Lifer
*****
Offline Offline

Posts: 1669



View Profile
« on: March 08, 2010, 10:58:20 AM »

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.
Logged

hai
nutballs
Administrator
Lifer
*****
Offline Offline

Posts: 5627


Back in my day we had 9 planets


View Profile
« Reply #1 on: March 08, 2010, 11:09:58 AM »

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

I could eat a bowl of Alphabet Soup and shit a better argument than that.
kurdt
Lifer
*****
Offline Offline

Posts: 1153


paha arkkitehti


View Profile
« Reply #2 on: March 09, 2010, 11:07:33 AM »

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.
Logged

I met god and he had nothing to say to me.
nop_90
Global Moderator
Lifer
*****
Offline Offline

Posts: 2203


View Profile
« Reply #3 on: March 09, 2010, 03:42:42 PM »

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
« Last Edit: March 09, 2010, 03:50:03 PM by nop_90 » Logged
isthisthingon
Global Moderator
Lifer
*****
Offline Offline

Posts: 2879



View Profile
« Reply #4 on: March 09, 2010, 04:20:55 PM »

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. 
Logged

I would love to change the world, but they won't give me the source code.
kurdt
Lifer
*****
Offline Offline

Posts: 1153


paha arkkitehti


View Profile
« Reply #5 on: March 09, 2010, 10:45:50 PM »

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.".
Logged

I met god and he had nothing to say to me.
kurdt
Lifer
*****
Offline Offline

Posts: 1153


paha arkkitehti


View Profile
« Reply #6 on: March 31, 2010, 10:50:48 PM »

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.
Logged

I met god and he had nothing to say to me.
lxp
n00b
*
Offline Offline

Posts: 9


View Profile
« Reply #7 on: October 24, 2010, 07:47:54 PM »

 Huh?
Logged

Banned by the precrime unit.
Pages: [1]
  Print  
 
Jump to:  

Perkiset's Place Home   Best of The Cache   phpMyIDE: MySQL Stored Procedures, Functions & Triggers
Politics @ Perkiset's   Pinkhat's Perspective   
cache
mart
coder
programmers
ajax
php
javascript
Powered by MySQL Powered by PHP Powered by SMF 1.1.2 | SMF © 2006-2007, Simple Machines LLC
Seo4Smf v0.2 © Webmaster's Talks


Valid XHTML 1.0! Valid CSS!