1111
The Federalist Papers: Author Identification Through K-Means Clustering
Using K-means clustering on writing style to classify disputed Federalist Papers authorship.
New
The latest blog posts to take off on Hacker News. 1,888 posts.
1112
EnclaveDB: A secure database using SGX
EnclaveDB: A secure database using SGX Priebe et al., IEEE Security & Privacy 2018 This is a really interesting paper (if you’re into this kind of thing I guess!) bringing together the security…
1113
Important database news from the last few months
Google and Amazon acknowledge benefits of SQL, Elasticsearch introduces SQL interface, and MySQL finally becomes modern…after 20 years. These are exciting times in the world of databases.
1114
Conservation of Intent: why A/B tests aren’t as effective as they look
When a +10% isn’t really a +10% OK, this is an infuriating startup experience: You ship an experiment that’s +10% in your conversion funnel. Then your revenue/installs/whatever goes up by +10% right?
1115
You don't need ML/AI, you need SQL
On Software, life and everything in-between
1116
How not to structure database-backed web apps: performance bugs in the wild
How not to structure your database-backed web applications: a study of performance bugs in the wild Yang et al., ICSE’18 This is a fascinating study of the problems people get into when using…
1117
1118
A one-size-fits-all database doesn't fit anyone
The days of the one-size-fits-all monolithic database are behind us, and developers are using a multitude of purpose-built databases.
1119
1120
Harvard discrimination lawsuit: data show penalization of Asian-Americans
Harvard and Students For Fair Admissions (SFFA), which is suing Harvard over discrimination against Asian-American applicants, have relea...
1121
Optimization tricks in Python: lists and tuples
An overview of optimization tricks for lists and tuples
1122
Using Countdown Clock Data to Understand the New York City Subway
Ranking the lines by reliability, the anatomy of a delay, and a case for the $19 billion subway plan
1123
Show HN: Domain-tailored CRDTs for collaboration without server involvement
An in-depth exploration of a new class of expressive, performant, and intuitive CRDTs, together with macOS and iOS sample code.
1124
1125
Parallel Index Scans in PostgreSQL
There is a lot to say about parallelism in PostgreSQL. We have come a long way since I wrote my first post on this topic ( Parallel Sequen...
1126
ML Beyond Curve Fitting: An Intro to Causal Inference and Do-Calculus
Since writing this post back in 2018, I have extended this to a 4-part series on causal inference: * ➡️️ Part 1: Intro to causal inference and do-calculus [https://www.inference.vc/untitled] * Part 2: Illustrating Interventions with a Toy Example…
1127
Datasette Facets: Faceted Browse and a JSON API for any CSV File or SQLite DB
Datasette 0.22 is out with the most significant new feature I’ve added since the initial release: faceted browse. Datasette lets you deploy an instant web UI and JSON API for …
1128
Glom – Restructured Data for Python
Thoughts on FOSS and fintech, layered by Mahmoud Hashemi
1129
1130
The Internals of Postgres – Concurrency Control
Concurrency Control is a mechanism that maintains atomicity and isolation, which are two properties of the ACID, when multiple transactions run concurrently in a database.
1131
Scaling a High-Traffic Rate Limiting Stack with Redis Cluster
Flattening a single very hot vertical Redis node into a horizontal Redis Cluster at Stripe.
1132
One Giant Leap for SQL: MySQL 8.0 Released
MySQL is the last major SQL database that has evolved beyond SQL-92 by introducing window functions (OVER) and common table expressions (WITH [RECURSIVE])
1133
How I Write SQL, Part 1: Naming Conventions (2014)
"There are only two hard problems in Computer Science: cache invalidation and naming things."
1134
Datomic: Look at all the things I'm not doing
A post by August Lilleaas, published April 20, 2018.
1135
Ursa Labs: an innovation lab for open source data science
Funding open source software development is a complicated subject. I’m excited to announce that I’ve founded Ursa Labs ( https://ursalabs.org ), an independent development lab with the mission of innovation in data science tooling.
1136
Kafka, GDPR and Event Sourcing
Proof of concept for compliance with GDPR on an Event Sourcing architecture built with Apache Kafka.
1137
Problems with CSVs (2016)
Much of my professional work for the last 10+ years has revolved around handling, importing and exporting CSV files. CSV files are frustratingly misunderstood, abused, and most of all underspecified. While RFC4180 exists, it is far from definitive and goes largely ignored.
1138
1139
Managing database schema changes without downtime
How we manage schema changes at Discourse minimizing downtime
1140
Data on 1.2M Facebook users from 2005 (2011) [use archive.org url in thread]
Recently, a Facebook dataset was released consisting of the complete set of users from the Facebook networks at 100 American institutions, and all of the in-network “friendship” links between those…