Package: dbi.table 1.0.3
Kjell P. Konis
dbi.table: Database Queries Using 'data.table' Syntax
Query database tables over a 'DBI' connection using 'data.table' syntax. Attach database schemas to the search path. Automatically merge using foreign key constraints.
Authors:
dbi.table_1.0.3.tar.gz
dbi.table_1.0.3.tar.gz(r-4.5-noble)dbi.table_1.0.3.tar.gz(r-4.4-noble)
dbi.table_1.0.3.tgz(r-4.4-emscripten)dbi.table_1.0.3.tgz(r-4.3-emscripten)
dbi.table.pdf |dbi.table.html✨
dbi.table/json (API)
NEWS
| # Install 'dbi.table' in R: |
| install.packages('dbi.table', repos = c('https://cran.r-universe.dev', 'https://cloud.r-project.org')) |
Bug tracker:https://github.com/kjellpk/dbi.table/issues
Last updated 1 months agofrom:edbddf17ee. Checks:3 OK. Indexed: no.
| Target | Result | Latest binary |
|---|---|---|
| Doc / Vignettes | OK | Mar 06 2025 |
| R-4.5-linux | OK | Mar 06 2025 |
| R-4.4-linux | OK | Mar 06 2025 |
Exports:as.dbi.tablechinook.duckdbchinook.sqlitecsqldbExecutedbGetInfodbGetQuerydbi.attachdbi.catalogdbi.tabledbSendStatementis.dbi.tablereference.testsql.join
Dependencies:bitbit64blobclicpp11DBIdbplyrdplyrfansigenericsgluelifecyclemagrittrpillarpkgconfigpurrrR6rlangstringistringrtibbletidyrtidyselectutf8vctrswithr
Readme and manuals
Help Manual
| Help page | Topics |
|---|---|
| DBI Table | dbi.table-package dbi.table [.dbi.table |
| Coerce to a Data Frame | as.data.frame as.data.frame.dbi.table |
| Coerce to DBI Table | as.dbi.table is.dbi.table |
| See SQL | csql |
| DBI Methods for 'dbi.table's | dbExecute,dbi.catalog,SQL-method dbExecute,dbi.schema,SQL-method dbExecute,dbi.table,SQL-method dbGetInfo,dbi.catalog-method dbGetInfo,dbi.schema-method dbGetInfo,dbi.table dbGetInfo,dbi.table-method dbGetQuery,dbi.table,missing-method dbSendStatement,dbi.table,missing-method |
| Attach a Database Schema to the Search Path | dbi.attach |
| Create a 'dbi.catalog' | dbi.catalog |
| Example Databases | chinook.duckdb chinook.sqlite example_databases |
| Merge two dbi.tables | merge merge.dbi.table |
| Test 'dbi.table' vs. Reference Implementation | reference.test |
| Join 'dbi.table's | sql.join |
