211
Algorithmic Trading: A Practitioner’s Guide
I really enjoyed reading Algorithmic Trading: A Practitioner’s Guide by Jeffrey M. Bacidore. Before starting, I imagined it would cover various strategies for trading in the markets, along th…
Top posts
Every blog post that took off on Hacker News, ranked by the votes of its best submission. 1,888 posts.
212
I hate stacked area charts (2011)
Another great post
213
Is watching the 1984 Ghostbusters movie killing people?
Is watching the 1984 Ghostbusters movie killing people? English adults under 60 who have watched the 1984 Ghostbusters movie are dying at twice the rate of people who have watched the 2021 Ghostbusters move the same age.And have been for six months. The chart may seem unbelievable or impossible but it is correct…
214
215
The girl with the ANSI tattoo
I enjoyed the David Fincher remake of The Girl With The Dragon Tattoo more than I thought I would. Rather than a shallow and cynical Holly...
216
Ways Data Projects Fail
Introduction Data science continues to generate excitement and yet real-world results can often disappoint business stakeholders. How can we mitigate risk and ensure results match expectations? Working as a technical data scientist at the interface between R&D and commercial operations has given me an insight into the…
217
Text Editor Data Structures
Text editors can be an interesting challenge to program. The types of problems that text editors need to solve can range from trivial to mind-bogglingly difficult. Recently, I have been on something of a spiritual journey to rework some internal data structures in an editor I have been building, specifically the most…
218
219
A Visual Intro to NumPy and Data Representation
Discussions: Hacker News (366 points, 21 comments), Reddit r/MachineLearning (256 points, 18 comments) Translations: Chinese 1, Chinese 2, Japanese, Korean The NumPy package is the workhorse of data analysis, machine learning, and scientific computing in the python ecosystem. It vastly simplifies manipulating and…
220
Evidence of Fraud in an Influential Study About Procrastination
A new paper in Psychological Science (.htm) reports a failure to replicate Study 2 of Ariely and Wertenbroch’s influential article entitled, “Procrastination, Deadlines, and Performance: Self-Contr…
221
How AWS S3 serves 1 petabyte per second on top of slow HDDs
Learn how Amazon built the backbone of the modern web that scales to 1 PB/s and 150M QPS on commodity hard drives
222
How to make fancy road trip maps with R and OpenStreetMap
Use R to get geocoded location and routing data from OpenStreetMap and explore our family’s impending 5,000 mile road trip around the USA
223
DuckDB as the New jq
Recently, I’ve been interested in the DuckDB project (like a SQLite geared towards data applications). And one of the amazing features is that it has many data importers included without requiring extra dependencies. This means it can natively read and parse JSON as a database table, among many other formats.
224
Consider SQLite
If you were creating a web app from scratch today, what database would you use? Probably the most frequent answer I see to this is Postgres, although there are a wide range of common answers: MySQL, MariaDB, Microsoft SQL Server, MongoDB, etc. Today I want you to consider: what if SQLite would do just fine?
225
Prefer strict tables in SQLite
I prefer strict tables in SQLite because they avoid some datatype problems, such as putting text in number columns.
226
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
227
River: A fast, robust job queue for Go and Postgres
Introducing River, a Postgres-based job queue designed for resilience and correctness through strong transactional guarantees.
228
Running Awk in parallel to process 256M records
TL;DR Awk crunches massive data; a High Performance Computing (HPC) script calls hundreds of Awk concurrently. Fast and scalable in-memory solution on a fat machine.
229
230
When buying the dip doesn’t work: An analysis of the dot-com crash
When a sale isn’t quite what it seems to be
231
Doing a database join with CSV files
How to combine data spread over two CSV files, like separate tables in a normalized relational database.
232
233
234
In Search of a Faster SQLite
Researchers at the University of Helsinki and Cambridge attempted to build a faster SQLite using modern programming paradigms like io_uring and disaggregated storage. They demonstrate up to a 100x reduction in tail latency. These are my notes.
235
The Future of Notebooks: Lessons from JupyterCon
At JupyterCon, I learned three things: reactive notebooks are the future, Jupyter is the new Bash, and data science is a gateway drug.
236
237
Redis is fast – I'll cache in Postgres
There are books & many articles online, like this one arguing for using Postgres for everything. I thought I’d take a look at one use case - using Postgres instead of Redis for caching. I work with APIs quite a bit, so I’d build a super simple HTTP server that responds with data from that cache. I’d start from Redis…
238
Learning from 20 years of personal analytics
Utilizing data analysis capabilities in Wolfram|Alpha Pro, Stephen Wolfram looks at his quantified self based on his large collection of lifelogging data.
239
Making Postgres slower
As an respectable unemployed person must do, I tried to make Postgres as slow as possible
240
Visualizing Ext4
What does ext4 look like?