Personal project: I'm logging sensor data to Sqlite on a Raspberry Pi. I want to make some pretty visuals with R using the data, but unsure about my options for making the data accessible to R.

• DBI

  1 284 9.2 R

  A database interface (DBI) definition for communication between R and RDBMSs (by r-dbi)

  

You can query the database directly from an R session. My preferred approach is to use the DBI package. I would also recommend using the dbplyr package to write dplyr-style data transformations instead of trying to do a bunch of SQL string formatting.

• dbplyr

  1 458 8.7 R

  Database (DBI) backend for dplyr

  

You can query the database directly from an R session. My preferred approach is to use the DBI package. I would also recommend using the dbplyr package to write dplyr-style data transformations instead of trying to do a bunch of SQL string formatting.

• InfluxDB

  www.influxdata.com featured

  Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  

• tig_stack

  1 0 10.0 Shell

I have actually got to dabble with TIG stack recently for a friend who had a similar usecase. They needed to monitor power usage of network routers and switches, and already had the data in an MQTT storage. Here's the work-in-progress example if you want to take a look: https://github.com/ratulotron/tig_stack

Suggest a related project