Topics /

Databases & Data

The most popular blog posts about databases & data on Hacker News. 4,224 posts.

Any year
3710

Three Types of Data

In my work I’ve developed a mental framework related to data modeling, which has helped greatly both when coming up with a model and when making decisions down the road about how to use that model. Here I will establish three different categories of data in software: Constants, State, and Cached Values. By “data” I…

3711

Let’s Make a Bubble Map

My previous Let’s Make a Map tutorial describes how to make a basic map with D3 and TopoJSON ; now it’s time to cover thematic mapping in the form of a proportional symbol map. The simplest symbol is a circle, or bubble , whose area is proportional to the associated data. In this tutorial, we’ll make a bubble map of…

3714

Visualizing Time with the Infinity Hour Chart

This is another experiment in visualizing 24-hour cyclical data. My last post explored a method of linear representation (the Double Time Bar Chart). Linear representations have problems when it comes to showing the cyclical nature of time data (ie there is no start or end of a 24 hour cycle). Inspiration When trying…

3716

Fun with SQL: Window Functions in Postgres

Window functions in PostgreSQL are valuable when you want to compare & contrast data between rows. And window functions are key in analytics use cases. This post covers the basic structure of window functions as well as some of the more interesting things you can do with them.