Learn R Programming
⚠️There's a newer version (1.0.4) of this package.Take me there.

dbi.table (version 1.0.1)

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

License

MPL-2.0

Issues

0

Pull Requests

0

Stars

12

Forks

1

Maintainer

Kjell Konis

Last Published

December 10th, 2024

Functions in dbi.table (1.0.1)

dbi.catalog

Create a dbi.catalog
as.dbi.table

Coerce to DBI Table
dbExecute,dbi.catalog,SQL-method

DBI Methods for dbi.tables
example_databases

Example Databases
dbi.table-package

DBI Table
dbi.attach

Attach a Database Schema to the Search Path
merge

Merge two dbi.tables
csql

See SQL
as.data.table

Coerce to data.table
reference.test

Test dbi.table vs. Reference Implementation
sql.join

Join dbi.tables