r-dbi/RSQLite issues and pull requests

#520 - `PRIMARY KEY` variable is not being recognised as primary index

Issue - State: open - Opened by OndrejMottl about 1 month ago - 1 comment

#519 - feat: Add sqlite-lines extension

Pull Request - State: open - Opened by rfhb about 1 month ago - 6 comments

#518 - feat: Upgrade bundled SQLite to 3.46.1

Pull Request - State: closed - Opened by github-actions[bot] about 2 months ago - 1 comment
Labels: mergequeue

#517 - feat: Add uuid extension

Pull Request - State: closed - Opened by rfhb about 2 months ago - 2 comments
Labels: mergequeue

#516 - fix: Ensure that `testthat::skip()` is only called in RSQLite's own tests, never in the tests for other packages

Pull Request - State: closed - Opened by jeanetteclark 3 months ago - 5 comments

#515 - Unexpected message and test skipping when using `extended_types = TRUE`

Issue - State: closed - Opened by jeanetteclark 3 months ago - 5 comments

#514 - Description Definition

Issue - State: open - Opened by Grenny1 3 months ago - 1 comment

#513 - RSQLite compile error on Windows using GitHub Actions

Issue - State: closed - Opened by anthonysena 4 months ago - 7 comments

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

Issue - State: open - Opened by shanesturrock 4 months ago - 12 comments
Labels: bug

#511 - CRAN release v2.3.7

Pull Request - State: closed - Opened by krlmlr 4 months ago - 1 comment
Labels: CRAN release :station:

#510 - feat: Upgrade bundled SQLite to 3.46.0

Pull Request - State: closed - Opened by github-actions[bot] 4 months ago - 2 comments
Labels: blocked, mergequeue

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

Issue - State: open - Opened by mickeykawai 4 months ago - 1 comment

#508 - CRAN release v2.3.7

Pull Request - State: closed - Opened by krlmlr 5 months ago - 1 comment
Labels: CRAN release :station:

#507 - feat: Upgrade bundled SQLite to 3.45.3

Pull Request - State: closed - Opened by github-actions[bot] 6 months ago - 1 comment
Labels: mergequeue

#506 - docs: set BS version explicitly for now

Pull Request - State: closed - Opened by maelle 6 months ago - 2 comments
Labels: mergequeue

#505 - Connect to remote sqlite database

Issue - State: open - Opened by seanbirchall 6 months ago - 2 comments

#504 - test: Fix test on FreeBSD

Pull Request - State: closed - Opened by nunotexbsd 6 months ago - 2 comments

#502 - unittest fails

Issue - State: closed - Opened by nunotexbsd 6 months ago - 20 comments
Labels: help wanted

#501 - CRAN release v2.3.6

Pull Request - State: closed - Opened by krlmlr 6 months ago - 1 comment
Labels: CRAN release :station:

#500 - feat: Upgrade bundled SQLite to 3.45.2

Pull Request - State: closed - Opened by github-actions[bot] 7 months ago - 1 comment
Labels: mergequeue

#499 - Add Id method to `dbExistsTable` to address issue #498

Pull Request - State: open - Opened by kjellpk 7 months ago - 2 comments

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

Issue - State: open - Opened by kjellpk 7 months ago - 2 comments
Labels: bug, help wanted

#497 - feat: Upgrade bundled SQLite to 3.45.1

Pull Request - State: closed - Opened by github-actions[bot] 8 months ago - 2 comments
Labels: mergequeue

#496 - docs: use dbitemplate

Pull Request - State: closed - Opened by maelle 8 months ago - 2 comments
Labels: mergequeue

#495 - CRAN release v2.3.5

Pull Request - State: closed - Opened by krlmlr 8 months ago - 1 comment
Labels: CRAN release :station:

#494 - CRAN release v2.3.5

Pull Request - State: closed - Opened by krlmlr 8 months ago - 1 comment
Labels: CRAN release :station:

#493 - CRAN release v2.3.5

Pull Request - State: closed - Opened by krlmlr 8 months ago - 1 comment
Labels: CRAN release :station:

#492 - test: Include all recent DBItest tests

Pull Request - State: closed - Opened by krlmlr 8 months ago - 1 comment
Labels: mergequeue

#491 - feat: Upgrade bundled SQLite to 3.45.0

Pull Request - State: closed - Opened by github-actions[bot] 9 months ago - 2 comments
Labels: mergequeue

#490 - feat: Upgrade bundled SQLite to 3.45.0

Pull Request - State: closed - Opened by github-actions[bot] 9 months ago - 1 comment
Labels: mergequeue

#489 - feat: Upgrade bundled SQLite to 3.45.0

Pull Request - State: closed - Opened by github-actions[bot] 9 months ago - 1 comment
Labels: mergequeue

#488 - chore: Update to DBItest 1.8.0

Pull Request - State: closed - Opened by krlmlr 9 months ago - 5 comments
Labels: mergequeue

#487 - chore: Clean up DBItest call

Pull Request - State: closed - Opened by krlmlr 10 months ago - 2 comments
Labels: mergequeue

#486 - chore: Remove compiler warning about unused variable

Pull Request - State: closed - Opened by krlmlr 10 months ago - 1 comment
Labels: mergequeue

#485 - DO NOT MERGE: Test NA returned from `dbGetRowsAffected()`

Pull Request - State: closed - Opened by krlmlr 10 months ago - 1 comment

#484 - Support encrypted databases

Issue - State: open - Opened by JeremyPasco 10 months ago - 12 comments

#483 - CRAN release v2.3.4

Pull Request - State: closed - Opened by krlmlr 10 months ago - 1 comment
Labels: CRAN release :station:

#482 - fix: Fix compiler warning regarding formatting specifier used in `Rf_warning()`

Pull Request - State: closed - Opened by krlmlr 10 months ago - 1 comment
Labels: mergequeue

#481 - Backport #479 feat: Upgrade bundled SQLite to 3.44.2 to main

Pull Request - State: closed - Opened by aviator-app[bot] 10 months ago

#480 - Backport #478 feat: Upgrade bundled SQLite to 3.44.1 to main

Pull Request - State: closed - Opened by aviator-app[bot] 10 months ago

#479 - feat: Upgrade bundled SQLite to 3.44.2

Pull Request - State: closed - Opened by github-actions[bot] 10 months ago - 7 comments
Labels: mergequeue

#478 - feat: Upgrade bundled SQLite to 3.44.1

Pull Request - State: closed - Opened by github-actions[bot] 10 months ago - 6 comments
Labels: mergequeue

#477 - chore: Use `check_suggested()` standalone for hms package

Pull Request - State: closed - Opened by krlmlr 11 months ago - 1 comment
Labels: mergequeue

#476 - CRAN release v2.3.3

Pull Request - State: closed - Opened by krlmlr 11 months ago - 1 comment
Labels: CRAN release :station:

#475 - feat: Upgrade bundled SQLite to 3.44.0

Pull Request - State: closed - Opened by github-actions[bot] 11 months ago - 3 comments
Labels: mergequeue

#474 - Support multiple queries

Issue - State: open - Opened by krlmlr 11 months ago
Labels: feature, help wanted

#473 - feat: Upgrade bundled SQLite to 3.43.2

Pull Request - State: closed - Opened by github-actions[bot] 12 months ago

#472 - dbHasCompleted() yields an Error: Invalid result set.

Issue - State: open - Opened by Daniel-Zhou-93 about 1 year ago - 3 comments

#471 - FR : bindings to sqlite3_clear_bindings

Issue - State: open - Opened by arnaud-feldmann about 1 year ago

#470 - feat: Upgrade bundled SQLite to 3.43.1

Pull Request - State: closed - Opened by github-actions[bot] about 1 year ago - 1 comment

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

Issue - State: closed - Opened by gaospecial about 1 year ago - 2 comments

#468 - feat: Upgrade bundled SQLite to 3.43.0

Pull Request - State: closed - Opened by github-actions[bot] about 1 year ago - 1 comment

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

Issue - State: closed - Opened by RoganGrant about 1 year ago - 15 comments

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

Issue - State: open - Opened by stephenashton-dhsc about 1 year ago - 1 comment

#465 - Crash after including cpp11 headers

Pull Request - State: open - Opened by krlmlr over 1 year ago - 2 comments

#464 - fix: Fix errors on transaction status

Pull Request - State: closed - Opened by bpvgoncalves over 1 year ago - 9 comments

#463 - CRAN release v2.3.2

Pull Request - State: closed - Opened by krlmlr over 1 year ago - 1 comment
Labels: CRAN release :station:

#462 - feat: New `sqliteIsTransacting()` that returns if a transaction is active on the current connection

Pull Request - State: closed - Opened by bpvgoncalves over 1 year ago - 4 comments

#461 - feat: Upgrade bundled SQLite to 3.42.0

Pull Request - State: closed - Opened by github-actions[bot] over 1 year ago

#460 - dbAppendTable takes ~ 30 seconds in Snowflake

Issue - State: closed - Opened by eriksquires over 1 year ago - 1 comment

#459 - dbAppendTable() with SnowFlake doesn't respect DB or Schema constraints.

Issue - State: closed - Opened by eriksquires over 1 year ago - 1 comment

#458 - CRAN release v2.3.1

Pull Request - State: closed - Opened by krlmlr over 1 year ago
Labels: CRAN release :station:

#457 - dbWriteTable Inconsistently accepts DBI:ID

Issue - State: open - Opened by kmishra9 over 1 year ago - 1 comment
Labels: feature, help wanted

#456 - Error compiling DbConnection.cpp when installing from source

Issue - State: closed - Opened by IdoBar over 1 year ago - 4 comments
Labels: bug

#455 - feat: Upgrade bundled SQLite to 3.41.2

Pull Request - State: closed - Opened by github-actions[bot] over 1 year ago - 7 comments

#454 - feat: Upgrade bundled SQLite to 3.41.1

Pull Request - State: closed - Opened by github-actions[bot] over 1 year ago

#453 - Calling internal SQLite functions to check transaction state

Issue - State: closed - Opened by DavorJ over 1 year ago - 7 comments
Labels: feature, help wanted

#452 - feat: Upgrade bundled SQLite to 3.41.0

Pull Request - State: closed - Opened by github-actions[bot] over 1 year ago - 1 comment

#451 - CRAN release v2.3.0

Pull Request - State: closed - Opened by krlmlr over 1 year ago

#450 - chore: Upgrade boost to 1.81.0-1

Pull Request - State: closed - Opened by krlmlr over 1 year ago

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

Issue - State: open - Opened by nathaneastwood over 1 year ago - 4 comments

#448 - feat: Upgrade bundled SQLite to 3.40.1

Pull Request - State: closed - Opened by github-actions[bot] almost 2 years ago

#447 - CRAN release v2.2.20

Pull Request - State: closed - Opened by krlmlr almost 2 years ago

#446 - feat: Upgrade bundled SQLite to 3.40.0

Pull Request - State: closed - Opened by github-actions[bot] almost 2 years ago - 1 comment

#445 - CRAN release v2.2.19

Pull Request - State: closed - Opened by krlmlr almost 2 years ago

#444 - feat: Upgrade bundled SQLite to 3.40.0

Pull Request - State: closed - Opened by github-actions[bot] almost 2 years ago - 5 comments

#443 - fix: Add missing boost headers for icpc compiler

Pull Request - State: closed - Opened by lolow almost 2 years ago - 1 comment

#442 - RSQLite does not install and ends up with catastrophic error

Issue - State: closed - Opened by lolow almost 2 years ago - 3 comments

#441 - chore: Replace Rcpp by cpp11

Pull Request - State: closed - Opened by Antonov548 almost 2 years ago - 10 comments

#440 - RSQLite crash during install

Issue - State: closed - Opened by chodarq almost 2 years ago - 8 comments

#439 - `dbReadTable` converts arbitrary text to 0 if initial values in column INTEGER or REAL

Issue - State: closed - Opened by joethorley almost 2 years ago - 2 comments

#438 - feat: Use testthat edition 3

Pull Request - State: closed - Opened by krlmlr almost 2 years ago

#437 - WIP: Generated by use_dbitest()

Pull Request - State: open - Opened by krlmlr almost 2 years ago

#436 - CRAN release v2.2.18

Pull Request - State: closed - Opened by krlmlr almost 2 years ago

#435 - Upgrade bundled SQLite to 3.39.4

Pull Request - State: closed - Opened by github-actions[bot] about 2 years ago - 3 comments

#434 - CRAN release v2.2.17

Pull Request - State: closed - Opened by krlmlr about 2 years ago

#433 - feat: Upgrade bundled SQLite to 3.39.3

Pull Request - State: closed - Opened by github-actions[bot] about 2 years ago - 2 comments

#432 - CRAN release v2.2.16

Pull Request - State: closed - Opened by krlmlr about 2 years ago

#431 - feat: Upgrade bundled SQLite to 3.39.2

Pull Request - State: closed - Opened by github-actions[bot] about 2 years ago - 1 comment

#430 - CRAN release v2.2.15

Pull Request - State: closed - Opened by krlmlr about 2 years ago

#429 - feat: Upgrade bundled SQLite to 3.39.1

Pull Request - State: closed - Opened by github-actions[bot] about 2 years ago

#428 - vendor: Upgrade bundled SQLite to 3.39.0

Pull Request - State: closed - Opened by github-actions[bot] over 2 years ago

#427 - Only quote non-syntactic names and reserved words in dbQuoteIdentifier

Issue - State: open - Opened by hadley over 2 years ago - 5 comments

#426 - Insert ID, last_insert_rowid and race condition

Issue - State: closed - Opened by SarenT over 2 years ago - 3 comments

#425 - Error in dbConnect or even loading library in Windows 11

Issue - State: closed - Opened by xmart over 2 years ago - 3 comments

#424 - dbColumnInfo() should return SQL Data Types

Issue - State: open - Opened by krlmlr over 2 years ago
Labels: feature, help wanted

#423 - Upgrade bundled SQLite to 3.38.5

Pull Request - State: closed - Opened by github-actions[bot] over 2 years ago

#422 - CRAN release v2.2.14

Pull Request - State: closed - Opened by krlmlr over 2 years ago

#421 - Upgrade bundled SQLite to 3.38.4

Pull Request - State: closed - Opened by github-actions[bot] over 2 years ago

#420 - CRAN release v2.2.13

Pull Request - State: closed - Opened by krlmlr over 2 years ago

GitHub / r-dbi/RSQLite issues and pull requests