1
Ditching Excel for Python in a legacy industry
I spent 3 years as an analyst in the reinsurance industry. During this time, I witnessed firsthand how Python is driving rapid technological change. (Goodbye, Excel!)
New
The latest blog posts to take off on Hacker News. 116 posts.
2
Google Maps' Moat Is Evaporating
The views expressed in this newsletter are solely my own, and do not represent the views of my employer.
3
Target didn’t figure out a teen girl was pregnant before her father did
And that one article that said they did was silly and bad
4
Common Problems in Financial Services Reconciliation
Common problems in financial recon, for fintechs, particularly those building deposit products and managing their own ledger.
5
ZFS: Use mirror vdevs, not RAIDZ
Continuing this week’s “making an article so I don’t have to keep typing it” ZFS series… here’s why you should stop using RAIDZ, and start using mirror vdevs instead.
6
How to Think about Correlation?
I am an economist at the Federal Trade Commission with a very basic statistics question, one that I have put to several fairly high-powered econometricians, and to which no one has had a satisfying answer.
7
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.
8
VisiData in 60 Seconds
Download faa-wildlife-strikes.csv , a dataset of all aircraft-wildlife collisions reported to the Federal Aviation Administration between 2010 and mid-2016.
9
Using Bloom filters to efficiently synchronise hash graphs
This blog post uses MathJax to render mathematics. You need JavaScript enabled for MathJax to work.
10
Feature Casualties of Large Databases
Databases shed important RDMS features as they get big. Examining why this tends to be the case, and some ideas for preventing it.
11
12
Writing a Postgres Foreign Data Wrapper for Clickhouse in Go
Postgres(hereinafter mentioned as PG) is a pretty cool database with lots of nice features, one of them little known ones is the ability of having Foreign data wrappers (hereinafter mentioned as FDWs). Clickhouse(hereinafter mentioned as CH) is another amazing database with an altogether different set of features…
13
US Postal Service data suggests significant population decline in San Francisco
Keluaran SGP, Togel Singapore, Data SGP, Toto SGP,…2020162 points184 commentsSociety, Policy & Culture details
PengelKeluaran SGP Hari Ini Resmi Togel Singapore Pools Tersedia Melalui Data SGP Prize dan Menyalin Pengeluaran SGP Hari Ini Untuk Pemain Toto SGP.
14
Psql command line tutorial and cheat sheet
The least you need to know about Postgres
15
Personal Data Warehouses: Reclaiming Your Data
I gave a talk yesterday about personal data warehouses for GitHub’s OCTO Speaker Series, focusing on my Datasette and Dogsheep projects. The video of the talk is now available, and …
16
Migrating Large Heroku Postgres Instances to AWS Aurora Without Downtime
In this article I discuss a general process I used recently to migrate a large multi-terabyte Heroku Postgres Database from the Heroku Platform to Amazon Aurora Postgres on a live Heroku based application architecture with near zero downtime and builtin failover during the process.
17
CQRS: Command Query Responsibility Segregation (2011)
CQRS (Command Query Responsibility Segregation) is the notion that you can use a different model to update information than the model you use to read information
18
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…
19
Parsing the Infamous Japanese Postal CSV
Late last year I released posuto, a package presenting Japanese postal code data in an easy-to-use format. It's based on data released by Japan Post, which is infamous for being widely used but hard to parse.
20
Marketers are addicted to bad data
Modern marketing is all about data and however hard you might try, you can't spend any time around marketers online without being subjected to endless
21
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)…
22
What ORMs Have Taught Me: Just Learn SQL (2014)
I’ve come to the conclusion that, for me, ORMs are more detriment than benefit. In short, they can be used to nicely augment working with SQL in a program, but they should not replace it.
23
The surprising impact of medium-size texts on PostgreSQL performance
Why TOAST is the best thing since sliced bread
24
Python For Feature Film
A look into how Python is used to bring your favorite movies to the big screen.
25
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.
26
PostgreSQL community impact of 2nd Quadrant purchase
This blog is about my work on the Postgres open source database, and is published on Planet PostgreSQL. PgLife allows monitoring of all Postgres community activity.
27
Generalizing 'jq' and Traversal Systems using optics and standard monads
The Personal blog and musings of Chris Penner, a designer, developer and future opsimath.
28
Gradient Boosted Decision Trees
From zero to gradient boosted decision trees
29
Time for a WTF MySQL Moment
Documenting the reasons why I tend to prefer Postgres - even when it's my friends getting bitten.
30
