./databases/R-RSQLite, SQLite interface for R

[ CVSweb ] [ Homepage ] [ RSS ] [ Required by ] [ Add to tracker ]


Branch: CURRENT, Version: 2.3.9, Package name: R-RSQLite-2.3.9, Maintainer: pkgsrc-users

Embeds the 'SQLite' database engine in R and provides an interface
compliant with the 'DBI' package. The source for the 'SQLite' engine
is included.


Required to run:
[math/R] [math/R-DBI] [devel/R-Rcpp] [devel/R-bit64] [devel/R-pkgconfig] [devel/R-memoise] [devel/R-blob]

Required to build:
[devel/R-BH] [devel/R-plogr]

Master sites: (Expand)


Version history: (Expand)


CVS history: (Expand)


   2024-12-14 02:29:33 by Makoto Fujiwara | Files touched by this commit (2)
Log message:
(databases/R-RSQLite) Updated 2.2.0 to 2.3.9

# RSQLite 2.3.9 (2024-12-03)

## Features

- Upgrade bundled SQLite to 3.47.1 (#550).

## Bug fixes

- Avoid memory leak (#553).

- Fix valgrind error (#552).

# RSQLite 2.3.8 (2024-11-17)

## Bug fixes

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

## Features

- Upgrade bundled SQLite to 3.47.0 (#525).

- Add uuid extension (@rfhb, #517).

## Documentation

- Reword warning message for misuse of
  `dbGetQuery()`/`dbSendQuery()`/`dbFetch()` (#524, @mikmart).

# RSQLite 2.3.7 (2024-05-26)

## Breaking changes

- Breaking change: Avoid appending a numeric suffix to duplicate column names (#503).

## Features

- Upgrade bundled SQLite to 3.46.0 (#510).
- Add `Id` method to `dbExistsTable()` (@kjellpk, #498, #499).
- Breaking change: Avoid appending a numeric suffix to duplicate column names (#503).

## Documentation

- Set BS version explicitly for now (@maelle, #506).

## Testing

- Fix test on FreeBSD (@nunotexbsd, #502, #504).

# RSQLite 2.3.6 (2024-03-31)

## Features

- Upgrade bundled SQLite to 3.45.2 (#500).

## Documentation

- Use dbitemplate (@maelle, #496).

# RSQLite 2.3.5 (2024-01-20)

## Features

- Upgrade bundled SQLite to 3.45.0 (#491).

## Chore

- Update to upcoming DBItest 1.8.1 (#488, #492).

- Remove compiler warning about unused variable (#486).

# RSQLite 2.3.4 (2023-12-07)

## Bug fixes

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

- Upgrade bundled SQLite to 3.44.2 (#479).

## Chore

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

# RSQLite 2.3.3 (2023-11-04)

## Features

- Upgrade bundled SQLite to 3.43.2 (#473).

- New `sqliteIsTransacting()` that returns if a transaction is active
  on the current connection (@bpvgoncalves, #462, #464).

## Testing

- Skip DBItest tests if not installed.

# RSQLite 2.3.2 (2023-10-27)

## Features

- Upgrade bundled SQLite to 3.42.0 (#461).

## Internal

- Require cpp11 \>= 0.4.0 (#456).

# RSQLite 2.3.1 (2023-04-03)

## Features

- Upgrade bundled SQLite to 3.41.2 (#455).

## Chore

- Require cpp11 \>= 0.4.0 in `DESCRIPTION` (#456).

# RSQLite 2.3.0 (2023-02-13)

## Features

- Upgrade bundled SQLite to 3.40.1 (#448).

## Chore

- Upgrade boost to 1.81.0-1 (#450).

- Clean up GitPod configuration.

- Replace Rcpp by cpp11 (@Antonov548, #441).
   2023-01-01 07:00:20 by Makoto Fujiwara | Files touched by this commit (1)
Log message:
(databases/R-RSQLite) Removed redundent TEST_DEPENDS+
   2023-01-01 06:44:58 by Makoto Fujiwara | Files touched by this commit (2)
Log message:
(databases/R-RSQLite) Updated 2.2.7 to 2.2.20

# RSQLite 2.2.20 (2022-12-21)

## Features

- Upgrade bundled SQLite to 3.40.0 (#446).

## Tests

- Fix test on non-UTF-8 locales.

## Internal

- GitPod and cmake integration.

# RSQLite 2.2.19 (2022-11-22)

## Bug fixes

- Add missing boost headers for icpc compiler (@lolow, #442, #443).

## Internal

- Use testthat edition 3 (#438).

# RSQLite 2.2.18 (2022-10-04)

- Upgrade bundled SQLite to 3.39.4 (#435).

# RSQLite 2.2.17 (2022-09-09)

- Upgrade bundled SQLite to 3.39.3 (#433).

# RSQLite 2.2.16 (2022-08-16)

- Upgrade bundled SQLite to 3.39.2 (#431).

# RSQLite 2.2.15 (2022-07-15)

- Upgrade bundled SQLite to 3.39.1 (#429).

# RSQLite 2.2.14 (2022-05-05)

- Upgrade bundled SQLite to version 3.38.5 (#421, #423).

# RSQLite 2.2.13 (2022-04-29)

- Upgrade bundled SQLite to version 3.38.3 (#418).

# RSQLite 2.2.12 (2022-04-02)

## Features

- Upgrade bundled SQLite to version 3.38.2 (#415).

## Internal

- Prefer `empty()` over `size() == 0` (#410, @MichaelChirico).
- Refactor to improve code consistency (#411, @MichaelChirico).
- Use more parsimonious header to avoid CRAN warnings.

# RSQLite 2.2.11 (2022-03-07)

## Features

- `initExtension()` gains `extension` argument (#407, #408) with options
  `"math"`, `"regexp"`, `"series"` and \ 
`"csv"` (#274, #389, @mgirlich).
- Upgrade bundled SQLite to version 3.38.0 (#405).

## Bug fixes

- Skip failing test on CRAN.

# RSQLite 2.2.10 (2022-02-16)

## Features

- Upgrade bundled SQLite to version 3.37.2 (#403).

## Documentation

- Explain reason for bundling SQLite sources.
- Add known SQLite authors to `DESCRIPTION`.

## Internal

- Add test for interrupt behavior in `sqliteSetBusyHandler()` (#401).
- Make method definition more similar to S3. All `setMethod()` calls
  refer to top-level functions (#396).

# RSQLite 2.2.9 (2021-12-06)

## Features

- Upgrade bundled SQLite to version 3.37.0 (#392).
- `dbConnect()` now supports URIs that start with `file://` for the
  `dbname` argument. The SQLite code is now built with the
  `SQLITE_USE_URI` (#390, @tschoonj).

## Bug fixes

- `dbBegin()`, `dbCommit()` and `dbRollback()` support keywords in
  savepoint names (#386).

## Internal

- Adapt to DBItest 1.7.2 (#385).
- Enable all DBItest tests, passing now.

# RSQLite 2.2.8 (2021-08-21)

- Upgrade bundled SQLite to version 3.36.0 (#374).
- Fix build on CentOS 7 (#367).
- Busy callback emits message instead of warning (#355).
- Avoid using memoise at build time (#371).
   2021-10-26 12:10:08 by Nia Alarie | Files touched by this commit (417)
Log message:
databases: Replace RMD160 checksums with BLAKE2s checksums

All checksums have been double-checked against existing RMD160 and
SHA512 hashes

The following distfiles could not be fetched (some may be only fetched
conditionally):

./databases/cstore/distinfo D6.data.ros.gz
./databases/cstore/distinfo cstore0.2.tar.gz
./databases/cstore/distinfo data4.tar.gz
   2021-10-07 15:35:53 by Nia Alarie | Files touched by this commit (417)
Log message:
databases: Remove SHA1 distfile hashes
   2021-06-09 17:20:49 by Makoto Fujiwara | Files touched by this commit (2)
Log message:
(databases/R-RSQLite) Updated 2.2.0 to 2.2.7

# RSQLite 2.2.7 (2021-04-22)
- Remove RStudio Connection pane support due to problems reported by
  users (#352).
- Upgrade bundled SQLite to version 3.35.5 (#368).

# RSQLite 2.2.6 (2021-04-11)
- Upgrade bundled SQLite to 3.35.4 (#361).
- Implement RStudio Connection Contract (#352, @edwindj).

- `Dbdatatype()` supports extended types  for connections created with
  `extended_types = TRUE` (#360, @ablack3).

- `dbWriteTable()` creates tables with extended types for connections
  created with `extended_types = TRUE` (#360, @ablack3).

- Remove BH dependency by inlining the header files (#362).

# RSQLite 2.2.5 (2021-03-25)
- Upgrade bundled SQLite to version 3.35.2 (#357).
- If the busy handler fails, the transaction is aborted explicitly
  (#348, @gaborcsardi).

# RSQLite 2.2.4 (2021-03-12)
## Features
- Improve concurrency behavior with multiple writers (#280, @gaborcsardi).

- New `sqliteSetBusyHandler()` helps configure what SQLite should do
  when the database is locked (#280, @gaborcsardi).

- `dbConnect()` gains an `extended_types` argument that adds support
  for date, time and timestamp columns. If a column has a declared
  type `DATE`, `TIME` or `TIMESTAMP`, it is returned as `Date`, `hms`
  or `POSIXct` value, respectively (#333, @anderic1).

- Upgrade bundled SQLite to version 3.34.1 (#342).

# RSQLite 2.2.3 (2021-01-24)
## Features
- Upgrade bundled SQLite to version 3.34.1 (#342).

- `dbConnect()` gains an `extended_types` argument that adds support
  for date, time and timestamp columns. If a column has a declared
  type `DATE`, `TIME` or `TIMESTAMP`, it is returned as `Date`, `hms`
  or `POSIXct` value, respectively (#333, @anderic1).

# RSQLite 2.2.2 (2021-01-04)
## Features
- Upgrade bundled SQLite to version 3.34 (#337).

## Bug fixes
- `dbWriteTable()` and `dbAppendTable()` use transactions with unique
  savepoint IDs (#338).

- Loading extensions works when RSQLite is installed in a path with
  non-ASCII characters (#310).

## Internal
- Implement automatic upgrade of bundled SQLite via GitHub Actions (#335).
- Switch to GitHub Actions (#331).

# RSQLite 2.2.1 (2020-09-28)
- Upgrade to SQLite 3.33.0 (#321).
- Use transaction for faster processing in `dbAppendTable()` (#306).
- Strings and blobs now can have a size of up to 2 GB (#314, @shutinet).
- Multipart queries now give a warning (#313).
   2020-09-20 16:34:25 by Makoto Fujiwara | Files touched by this commit (2)
Log message:
(databases/R-RSQLite) Updated 2.1.2 to 2.2.0. make test fails for missing \ 
TEST_DEPENDS.
# RSQLite 2.2.0
- Avoid mangling column names (#259).

# RSQLite 2.1.5
- Upgrade bundled sqlite version to 3.30.1.
- Implement `dbGetInfo()` for driver and connection objects (#117).
- Remove custom `dbListFields()` method (#228).
- Only export relevant symbols to the shared library (#303, @troels).
- Fulfill requirements for CII badge (#300, @TSchiefer).

# RSQLite 2.1.4
- Replace `std::mem_fn()` by `boost::mem_fn()` which works for older compilers.

# RSQLite 2.1.3
- Replace `std::mem_fun_ref()` by `std::mem_fn()`.
   2019-08-08 21:53:58 by Brook Milligan | Files touched by this commit (189) | Package updated
Log message:
Update all R packages to canonical form.

The canonical form [1] of an R package Makefile includes the
following:

- The first stanza includes R_PKGNAME, R_PKGVER, PKGREVISION (as
  needed), and CATEGORIES.

- HOMEPAGE is not present but defined in math/R/Makefile.extension to
  refer to the CRAN web page describing the package.  Other relevant
  web pages are often linked from there via the URL field.

This updates all current R packages to this form, which will make
regular updates _much_ easier, especially using pkgtools/R2pkg.

[1] http://mail-index.netbsd.org/tech-pkg/2019/08/02/msg021711.html