“The world is not yet finished, but everyone is behaving as if everything was known. This is not true. In fact, the computer world as we know it is based upon one tradition that has been waddling along for the last fifty years, growing in size and ungainliness, and is essentially defining the way we do everything. My view is that today’s computer world is based on techie misunderstandings of human thought and human life. And the imposition of inappropriate structures throughout the computer is the imposition of inappropriate structures on the things we want to do in the human world.”—Ted Nelson (via brianlucid)
PostgreSQL 9.4 will be reintroducing Hstore as the column type of choice for document-style data. This supersedes PostgreSQL’s JSON support which was introduced in version 9.0. Being a string-based…
hstore is a four letter word in these parts.
if you use the hstore column with anything other than a relatively small, well-defined schema, you hit a hard wall somewhere between 500,000 records and 20-90 million records (i suspect the wall is closer to the 500k (the usual benchmarking recordset) but that mark was well before my time on this particular database). indexing is also problematic - gin/gist/btree didn’t matter, the index size (50GB!) of the one table was almost triple the size of the entire database.
we still use hstores, but not for anything that involves searching them and not for anything where the set of potential keys is more than a handful.
“Jackson and I love designing in the browser. A lot. But we want to love it more. As css authors and designers, when we step into a codebase, we have a lot of questions. And they can be time consuming to get answers to. We don’t believe that should be the case because it’s 2013 and we have computers.”—
“A computer is a stupid machine with the ability to do incredibly smart things, while computer programmers are smart people with the ability to do incredibly stupid things. They are, in short, a perfect match.”—Bill Bryson (via floatingalongasamelodycomes)