61
PostgreSQL 10: Partitions of partitions
PostgreSQL version 10 brings a much anticipated feature: (Native) Table Partitioning .
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 95 posts.
62
Do or undo – there is no VACUUM
What if PostgreSQL didn’t need VACUUM at all? This seems hard to imagine. After all, PostgreSQL uses multi-version concurrency control (MVC...
63
Datomic: Look at all the things I'm not doing
A post by August Lilleaas, published April 20, 2018.
64
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])
65
66
Learning Python for Social Scientists (2015)
I’ve compiled a list of Python tutorials and annotated analyses. I've tried to list pages that are accessible to social scientists with little background in Python and/or machine learning.
67
Transforming Wikipedia into a cultural knowledge quiz
Building “Test Your Culture” by taking the world’s largest encyclopedia… and combining it with data science
68
69
Optimization tricks in Python: lists and tuples
An overview of optimization tricks for lists and tuples
70
How to Read 100s of Millions of Records per Second from a Single Disk
This article gives an overview of the implementation and performance of two recent additions to LocustDB, an extremely fast open-source analytics database built in Rust. The first addition is suppo…
71
72
Fun with NFL Stats, Bokeh, and Pandas
An exploration of NFL play-by-play statistics with Bokeh and Pandas.
73
Using data to determine if Die Hard is a Christmas movie
Ok, enough bickering and fighting.
74
75
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.
76
A little bit of the one-time MacOS version still lingers in ZFS
You're probably reading this page because you've attempted to access some part of my blog (Wandering Thoughts) or CSpace , the wiki thing it's part of. Unfortunately you're using a browser version that my anti-crawler precautions consider suspicious, most often because it's too old (most often this applies to versions…
77
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 …
78
Who Wrote the Anti-Trump New York Times Op-Ed? Using Tidytext
Like a lot of people, I was intrigued by “I Am Part of the Resistance Inside the Trump Administration”, an anonymous New York Times op-ed written by a “senior official in the Trump administration”. And like many data scientists, I was curious about what role text mining could play.
79
The design and implementation of modern column-oriented database systems
The design and implementation of modern column-oriented database systems Abadi et al., Foundations and trends in databases, 2012 I came here by following the references in the Smoke paper we looked…
80
How Numba and Cython speed up Python code
A high-level overview of Numba and Cython architectures
81
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.
82
83
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...
84
85
Using parallel sequential scan in PostgreSQL
Parallel sequential scan is the first parallel access method in PostgreSQL and is introduced in version 9.6. The committer of this featu...
86
87
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?
88
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…
89
Pythran as a bridge between fast prototyping and code deployment
As a researcher/engineer (really, an algorithm developer) in the general area of audio and speech processing, I've always run into the same difficulty at all the companies I've worked at: How to quickly prototype and develop algorithms, and subsequently turn them into efficient code that can be deployed to customers.
90