Importing data from SQL into R, with correct R data types

This page summarizes the projects mentioned and recommended in the original post on /r/Rlanguage
R Database Odbc

InfluxDB - 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.
www.influxdata.com
featured
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com
featured

  • odbc

    Connect to ODBC databases (using the DBI interface)

    • Note: Updating my driver to a newer version improved obtaining the correct data types in the R data frame. There is more about this at https://github.com/r-dbi/odbc/issues/11

  • InfluxDB

    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.

    InfluxDB logo
NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts

  • Is there a way to monitor in real time all SQL commands Sent to SQL Server 2017 through Python

    1 project | /r/learnpython | 13 Jul 2023

  • Problems Changing a Password with Pyodbc

    1 project | /r/learnpython | 26 Jun 2023

  • Trying to deploy a windows based Python & Flask web app

    1 project | /r/flask | 26 Apr 2023

  • Self-hosted Car Infotainment

    2 projects | /r/selfhosted | 7 Mar 2023

  • 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.

    3 projects | /r/dataengineering | 29 Jan 2023