RSQLite

RSQLite copied to clipboard

When empty `data.frame`s are returned, the column classes are not correct

4

When an empty `data.frame` is returned from a query, I am getting strange column classes for a SQLite connection. This does not happen in our PostgreSQL database. ``` conn

nathaneastwood

System-wide sqlite 3.36 breaks installation of R package (which comes with sqlite 3.46)

12

OS - Rocky Linux 8 x86_64, R 4.4.0 (built from source) using standard gcc 8.5.0 Installing 2.3.6 from CRAN is fine. Installing 2.3.7 from CRAN fails with this error: ```...

shanesturrock

RSQLite keeps numeric of epoch day as date in SQLite database whereas SQLite regards numeric as Julian day (REAL) or epoch second (INTEGER)

1

Hi, I love shiny with RSQLite as well as light weight SQLite. Thank you for this useful package. Here I'd comment an apparent discrepancy of data type of date between...

mickeykawai

Connect to remote sqlite database

2

I've seen other implementations in Python / JS / GO but haven't found anything for R. Is there anyway to query a remote sqlite database say hosted on some S3...

seanbirchall

Fixes #523.

mikmart

`dbFetch()` gives confusing warning when used with `dbSendStatement()`

4

Calling `dbFetch()` on a result of `dbSendStatement()` gives a confusing warning, telling you to use `dbSendStatement()`: ``` r library(DBI) fetch_bound_statement Warning in dbFetch(res): Should not call dbFetch() on results that...

mikkmart

Website code is difficult to read in dark mode

6

Not sure if this is the right place to post this, but I noticed that the website is a bit difficult to read if the computer is set to dark...

jonbry

`PRIMARY KEY` variable is not being recognised as primary index

1

I am not sure if this is an issue of {RSQLite} or {DBI}. However, I created an SQLite database and a table using SQL calls, even though I have declared...

OndrejMottl

Description Definition

1

Hello In the R-DBI SQLite Description it is stated: 'Embeds the SQLite database engine in R' and 'because the package itself contains SQLite...' Does this mean on a Linux box...

Grenny1