sqldf

Perform SQL Selects on R Data Frames

Data & Databases

Explore on GitHub Read Hacker News discussions

2Distinct people

2Mentions

0Explicit recommenders

252GitHub stars

REPOSITORY AT A GLANCE

What to know before exploring

What it is

Perform SQL Selects on R Data Frames

GitHub

Where it is used

No documented product use has been verified yet.

What people are saying

No recommendation phrase was found in the indexed comments.

No classified warning is attached to this page. Read the discussions before treating silence as approval.

Also in these discussions

No other repository is repeatedly linked in the same discussions.

This week on Hacker News

Nov 7–Nov 14 UTC · Direct repository links and separately labeled related project stories. Indexed through 11/14/2026, 5:04:57 PM UTC.

No direct repository links were found in the indexed HN discussions over the past seven days. Older discussions are available below.

Mentions over time

HN mentions by year2 dated mentions

Observed mentions: 2016-12-08 03:05:21 UTC to 2021-10-27 09:51:01 UTC.

Counts come from the repository’s dated source evidence. Index cutoff: 2026-11-02 08:16:59 UTC.

View mention counts and date ranges

UTC ranges include their start and exclude their end. Select a period to filter the source evidence.
Period	Start (UTC)	End (exclusive, UTC)	Mentions	Comments
2016	2016-01-01 00:00:00 UTC	2017-01-01 00:00:00 UTC	1	1
2017	2017-01-01 00:00:00 UTC	2018-01-01 00:00:00 UTC	0	0
2018	2018-01-01 00:00:00 UTC	2019-01-01 00:00:00 UTC	0	0
2019	2019-01-01 00:00:00 UTC	2020-01-01 00:00:00 UTC	0	0
2020	2020-01-01 00:00:00 UTC	2021-01-01 00:00:00 UTC	0	0
2021	2021-01-01 00:00:00 UTC	2022-01-01 00:00:00 UTC	1	1

What Hacker News says

2 sources

phillc73·Oct 27, 2021

There's an R package for that! Well, multiple really. The `sqldf`[1] package has been around for a while, there's `tidyquery`[2] and also one I wrote called `duckdf`[3]. All three support writing SQL queries to directly access dataframes. [1] https://github.com/ggrothendieck/sqldf [2] https://github.com/ianmcook/tidyquery [3] https://github.com/phillc73/duckdf

In Comparing SQLite, DuckDB and Arrow with UN trade data

vii·Dec 8, 2016

Both R and Python have gained libraries for SQL syntax queries on their datasets. These are powered by sqllite. As much of the data that gets into R or Python is obtained from a SQL query (or SparkQL etc.) it's awesome to be able to query, aggregate and even join internal datasets in the same way! https://github.com/ggrothendieck/sqldf is game changing. The wealth of statistical packages available for R is astounding. Packages like GLMNet are made available by the top researchers in the field. In comparison, Python libraries tend to be relatively unsophisticated and less robust.

In R vs. Python for Data Science: Summary of Modern Advances