Useful Unix commands for data science
The command line tools that ship with any Unix-like system are extremely handy for many data tasks. Here are some of the ones that I've found most useful.
PostgreSQL Basics by Example
Connecting to a database 1 2 $ psql postgres # the default database $ psql database_name Connecting as a specific user 1 2 $ psql postgres john $ …
RethinkDB 1.5 released: secondary indexes, soft durability, perf improvements
We are pleased to announce RethinkDB 1.5 ( The Graduate), so go download it now !
Arch Linux: MariaDB replaces MySQL in repositories
MariaDB is now officially our default implementation of MySQL. MariaDB is almost a drop in replacement, so an upgrade should be possible with minimum hassle. However, due to remaining compatibility concerns, an automatic replace is not done.
The Big Data Brain Drain: Why Science is in Trouble
Update, August 2014: see Hacking Academia , my most recent reflection on this subject.
Data Science of the Facebook World
Stephen Wolfram shares interesting Facebook data analysis finds from the Data Donor program of Wolfram|Alpha Personal Analytics for Facebook.
Extra security measures for next week's releases
The core committee has decided that one of the security issues due to be fixed next week is sufficiently bad …
PostgreSQL 9.3 Beta 1 Released
The first beta release of PostgreSQL 9.3, the latest version of the world's best open source database, is now available. …
SQLite improves performance with memory-mapped I/O
A complete list of SQLite releases in a single page and a chronology are both also available. A detailed history of every check-in is available at SQLite version control site .
Knossos: Redis and Linearizability
A few weeks ago I criticized a proposal by Antirez for a hypothetical linearizable system built on top of Redis WAIT and a strong coordinator. I showed that the coordinator he suggested was physically impossible to build, and that anybody who tried to actually implement that design would run into serious problems. I…
How Python became the language of choice for data science
Nowadays Python is probably the programming language of choice (besides R) for data scientists for prototyping, visualization, and running data analyses on small and medium sized data sets. And...
Data looks better naked
Rather than dressing data up, strip it down—remove to improve.
RethinkDB 1.7: hot backup, atomic set/get, 10x insert performance improvement
Etienne Laurin ( @atnnn ), an engineer at RethinkDB, introduces these new features in this one-minute video:
Bloom Filters by example
A Bloom filter is a data structure designed to tell you, rapidly and memory-efficiently, whether an element is present in a set.