PostgreSQL as a key-value store

Posted by Peter J. Jones on

I just read an interesting article about using PostgreSQL as a key-value store using the hstore module:

Yes I know you are really happy with your “persistent” Key Value store. But did anybody notice hstore that comes along Postgresql. I find Postgresql to be a really great RDBMS that has been ignored all the time.

Okay, maybe the English in this article isn’t that great, but if you haven’t looked into hstore before it might spark your interest.

About the Author

Peter J. Jones has been a professional software engineer for over 20 years and is deeply passionate about helping programmers improve the skills of their craft. He is the author of Effective Ruby: 48 Specific Ways to Write Better Ruby. Peter can be reached through our contact page or his twitter account.