RSQLite

RSQLite copied to clipboard

Parquet support

1

Hi Is it possible to somehow fold this in? https://github.com/cldellow/sqlite-parquet-vtable

alanpaulkwan

http://stackoverflow.com/q/611459/946850.

krlmlr

Investigate multicore performance drop

3

https://serverfault.com/q/1000690/95758 https://www.sqlite.org/wal.html https://www.sqlite.org/pragma.html#pragma_synchronous

krlmlr

https://github.com/r-dbi/RSQLite/issues/151#issuecomment-405058062

krlmlr

Avoid copies when reading/writing blobs

1

- [ ] For reading: Use [streaming API](http://www.sqlite.org/c3ref/blob_open.html) - [ ] For writing: Keep a local handle to the RAW object and use `SQLITE_STATIC` instead of `SQLITE_TRANSIENT`

krlmlr

feature request: allow quote= parameter in dbWriteTable S4 method 'SQLiteConnection,character,character'

2

hi, if i'm understanding things correctly, any values that match `sep=` inside a quoted field will derail a `dbWriteTable()` import from a file connection? library(DBI) tf

ajdamico

Implement sqliteIsReadOnly()

1

.

krlmlr

Allow termination of queries

2

https://github.com/hadley/dplyr/issues/2375#issuecomment-275248538 CC @lukeholman @austenhead

krlmlr

Date type support in DBWriteTable

11

Thank you very much for adding Date support in RSQLite! RSQLite support Date typed columns when tables are created using SQL. However when tables are created from dataframes using dbWriteTable...

ablack3

https://github.com/r-dbi/DBItest/pull/267.

krlmlr