r-dbi/RSQLite

Issues

• dbAppendTable takes ~ 30 seconds in Snowflake

  #460 opened a year ago by eriksquires
  1

• dbAppendTable() with SnowFlake doesn't respect DB or Schema constraints.

  #459 opened a year ago by eriksquires
  1

• unittest fails

  #502 opened 2 months ago by nunotexbsd
  20

• Connect to remote sqlite database

  #505 opened 2 months ago by seanbirchall
  2

• Error compiling DbConnection.cpp when installing from source

  #456 opened a year ago by IdoBar
  4

• FR : bindings to sqlite3_clear_bindings

  #471 opened 9 months ago by arnaud-feldmann
  3

• Only quote non-syntactic names and reserved words in dbQuoteIdentifier

  #427 opened 2 years ago by hadley
  5

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

  #449 opened 2 months ago by nathaneastwood
  4

• slice_sample() does not interact correctly with set.seed() when working with an SQLite database

  #466 opened 10 months ago by stephenashton-dhsc
  1

• dbHasCompleted() yields an Error: Invalid result set.

  #472 opened 9 months ago by Daniel-Zhou-93
  3

• Support encrypted databases

  #484 opened 6 months ago by JeremyPasco
  12

• dbExistsTable(conn, Id(schema = "INFORMATION_SCHEMA", table = "TABLES")) throws error (should return FALSE?)

  #498 opened 2 months ago by kjellpk
  2

• CAST(NULL AS type) does not cast missing data NA to the expected type

  #413 opened a year ago by gavril0
  2

• RSQLite crash during install

  #440 opened a year ago by chodarq
  8

• "Interrupt in busy handler" fails in Debian testing

  #406 opened a year ago by krlmlr
  6

• RSQLite does not install and ends up with catastrophic error

  #442 opened 2 years ago by lolow
  3

• Support multiple queries

  #474 opened 7 months ago by krlmlr
  0

• `dbReadTable` converts arbitrary text to 0 if initial values in column INTEGER or REAL

  #439 opened 2 years ago by joethorley
  2

• Installation of RSQLite failed with cpp11-ver0.4.6 in Ubuntu 22.04

  #469 opened 9 months ago by gaospecial
  2

• Unable to install from source with Mac OS 13.4.1 (clang-1403.0.22.14.1)

  #467 opened 10 months ago by RoganGrant
  14

• Calling internal SQLite functions to check transaction state

  #453 opened a year ago by DavorJ
  7

• Insert ID, last_insert_rowid and race condition

  #426 opened 2 years ago by SarenT
  3

• Error in dbConnect or even loading library in Windows 11

  #425 opened 2 years ago by xmart
  3

• dbWriteTable Inconsistently accepts DBI:ID

  #457 opened a year ago by kmishra9
  1

• Adding Date operations

  #379 opened 3 years ago by schuemie
  10

• Add argument to initExtension()

  #407 opened 2 years ago by krlmlr
  1

• RSQLite.so undefined symbol

  #398 opened 2 years ago by Sanrrone
  2

• Raise error if data type domain differs between R and database

  #324 opened 3 years ago by krlmlr
  2

• Installation on xenial fails

  #378 opened 3 years ago by krlmlr
  1

• install Rpackage of RSQLite trigger on miniconda

  #367 opened 3 years ago by honghh2018
  4

• conda `r-rsqlite` and R SQLite

  #377 opened 3 years ago by Shicheng-Guo
  2

• dbWriteTable

  #376 opened 3 years ago by ggrothendieck
  3

• `dbGetQuery()` returns no columns for INSERT ... RETURNING on temporary tables

  #380 opened 3 years ago by mgirlich
  4

• `RETURNING` produces wrong column name

  #381 opened 3 years ago by mgirlich
  3

• Rstudio Connection pane opens also when RSQlite called from inside a function

  #369 opened 3 years ago by giocomai
  4

• Cannot connect to database with version 2.2.6

  #365 opened 3 years ago by billy34
  7

• Missing fenv.hpp when installing on Ubuntu 18.04.3

  #375 opened 3 years ago by Jeff-Gui
  2

• dbColumnInfo() should return SQL Data Types

  #424 opened 2 years ago by krlmlr
  0

• Segfault in installing the RSQLite on a Linux cluster

  #371 opened 3 years ago by habilzare
  6

• CSV extension ignores schema's data type.

  #414 opened 2 years ago by wibeasley
  3

• New failure on Solaris

  #348 opened 3 years ago by krlmlr
  10

• Parameterised queries cannot return correct order by using `ORDER BY`

  #344 opened 3 years ago by plantton
  6

• help needed for blob

  #330 opened 3 years ago by splaisan
  4

• Automate fetching of updated SQLite sources

  #335 opened 3 years ago by krlmlr
  1

• Get rid of boost::date_time

  #394 opened 3 years ago by krlmlr
  0

• Parquet support

  #325 opened 4 years ago by alanpaulkwan
  1

• Enable built-in math functions

  #349 opened 3 years ago by krlmlr
  0

• Date type support in DBWriteTable

  #351 opened 3 years ago by ablack3
  11

• Create new CRAN release?

  #326 opened 4 years ago by schuemie
  1

• Mixed Type: option to return list instead of coercing

  #323 opened 4 years ago by mgirlich
  2