Learn R Programming

dbi.table (version 1.0.4)

Database Queries Using 'data.table' Syntax

Description

Query database tables over a 'DBI' connection using 'data.table' syntax. Attach database schemas to the search path. Automatically merge using foreign key constraints.

Copy Link

Version

Install

install.packages('dbi.table')

Monthly Downloads

338

Version

1.0.4

License

MPL-2.0

Issues

Pull Requests

Stars

Forks

Maintainer

Kjell Konis

Last Published

June 28th, 2025

Functions in dbi.table (1.0.4)

example_databases

Example Databases
dbi.attach

Attach a Database Schema to the Search Path
csql

See SQL
dbi.catalog

Create a dbi.catalog
reference.test

Test dbi.table vs. Reference Implementation
as.data.frame

Coerce to a Data Frame
dbi.table.DBI

DBI Methods for dbi.tables
as.dbi.table

Coerce to DBI Table
sql.join

Join dbi.tables
merge

Merge two dbi.tables
dbi.table-package

DBI Table