./math/R-DBI, R database interface

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


Branch: CURRENT, Version: 1.2.3, Package name: R-DBI-1.2.3, Maintainer: minskim

A database interface definition for communication between R and
relational database management systems. All classes in this package
are virtual and need to be extended by the various R/DBMS
implementations.


Required to run:
[math/R]

Required to build:
[pkgtools/cwrappers]

Master sites: (Expand)


Version history: (Expand)


CVS history: (Expand)


   2024-10-26 07:54:32 by Makoto Fujiwara | Files touched by this commit (2)
Log message:
(math/R-DBI) Updated 1.2.1 to 1.2.3

# DBI 1.2.3 (2024-06-02)

## Bug fixes

- `dbQuoteLiteral()` uses the format `"%Y-%m-%d %H-%M-%S%z"` which is
  understood by more databases (#467, #474).

## Documentation

- Use relational-data.org as a replacement for relational.fit.cvut.cz.
- Set BS version explicitly for now (@maelle, #478).
- Include `dbGetInfo()` in the spec (#477).
- Fix typos (@salim-b, #469, @MichaelChirico, #482).

# DBI 1.2.2 (2024-02-09)

## Bug fixes

- `Id()` does not assign empty names to the components if all
  arguments are unnamed (#464).
- Add spec to version control to avoid weird pandoc errors on CRAN
  (#465).
   2024-01-21 02:38:18 by Makoto Fujiwara | Files touched by this commit (2)
Log message:
(math/R-DBI) Updated 1.1.3 to 1.2.1

# DBI 1.2.1 (2024-01-12)

## Bug fixes

- Fix `dbWriteTableArrow()` according to spec (#457).

- Fix type inference in default method for `dbCreateTableArrow()` (#450).

## Features

- `dbAppendTableArrow()` returns number of rows (#454).

- Add `temporary` argument to `dbCreateTableArrow()` (#453).

- Avoid coercing `params` in default implementation for `dbSendQueryArrow()` (#447).

- Use `nanoarrow::infer_nanoarrow_schema()` in the default method for \ 
`dbCreateTable()` (#445).

## Chore

- Add badge to `DBIResultArrow` class (#452).

- Change maintainer e-mail.

## Documentation

- Finalize Arrow vignette (#451, #455).

- Document new Arrow generics (#444, #449).

- Use dbitemplate (@maelle, #442).

# DBI 1.2.0 (2023-12-20)

## Breaking changes

- `dbUnquoteIdentifier()` creates `Id()` objects without component names  and \ 
allows non-`NA` character input (#421, #422).

## Features

- New generics `dbSendQueryArrow()`, `dbFetchArrow()`, `dbGetQueryArrow()`, \ 
`dbReadTableArrow()`, `dbWriteTableArrow()`  (@nbenn, #390),  \ 
`dbCreateTableArrow()`, `dbAppendTableArrow()` (#396),
`dbBindArrow()` (#415) and `dbFetchArrowChunk()` (#424), with default \ 
implementations via nanoarrow (#414).

- `Id()` now accepts unnamed components (#417). If names are provided, the \ 
components are arranged in SQL order (@eauleaf, #427).

- New `dbIsValid()` method for `"DBIResultArrowDefault"` objects \ 
implemented by DBI (#425).

- Implement `dbiDataType()` for objects of class `"blob"`.

## Documentation

- Update pkgdown template (@maelle, #428, #438, #437).

- Clarify repeated parameter binding (#430).

- Deal with sundown of `https://relational.fit.cvut.cz` (#423).

- Correct vignette titles (#419).

- Harmonize table documentation (#400).

- Tweak typo, add families for data retrieval and command execution.

## Testing

- Enable BLOB tests for arrow \>= 10.0.0 (#395).

- Run DBItest for SQLite as part of the checks here (#431).

- Fix checks without suggested packages (#420).

- Fix Windows tests on GHA (#406).

- `testthat::use_testthat(3)` (#416).
   2022-12-18 07:46:43 by Makoto Fujiwara | Files touched by this commit (2)
Log message:
(math/R-DBI) Updated 1.1.1 to 1.1.3

# DBI 1.1.3 (2022-06-18)

## Features
- `dbAppendTable()` accepts `Id` (#381, @renkun-ken).

## Documentation
- `?dbSendQuery` and related methods gain a section "The data
  retrieval flow" (#386).

- `?dbSendStatement` and related methods gain a section "The command
  execution flow" (#386).

# DBI 1.1.2 (2021-12-19)

## Features
- Use `dbQuoteLiteral()` in default method for `sqlData()` (#362, #371).
- Update specification with changes from DBItest 1.7.2 (#367).

## Documentation
- The pkgdown documentation for DBI generics (e.g. `?dbConnect`)
  contains clickable links to all known backends (except ROracle), and
  an explanatory sentence (#360).

- `?Id` gains better examples (#295, #370).

- Elaborate on status of `dbWriteTable()` in the documentation (#352,
  #372).

- Make method definition more similar to S3. All `setMethod()` calls
  refer to top-level functions (#368).

- `?dbReadTable` and other pages gain pointers to `Id()` and `SQL()` (#359).
   2021-10-26 12:56:13 by Nia Alarie | Files touched by this commit (458)
Log message:
math: Replace RMD160 checksums with BLAKE2s checksums

All checksums have been double-checked against existing RMD160 and
SHA512 hashes
   2021-10-07 16:28:36 by Nia Alarie | Files touched by this commit (458)
Log message:
math: Remove SHA1 hashes for distfiles
   2021-04-29 07:56:34 by Wen Heping | Files touched by this commit (2)
Log message:
Update to 1.1.1

Upstream changes:
DBI 1.1.1 (2021-01-04)
Documentation

    Expand "Get started" vignette to two tutorials, basic and advanced \ 
(#332, @jawond).

Bug fixes

    dbAppendTable() now allows columns named sep (#336).
    dbAppendTable() shows a better error message if the input has zero columns \ 
(#313).
    sqlInterpolate() now correctly interprets consecutive comments (#329, @rnorberg).
    dbQuoteLiteral() works for difftime objects (#325).
    dbQuoteLiteral() quotes dates as YYYY-MM-DD without time zone (#331).

Internal

    Switch to GitHub Actions (#326).
    Update URL in DESCRIPTION.
   2020-09-21 00:51:47 by Makoto Fujiwara | Files touched by this commit (2)
Log message:
(math/R-DBI) Updated 1.0.0 to 1.1.0

# DBI 1.1.0

## New features
- New `DBIConnector` class (#280).

- Specify `immediate` argument to `dbSendQuery()`, `dbGetQuery()`,
  `dbSendStatement()` and `dbExecute()` (#268).

- Use specification for `dbGetInfo()` (#271).

- `dbUnquoteIdentifier()` now supports `Id()` objects with `catalog`
  members (#266, @raffscallion). It also handles unquoted identifiers
  of the form `table`, `schema.table` or `catalog.schema.table`, for
  compatibility with dbplyr.

## Documentation
- New DBI intro article (#286, @cutterkom).

- Add pkgdown reference index (#288).

- DBI specification on https://dbi.r-dbi.org/dev/articles/spec now
  comes with a table of contents and code formatting.

- Update examples to refer to `params` instead of `param` (#235).

- Improved documentation for `sqlInterpolate()` (#100). Add usage of
  `SQL()` to `sqlInterpolate()` examples (#259, @renkun-ken).

- Improve documentation for `Id`.

## Internal
- Add tests for `dbUnquoteIdentifier()` (#279, @baileych).

- `sqlInterpolate()` uses `dbQuoteLiteral()` instead of checking the
  type of the input.

- Avoid partial argument match in `dbWriteTable()` (#246, @richfitz).
   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