31
Log-log plot of new vs. total Covid-19 cases by country
Visualizing the exponential growth of COVID-19 across the world.
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 116 posts.
32
Comprehensive Tutorial on Time Series Modelling and Forecasting
In the previous post we have seen how to visualize a time series data. In this post we will discuss how to do a time series modelling using ARMA and ARIMA models. Here AR stands for Auto-Regressive and MA stands for Moving Average
33
Analysis of compensation, level, and experience details of 19k tech workers
[Twitter thread, Hacker News discussion, Reddit discussion]
34
Thinking Psycopg3
Sponsoring this project will help achieve swift completion and ensure the maintenance of psycopg2, psycopg3 and other related projects.
35
Millions of Tiny Databases
Millions of tiny databases, Brooker et al., NSDI’20 This paper is a real joy to read. It takes you through the thinking processes and engineering practices behind the design of a key part of …
36
Python For Feature Film
A look into how Python is used to bring your favorite movies to the big screen.
37
Simdjson 0.3: Faster JSON parser
Last year (2019), we released the simjson library. It is a C++ library available under a liberal license (Apache) that can parse JSON documents very fast. How fast? We reach and exceed 3 gigabytes per second in many instances. It can also parse millions of small JSON documents per second. The new version is much ……
38
PostgreSQL beginner guide
It looks like nothing was found at this location. May be please check the URL for typing errors or start a new search to find the page you are looking for.
39
Illustrated FixMatch for semi-supervised learning
Learn how to leverage unlabeled data using FixMatch for semi-supervised learning
40
41
Guide to Making 3D Maps with Satellite Imagery in R
E ver since I released rayshader to the public, there’s been one question that comes up time and time again: “How do I use rayshader to overlay satellite imagery onto a 3D surface?” And I can see why: 3D maps with real satellite images are super cool, and there are few detailed tutorials out there on how it’s done in…
42
Problems with Japan's Covid-19 reports
The Japanese government seems incapable of getting their act together so that they can provide meaningful data to the public.
43
Visual Introduction to Self Supervised Learning
A visual introduction to self-supervised learning methods for visual representations.
44
Using SQL to find my best photo of a pelican according to Apple Photos
According to the Apple Photos internal SQLite database, this is the most aesthetically pleasing photograph I have ever taken of a pelican: Here’s the SQL query that found me my …
45
The largest city in each 10x10 degree latitude/longitude box
From the highly eclectic blog of Mark Dominus
46
Let’s implement a Bloom Filter
I am planning to create a series of blog posts that includes some literature research, implementation of various data structures and our journey of creating a distributed datastore in distrentic.io.
47
Looking for Voter Fraud (In Old Elections) with Data Visualization
The 2020 US election is finally over, and all the election excitement of the last week reminded me of something I had been meaning to look into: Sergey Shpilkin’s data visualizations that cle…
48
1.1B Taxi Rides Using OmniSciDB and a MacBook Pro
Benchmarks & Tips for Big Data, Hadoop, AWS, Google Cloud, PostgreSQL, Spark, Python & More...
49
Loading CSV File at the Speed Limit of the NVMe Storage
I plan to write a series of articles to discuss some simple but not embarrassingly parallel algorithms. These will have practical usages and would most likely be on many-core CPUs or CUDA GPUs. Today’s is the first one to discuss a parallel algorithm implementation for CSV file parser.
50
51
52
13% of my website visitors block Google Analytics
There’s widespread use of adblockers on the web but users are increasingly blocking cookies and other tracking scripts too. Browsers such as Safari, Firefox and Brave are privacy-focused.
53
Reverse-engineering the problematic tail behavior of Fivethirtyeight forecast
We’ve been writing a bit about some odd tail behavior in the Fivethirtyeight election forecast, for example that it was giving Joe Biden a 3% chance of winning Alabama (which seemed high), it was displaying Trump winning California as in “the range of scenarios our model thinks is possible” (which didn’t seem right)…
54
55
Improved vacuum in PostgreSQL 13
Vacuum is one of the sub-systems in PostgreSQL which gets improved with each release. I have checked past five releases and each has qu...
56
57
The surprising impact of medium-size texts on PostgreSQL performance
Why TOAST is the best thing since sliced bread
58
Oracle vs. PostgreSQL: First Glance
We are facing some interesting times at work as we are going to start changing our technology stack in the near future. Most of our Oracle ...
59
If All You Have Is a Database, Everything Looks Like a Nail
Databases are fabulous resources. Of course, we’ll abuse them in ways that cause challenges.
60
GoodJob – a Postgres-based ActiveJob back end for Ruby on Rails
GoodJob is a new Postgres-based, multithreaded, second-generation ActiveJob backend for Ruby on Rails.