Skip to content

sqliteutils

Utility Functions for 'SQLite'

v0.1.0 · Sep 21, 2021 · MIT + file LICENSE

Description

A tool for working with 'SQLite' databases. 'SQLite' has some idiosyncrasies and limitations that impose some hurdles to the R developer who is using this database as a repository. For instance, 'SQLite' doesn't have a date type and 'sqliteutils' has some functions to deal with that.

Downloads

166

Last 30 days

20071st

166

Last 90 days

166

Last year

CRAN Check Status

2 NOTE
12 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 NOTE
r-devel-linux-x86_64-fedora-gcc NOTE
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 details (14 non-OK)
OK r-devel-linux-x86_64-debian-clang

*


            
OK r-devel-linux-x86_64-debian-gcc

*


            
NOTE r-devel-linux-x86_64-fedora-clang

dependencies in R code

Namespaces in Imports field not imported from:
  ‘DBI’ ‘RSQLite’ ‘dbplyr’ ‘dplyr’
  All declared Imports should be used.
NOTE r-devel-linux-x86_64-fedora-gcc

dependencies in R code

Namespaces in Imports field not imported from:
  ‘DBI’ ‘RSQLite’ ‘dbplyr’ ‘dplyr’
  All declared Imports should be used.
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

*


            

Check History

NOTE 12 OK · 2 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE Mar 9, 2026
NOTE r-devel-linux-x86_64-fedora-clang

dependencies in R code

Namespaces in Imports field not imported from:
  ‘DBI’ ‘RSQLite’ ‘dbplyr’ ‘dplyr’
  All declared Imports should be used.
NOTE r-devel-linux-x86_64-fedora-gcc

dependencies in R code

Namespaces in Imports field not imported from:
  ‘DBI’ ‘RSQLite’ ‘dbplyr’ ‘dplyr’
  All declared Imports should be used.

Dependency Network

Dependencies Reverse dependencies RSQLite DBI dplyr dbplyr magrittr sqliteutils

Version History

new 0.1.0 Mar 9, 2026