Querying remote APIs with RethinkDB

The latest version of RethinkDB has a pretty nifty new feature that allows you to make requests to remote APIs and query the result directly from the database server:

r.http('https://api.github.com/repos/rethinkdb/rethinkdb/stargazers')
    .pluck('login', 'id')
    .orderBy('id')

It includes parameters for authentication and pagination as well. This is really handy for ad-hoc analysis of API data, something I’ve used it for previously. I wrote a simple app that would request some data, insert it into the DB, then pull it back out according to my query. With this new method there would be a lot less back and forth.

You can learn more about r.http in the RethinkDB docs.

→ The internet of things

My grandfather could probably have told you how many electric motors he owned. There was one in the car, one in the fridge, one in his drill and so on.

My father, when I was a child, might have struggled to list all the motors he owned (how many, exactly, are in a car?) but could have told you how many devices were in the house that had a chip in.

Today, I have no idea how many device I own with a chip, but I could tell you how many have a network connection. And I doubt my children will know that, in their turn.

The internet of things – Benedict Evans

There is a lot of fluff around IoT at the moment, but Benedict Evans cuts through to the reality of these things very cogently.