Open-source R projects categorized as SQL | Edit details
Related topics: #dplyr #R #Tidyverse #Ggplot2 #ducks

Top 3 R SQL Projects

  • GitHub repo tidyexplain

    🤹‍♀ Animations of tidyverse verbs using R, the tidyverse, and gganimate

    Project mention: All You Need To Know About Merging (Joining) Datasets in R | reddit.com/r/rstats | 2021-02-03
  • GitHub repo tidyquery

    Query R data frames with SQL

    Project mention: Can "dplyr" code automatically be converted to SQL code? | reddit.com/r/rstats | 2021-09-15


  • Nanos

    Run Linux Software Faster and Safer than Linux with Unikernels.

  • GitHub repo duckdf

    🦆 SQL for R dataframes, with ducks

    Project mention: ClickHouse as an alternative to Elasticsearch for log storage and analysis | news.ycombinator.com | 2021-03-02

    Yeah, I agree sqldf is quite slow. Fair point.

    As you've seen, duckdb registers an "R data frame as a virtual table." I'm not sure what they mean by "yet" either.

    Of course it is possible to write an R dataframe to an on-disk duckdb table, if that's what you want to do.

    There are some simple benchmarks on the bottom of the duckdf README[1]. Essentially I found for basic SQL SELECT queries, dplyr is quicker, but for much more complex queries, the duckdf/duckdb combination performs better.

    If you really want speed of course, just use data.table.

    [1] https://github.com/phillc73/duckdf

NOTE: The open source projects on this list are ordered by number of github stars. The number of mentions indicates repo mentiontions in the last 12 Months or since we started tracking (Dec 2020). The latest post mention was on 2021-09-15.

R SQL related posts


What are some of the best open-source SQL projects in R? This list will help you:

Project Stars
1 tidyexplain 610
2 tidyquery 155
3 duckdf 28
Find remote jobs at our new job board 99remotejobs.com. There are 34 new remote jobs listed recently.
Are you hiring? Post a new remote job listing for free.
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives