Malicious enjoyment derived from observing someone else’s misfortune
 

Tag Archives: databases

Reading compressed files with postgres using named pipes

Postgres has the same type of ability MySQL has to read in files, yet much nicer syntax. LOAD DATA INFILE from MySQL is just COPY in postgres. I decided to try having it read from a named pipe today, and it worked out nicely.

Pitfalls with digital health records

The more I hear about digital national health records, the more I worry about them with regards to security. Various interpretations of the new legislation in the 2009 Stimulus bill could mean anything from implementing something like SAFEHealth, a decentralized system, to something like Google Health, which would centralize medical records. I expect that a decentralized system will not be what the government will choose. Proper usage of a decentralized system would be fine, but removes a lot of the [...]

OSCON Sessions, Day 1

I went to 5 sessions today, and I was pleasantly surprised by most of them. CouchDB CouchDB is a distributed non-relational database written in Erlang. It is unique in that its main query interface is simply HTTP REST, and for every UPDATE, it simply creates a new version of the row. Additionally, you can request the entire history of a row very simply. Hypertable An open-source implementation of Google’s bigtable. Hypertable uses novel methods such as Bloom filters to significantly [...]