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

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


Branch: CURRENT, Version: 2.2.20, Package name: R-RSQLite-2.2.20, 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)


   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
   2018-05-10 02:09:29 by Min Sik Kim | Files touched by this commit (3)
Log message:
databases/R-RSQLite: Update to 2.1.1

Notable changes since 1.0.0:

- RSQLite has been rewritten (essentially from scratch) in C++ with
  Rcpp.
- You can now use SQLite’s URL specification for databases.
- Queries, query parameters and table data are always converted to
  UTF-8 before being sent to the database.
- New strategy for prepared queries. Create a prepared query with
  dbSendQuery() or dbSendStatement() and bind values with dbBind().
- dbSendQuery(), dbGetQuery(), dbSendStatement() and dbExecute() also
  support inline parameterised queries.
- Improve column type inference.
- dbFetch() uses the same row name strategy as dbReadTable().
- dbColumnInfo() will now return information even before you’ve
  retrieved any data.
- New sqliteVersion() prints the header and library versions of
  RSQLite.
- Deprecation warnings are given only once, with a clear reference to
  the source.
- datasetsDb() now returns a read-only database, to avoid
  modifications to the installed file.
- Values of class "integer64" are now supported for dbWriteTable() and
  dbBind().
- New connections now automatically load default RSQLite extensions.
- Implement dbUnquoteIdentifier().