News for hackers. Stuff that matters.
Re:Ask HN : Use MySQL as a non-relational database by garcara on Friday May 08, 2009 @09:53AM (#599628)
http://bret.appspot.com/entry/how-friendfeed-uses-mysql

This is a really good article that can get you started with this idea. You would have to develop your own solution but a lot of good ideas here.

Re:Ask HN : Use MySQL as a non-relational database by dan_sim on Friday May 08, 2009 @10:02AM (#599638)
Thanks! I was searching for that post and I didn't remember where it was.
Re:Ask HN : Use MySQL as a non-relational database by brown9 on Friday May 08, 2009 @02:22PM (#600019)
very interesting article, thanks
Re:Ask HN : Use MySQL as a non-relational database by mbrubeck on Friday May 08, 2009 @09:43AM (#599606)
It's in Python rather than Ruby, but Infogami's ThingDB and its successor Infobase are distributed key-value stores built on top of PostgreSQL:

http://pharos.infogami.com/tdb

http://openlibrary.org/about/tech

http://infogami.org/src/

Re:Ask HN : Use MySQL as a non-relational database by iamelgringo on Friday May 08, 2009 @11:32AM (#599753)
Are you looking for something like Berkeley DB? It's essentially a persistent key/value store. You don't have sql, but you do have ACID compliant features.

Summery of a programmer's usage here: http://simonwillison.net/2003/Nov/26/discoveringBerkeleyDB/

Some Docs here: http://pybsddb.sourceforge.net/reftoc.html

Re:Ask HN : Use MySQL as a non-relational database by mdragon on Friday May 08, 2009 @09:52AM (#599627)
Python not ruby, but the language on top is a minimal piece in their setup: http://bret.appspot.com/entry/how-friendfeed-uses-mysql
Re:Ask HN : Use MySQL as a non-relational database by adatta02 on Friday May 08, 2009 @11:05AM (#599718)
If you are talking about using MySQL like memcache (so persistence isn't an issue) check out MYISAM MEMORY tables - http://dev.mysql.com/doc/refman/5.0/en/memory-storage-engine...

Super fast but if the server dies so does all your data...

Re:Ask HN : Use MySQL as a non-relational database by shiranaihito on Friday May 08, 2009 @09:30AM (#599588)
Shouldn't you rather use a real non-relational database if that's what you need?
Re:Ask HN : Use MySQL as a non-relational database by dan_sim on Friday May 08, 2009 @09:33AM (#599593)
I knew someone would say that but I'm not ready to install a RDBMS on a production environment yet. Besides that, I'm also just curious if someone did it.