RSQLite
RSQLite copied to clipboard
r-dbi
R interface for SQLite
- [x] Resolve all tasks in `cran-comments.md` - [x] Run `fledge::release()` - [ ] When the package is accepted on CRAN, run `fledge::post_release()`
Using https://www.sqlite.org/c3ref/keyword_check.html to capture all reserved words. This isn't very important, but it does help dbplyr generate more natural SQL.
OP #388 by @ankane. It's a good idea, my current focus is on dbi3, happy to review a PR. CC @gavril0.
Having the extended types is great, but it seems they can only be used to put data in and get it out? Are there functions and operators in SQL that...
I think it might be worth switching from `Rcpp` to `cpp11`. See [Motivations for cpp11](https://cpp11.r-lib.org/articles/motivations.html) for some reasons. Compilation is now much faster (~28s vs ~52s) and I think it...
Thanks for adding the recent extensions that support CSV imports (eg, #407, #389). I believe the data types passed to the `schema` argument aren't being respected. This is from the...
It seems impossible to cast NA when a new variable containing only NA is created within SQL. More precisely, `CAST(expr AS type)` in a `SELECT` query always returns logical NA...
@gaborcsardi: Do you have a Debian at hand to take a quick look? https://www.r-project.org/nosvn/R.check/r-release-linux-x86_64/RSQLite-00check.html ``` checking tests ... [18s/21s] ERROR Running ‘testthat.R’ [18s/20s] Running the tests in ‘tests/testthat.R’ failed. Complete...
Follow-up to #362. This library contributes to a big chunk of the inlined Boost headers, and can be replaced by https://github.com/HowardHinnant/date/, the library that {clock} uses.
via `SQLITE_ENABLE_MATH_FUNCTIONS`. See https://sqlite.org/forum/forumpost/7936401679 and https://www.sqlite.org/src/info/6b93627b5d9819ab for details. Does this conflict with the extension we are using? Requires #347.