1111
Querying Time Series in PostgreSQL
A blog about computer programs, databases, and the future of software development.
New
The latest blog posts to take off on Hacker News. 1,981 posts.
1112
Google Search/Web history disable does nothing for privacy
There seems to be some kind of misunderstanding about the Google Search/Web History disable switch that google provides to its more privacy conscious users. It’s not exactly the most advertised feature (you won’t find it in your profile page) to begin with, but once you do find it (it’s on the history page, you have…
1113
How Apple Cheats
As every iOS developer knows, Apple can do whatever they want with their own native apps, meaning they can and do use private APIs. It’s not too surprising, ...
1114
You shouldn’t use a spreadsheet for important work
I envy economists. Unlike computer scientists, they seem to be able to publish best-seller books with innovative research. One such book is Piketty's Capital. The book is reminiscent of Marx's capital in its scope. If you haven't heard about the book yet, it has a simple message: the yield on capital is higher than…
1115
A Hacker’s Guide to Git
A Hacker’s Guide to Git is now available as an e-book. You can purchase it on Leanpub. Introduction Git is currently the most widely used version control system in the world, mostly thanks to GitHub. By that measure, I’d argue that it’s a...
1116
1117
Build your own drink mixing robot
I built a robot that mixes drinks named Bar Mixvah. It utilizes an Arduino microcontroller switching a series of pumps via transistors on the physical layer, and the MEAN stack (MongoDB, Express.js, Angular.js, Node.js) and jQuery for the frontend and backend. In this post, I’ll teach you how I made it. You can follow…
1118
Running ASP.NET vNext on OS X and Linux
So what is ASP.NET vNext ? Microsoft have recently released a preview of the next iteration of their ASP.NET platform. I’m not going to go into …
1119
The Internet With A Human Face
This is the text version of a talk I gave on May 20, 2014, at Beyond Tellerrand in Düsseldorf, Germany.
1120
1121
The Scroll Up Bar
A design pattern that is currently growing more popular is the fixed position bar at the top of the page. Sometimes the bar stays the same throughout, sometimes the header morphs into a slimmer bar as you scroll down, sometimes a completely new bar appears.
1122
Python 3 is killing Python
The Python community should fork Python 2.
1123
Amazon: malignant monopoly, or just plain evil?
Back to: The myth of heroism | Forward to: A footnote about the publishing industry
1124
Discovery's Teardrop
They are perhaps the most easily recognizable tiles in space shuttle history. For shuttle watchers, when you see them, you know exactly which shuttle you are looking at. Only space shuttles Columbia and Enterprise are more recognizable. The four other shuttles — Challenger, Discovery, Atlantis and Endeavour — aside…
1125
What does a neural network actually do?
There has been a lot of renewed interest lately in neural networks (NNs) due to their popularity as a model for deep learning architectures (there are non-NN based deep learning approaches based on…
1126
Scribd and Quora considered harmful
There are two terrible web properties out there that everyone hates, Scribd and Quora. Please don’t use them. Instead of Scribd just host a PDF anywhere, or upload text to pastebin or make a nice blog on WordPress or Medium or something. And instead of Quora use Ask MetaFilter or StackExchange .
1127
Fraudulent trading activity at Mt. Gox
Somewhere in December 2013, a number of traders including myself began noticing suspicious bot behavior on Mt. Gox. Basically, a random number between 10 and 20 bitcoin would be bought every 5-10 m…
1128
So You Want to Write Your Own CSV code
So You Want To Write Your Own CSV code? Fields separated by commas and rows separated by newline. Easy right? You can write the code yourself in just a few lines.
1129
I Broke My Phone’s Screen, and It Was Awesome
So this past week has been quite a whirlwind — we wrapped up the Novena campaign and smashed all our stretch goals, concluding with over $700k raised , and I got my hair cut in a bar at midnight by none other than the skilled hands of Lenore of Evil Mad Scientist Laboratories ( I blame Jake ! :). It was an…
1130
From Gmail to Fastmail
Email is crucial to me, I can’t even remember the last day I didn’t check my inbox. It’s my preferred channel for communicating and interacting with other people “electronically”. Like many developers I also use emails to keep track of the activity of all the projects I contribute to. I also receive all sorts of…
1131
Fira Sans: a Free, Open Source Typeface Commissioned by Mozilla
As designers in open source, we’re constantly looking for opportunities to bring the principles of universal access and redistribution to new areas. While the term “open source” may still be mainly associated with code, the value in free collaboration benefits every discipline – particularly design.
1132
OS X 10.9.3 Is Toxic
OS X 10.9.3 Recurring Panics
1133
1134
Developer Anxiety, we’re not alone
International Paid Agriculture Exchange Programs2014222 points131 commentsCareer & Management details
CAEP international paid agriculture exchange programs.
1135
Explanation of 44.1 kHz CD sampling rate
The CD sampling rate has to be larger than about 40 kHz to fulfill the Nyquist criterion that requires sampling at twice the maximum analog frequency, which is about 20 kHz for audio. The sampling frequency is chosen somewhat higher than the Nyquist rate since practical filters neede to prevent aliasing have a finite…
1136
Weak Men Are Superweapons
I. There was an argument on Tumblr which, like so many arguments on Tumblr, was terrible. I will rephrase it just a little to make a point. Alice said something along the lines of “I hate peo…
1137
It's Time to Kill Surface
“The question that needs to be asked and answered is why hardware.” To Satya Nadella’s credit, he provided not just the answer, but the question as well. And, looked at narrowly, …
1138
A Tour of Machine Learning Algorithms
Tour of Machine Learning Algorithms: Learn all about the most popular machine learning algorithms.
1139
Why I Am Not An Integrated Information Theorist (or, The Unconscious Expander)
Happy birthday to me! Recently, lots of people have been asking me what I think about IIT—no, not the Indian Institutes of Technology, but Integrated Information Theory, a widely-discussed &#…
1140