GitHunt
NF

nfultz/DBIsqldf

fork of sqldf

DBIsqldf

Provides an easy way to perform SQL selects on R data frames.

The package contains a single function sqldf() whose help file
contains more information and examples.

This package is a fork from the original sqldf-package.

The primary differences are:

  • DBI interface only. This increases compatibility with database drivers, but at the expense
    of database-specific convenience features.
  • DBI native parameterized query support.
  • More conservative defaults for writing tables - data frames are imported as temporary tables
    and should be committed explicitly is they need to be persisted.
  • No legacy (transitive) dependencies.

Installation

remotes::install_github("nfultz/DBIsqldf")

Languages

R96.8%Makefile3.2%

Contributors

Created September 7, 2022
Updated January 21, 2026