Package: sqliteutils 0.1.0
sqliteutils: Utility Functions for 'SQLite'
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.
Authors:
sqliteutils_0.1.0.tar.gz
sqliteutils_0.1.0.zip(r-4.5)sqliteutils_0.1.0.zip(r-4.4)sqliteutils_0.1.0.zip(r-4.3)
sqliteutils_0.1.0.tgz(r-4.5-any)sqliteutils_0.1.0.tgz(r-4.4-any)sqliteutils_0.1.0.tgz(r-4.3-any)
sqliteutils_0.1.0.tar.gz(r-4.5-noble)sqliteutils_0.1.0.tar.gz(r-4.4-noble)
sqliteutils_0.1.0.tgz(r-4.4-emscripten)sqliteutils_0.1.0.tgz(r-4.3-emscripten)
sqliteutils.pdf |sqliteutils.html✨
sqliteutils/json (API)
| # Install 'sqliteutils' in R: |
| install.packages('sqliteutils', repos = c('https://crotman.r-universe.dev', 'https://cloud.r-project.org')) |
Bug tracker:https://github.com/crotman/sqliteutils/issues
Last updated 4 years agofrom:97f2589927. Checks:1 OK, 8 NOTE. Indexed: yes.
| Target | Result | Latest binary |
|---|---|---|
| Doc / Vignettes | OK | Mar 17 2025 |
| R-4.5-win | NOTE | Mar 17 2025 |
| R-4.5-mac | NOTE | Mar 17 2025 |
| R-4.5-linux | NOTE | Mar 17 2025 |
| R-4.4-win | NOTE | Mar 17 2025 |
| R-4.4-mac | NOTE | Mar 17 2025 |
| R-4.4-linux | NOTE | Mar 17 2025 |
| R-4.3-win | NOTE | Mar 17 2025 |
| R-4.3-mac | NOTE | Mar 17 2025 |
Exports:%>%slu_date_to_rslu_date_to_sqlite
Dependencies:bitbit64blobcachemclicpp11DBIdbplyrdplyrfansifastmapgenericsgluelifecyclemagrittrmemoisepillarpkgconfigplogrpurrrR6rlangRSQLitestringistringrtibbletidyrtidyselectutf8vctrswithr
Readme and manuals
Help Manual
| Help page | Topics |
|---|---|
| Converts dates stored on 'SQLite' to their original values | slu_date_to_r |
| Converts dates to the numeric values as which they would be stored on SQLite | slu_date_to_sqlite |
