The Most Weird Thing Ever

This is the most weird thing I’ve ever found. I’m not sure I will find a more weird one.

A music album. Full of music. To listen you just need to compile it as a kernel module. Then you will have a new device you can read the music from.

PostgreSQL Backend Flowchart

Databases seem to be treated like huge complicated black boxes where you throw data and have no idea how to get it back.

The real world database are pretty simple. These are just programs which parse queries, read some data from files, change the data and save it back.

How Computer Memory Prices Changed

I found quite a nice data about memory prices. Just imagine 1MB of RAM changed from $411M in 1957, to $0.0073 in 2014. The data is here.

Speeding Up Generating Data in Postgres

I had this stupid idea for quite a long time. PostgreSQL has the COPY command. It is really fast and it is the best way to load CSV like file to the database. So I had an idea: what about not creating an SQL query from an ORM object, but instead generate a CSV file and load it using the COPY?