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

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


Branch: CURRENT, Version: 2.2.7, Package name: R-RSQLite-2.2.7, 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:
[pkgtools/cwrappers] [devel/R-BH] [devel/R-plogr]

Master sites: (Expand)


Version history: (Expand)


CVS history: (Expand)


   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().
   2016-02-25 20:46:54 by Filip Hajny | Files touched by this commit (3)
Log message:
Import databases/R-RSQLite 1.0.0 into pkgsrc.

This package embeds the SQLite database engine in R and provides
an interface compliant with the DBI package.