Skip to content

dbi.table

Database Queries Using 'data.table' Syntax

v1.0.7 · Mar 1, 2026 · MPL-2.0

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.

Downloads

336

Last 30 days

11537th

1K

Last 90 days

3.4K

Last year

Trend: +0.6% (30d vs prior 30d)

CRAN Check Status

14 OK
Show all 14 flavors
Flavor Status
r-devel-linux-x86_64-debian-clang OK
r-devel-linux-x86_64-debian-gcc OK
r-devel-linux-x86_64-fedora-clang OK
r-devel-linux-x86_64-fedora-gcc OK
r-devel-macos-arm64 OK
r-devel-windows-x86_64 OK
r-oldrel-macos-arm64 OK
r-oldrel-macos-x86_64 OK
r-oldrel-windows-x86_64 OK
r-patched-linux-x86_64 OK
r-release-linux-x86_64 OK
r-release-macos-arm64 OK
r-release-macos-x86_64 OK
r-release-windows-x86_64 OK

Check History

OK 14 OK · 0 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE Mar 26, 2026
ERROR 13 OK · 0 NOTE · 0 WARNING · 1 ERROR · 0 FAILURE Mar 16, 2026
ERROR r-devel-linux-x86_64-fedora-clang

tests

Running ‘testthat.R’ [114s/150s]
Running the tests in ‘tests/testthat.R’ failed.
Complete output:
  > # This file is part of the standard setup for testthat.
  > # It is recommended that you do not modify it.
  > #
  > # Where should you do additiona
...[truncated]...
, strict = n > 0L)
   10.         ├─DBI::dbGetQuery(x, write_select_query(x, n, strict))
   11.         └─DBI::dbGetQuery(x, write_select_query(x, n, strict))
  
  [ FAIL 1 | WARN 0 | SKIP 2 | PASS 422 ]
  Error:
  ! Test failures.
  Execution halted
OK 14 OK · 0 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE Mar 10, 2026

Dependency Network

Dependencies Reverse dependencies DBI bit64 dbplyr rlang stringi dbi.table

Version History

new 1.0.7 Mar 10, 2026
updated 1.0.7 ← 1.0.6 diff Feb 28, 2026
updated 1.0.6 ← 1.0.5 diff Jan 10, 2026
updated 1.0.5 ← 1.0.4 diff Sep 19, 2025
updated 1.0.4 ← 1.0.3 diff Jun 27, 2025
updated 1.0.3 ← 1.0.1 diff Feb 3, 2025
new 1.0.1 Dec 9, 2024