Sat 25 Dec 2021

Don't Look Up (2021)

Two low-level astronomers must go on a giant media tour to warn mankind of an approaching comet that will destroy planet Earth.

In the afternoon we watched Don't Look Up. I liked the movie a little and give it a 6 out of 10.

Fast Counting with PostgreSQL and Haskell

Problem: Counting large result sets in PostgreSQL is… slow.

While researching potential solutions to this problem, I learned that PostgreSQL can provide fast counting if you’re willing to sacrifice some accuracy. Whether or not this matters of course depends on the kind of application you’re writing. In my case, I’m fairly certain my users don’t care. Knowing that there are a few million results for a query is more than good enough.

Source: Fast Counting with PostgreSQL and Haskell, an article by Jezen Thomas.