RSQLite
RSQLite copied to clipboard
r-dbi
R interface for SQLite
Although this behaviour appears to be due to SQLite and a warning is thrown I thought it was worth flagging in case you were not aware of it because it...
Add an `Id` method to `dbExistsTable`. When a `schema` is present in the `Id`, check that `schema` is the name of an ATTACHed database and return `FALSE` if not. I...
`dbExistsTable` borks when `conn` is a `SQLiteConnection` and `name` is an `Id` with `schema = "INFORMATION_SCHEMA"` and `table = "TABLES"`. I was expecting it to return `FALSE`. ```r library(DBI) conn
Hi, I'm looking for a way to read encrypted sqlite databases. There are many different ciphers allowing encryption of sqlite databases. One project support multiple ciphers: https://github.com/utelle/SQLite3MultipleCiphers I am not...
This PR is based on a state before we used the cpp11 package. The first commit adds a test script. The second commit includes a single file from cpp11 and...
with `immediate = TRUE` . https://sqlite.org/forum/info/1aa65114ef8631dd
I'm trying to process the entries of one table and insert the results into another table. The processing works and the rows are inserted, but the pipeline stops after the...
Hi, If I understand the SQLite doc correctly, there is a function that allows to [clear bindings](https://www.sqlite.org/c3ref/clear_bindings.html) after a reset and hence get a fresh renewed prepared query. Right now,...
I'm not too sure if this issue sits within dbplyr or RSQLite, but the slice_sample() function does not appear to be taking account of a seed set via set.seed() when...
While doing some [bug hunting for RPostgres](https://github.com/r-dbi/RPostgres/issues/429), realized there's also probably a bug in RSQLite when writing from a CSV: ``` r # ****************************************************************************** # 1. Set Up #### #...
