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

dbi.table (version 1.0.3)

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

License

MPL-2.0

Issues

0

Pull Requests

0

Stars

12

Forks

1

Maintainer

Kjell Konis

Last Published

February 4th, 2025

Functions in dbi.table (1.0.3)

merge

Merge two dbi.tables
dbExecute,dbi.catalog,SQL-method

DBI Methods for dbi.tables
as.dbi.table

Coerce to DBI Table
example_databases

Example Databases
as.data.frame

Coerce to a Data Frame
dbi.catalog

Create a dbi.catalog
reference.test

Test dbi.table vs. Reference Implementation
dbi.table-package

DBI Table
csql

See SQL
dbi.attach

Attach a Database Schema to the Search Path
sql.join

Join dbi.tables