Not logged in
Log in now
Create an account
Subscribe to LWN
LWN.net Weekly Edition for May 16, 2013
A look at the PyPy 2.0 release
PostgreSQL 9.3 beta: Federated databases and more
LWN.net Weekly Edition for May 9, 2013
(Nearly) full tickless operation in 3.10
Or, if you always store a new value whenever the friends list changes, then you could just do that with memcached, redis, etc. I'm not seeing the difference.
Other than being built into Postgres, of course. That's nice, but given how easy memcached and redis are to set up, not a big deal.
PostgreSQL 9.0 arrives with many new features
Posted Sep 24, 2010 18:06 UTC (Fri) by dmag (subscriber, #17775)
Yes, but with "HStore as a cache", you can do your cache updates in a transaction. The biggest problem with external caching is keeping them in sync. (To keep it in perfect sync, you'd need to build your own 2-phase commit.)
I can also imagine non-cache uses. For example, "has this user seen this announcement?". Seems silly to create a new table for that.
HStore is just "one more tool in the toolbox". The future of data is all about "picking the right tool", which requires knowing the engineering tradeoffs. (Actually, today it's more like "figuring out the engineering tradeoffs", but it will get easier.)
Copyright © 2013, Eklektix, Inc.
Comments and public postings are copyrighted by their creators.
Linux is a registered trademark of Linus Torvalds