notbugAs an Amazon Associate I earn from qualifying purchases.
Want a good read? Try FreeBSD Mastery: Jails (IT Mastery Book 15)
Want a good monitor light? See my photosAll times are UTC
Ukraine
Port details
R-cran-RSQLite Database Interface R driver for SQLite
2.3.6 databases on this many watch lists=2 search for ports that depend on this port Find issues related to this port Report an issue related to this port View this port on Repology. pkg-fallout 2.3.6Version of this port present on the latest quarterly branch.
Maintainer: skreuzer@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2012-08-22 18:03:47
Last Update: 2024-04-05 08:36:58
Commit Hash: d4fe7a4
People watching this port, also watch:: jdictionary, py311-Automat, py311-python-gdsii, py39-PyOpenGL, p5-Sane
License: LGPL21
WWW:
https://cran.r-project.org/web/packages/RSQLite/
Description:
Database Interface R driver for SQLite. This package embeds the SQLite database engine in R and provides an interface compliant with the DBI package.
Homepage    cgit ¦ Codeberg ¦ GitHub ¦ GitLab ¦ SVNWeb

Manual pages:
FreshPorts has no man page information for this port.
pkg-plist: as obtained via: make generate-plist
Expand this list (3 items)
Collapse this list.
  1. /usr/local/share/licenses/R-cran-RSQLite-2.3.6/catalog.mk
  2. /usr/local/share/licenses/R-cran-RSQLite-2.3.6/LICENSE
  3. /usr/local/share/licenses/R-cran-RSQLite-2.3.6/LGPL21
Collapse this list.
Dependency lines:
  • R-cran-RSQLite>0:databases/R-cran-RSQLite
To install the port:
cd /usr/ports/databases/R-cran-RSQLite/ && make install clean
To add the package, run one of these commands:
  • pkg install databases/R-cran-RSQLite
  • pkg install R-cran-RSQLite
NOTE: If this package has multiple flavors (see below), then use one of them instead of the name specified above.
PKGNAME: R-cran-RSQLite
Flavors: there is no flavor information for this port.
distinfo:
TIMESTAMP = 1711979278 SHA256 (RSQLite_2.3.6.tar.gz) = fbb1b7a58ff49af30059a802a9fed0055b8cf1e401b8022382b94fc6c3c9f8f2 SIZE (RSQLite_2.3.6.tar.gz) = 4249332

Packages (timestamps in pop-ups are UTC):
R-cran-RSQLite
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest2.3.62.3.61.0.0_52.3.62.3.6---
FreeBSD:13:quarterly2.3.62.3.6-2.3.62.3.6-2.2.19_12.2.19_1
FreeBSD:14:latest2.3.62.3.6-2.3.62.3.6---
FreeBSD:14:quarterly2.3.62.3.6-2.3.62.3.6-2.2.19_12.2.19_1
FreeBSD:15:latest2.3.62.3.6n/a2.3.6n/a-2.2.19_12.2.19_1
Dependencies
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
Build dependencies:
  1. R-cran-bit64>0 : devel/R-cran-bit64
  2. R-cran-blob>=1.2.0 : devel/R-cran-blob
  3. R-cran-cpp11>=0.4.0 : devel/R-cran-cpp11
  4. R-cran-DBI>=1.2.0 : databases/R-cran-DBI
  5. R-cran-memoise>0 : devel/R-cran-memoise
  6. R-cran-pkgconfig>0 : devel/R-cran-pkgconfig
  7. R-cran-plogr>=0.2.0 : devel/R-cran-plogr
  8. R-cran-Rcpp>=0.4.00 : devel/R-cran-Rcpp
  9. R-cran-rlang>0 : devel/R-cran-rlang
  10. R : math/R
  11. gfortran13 : lang/gcc13
  12. as : devel/binutils
Test dependencies:
  1. R-cran-testthat>0 : devel/R-cran-testthat
Runtime dependencies:
  1. R-cran-bit64>0 : devel/R-cran-bit64
  2. R-cran-blob>=1.2.0 : devel/R-cran-blob
  3. R-cran-cpp11>=0.4.0 : devel/R-cran-cpp11
  4. R-cran-DBI>=1.2.0 : databases/R-cran-DBI
  5. R-cran-memoise>0 : devel/R-cran-memoise
  6. R-cran-pkgconfig>0 : devel/R-cran-pkgconfig
  7. R-cran-plogr>=0.2.0 : devel/R-cran-plogr
  8. R-cran-Rcpp>=0.4.00 : devel/R-cran-Rcpp
  9. R-cran-rlang>0 : devel/R-cran-rlang
  10. R : math/R
  11. gfortran13 : lang/gcc13
This port is required by:
for Build
  1. databases/R-cran-sqldf

Deleted ports which required this port:

Expand this list of 1 deleted port
  1. databases/R-cran-RSQLite.extfuns*
  2. Collapse this list of deleted ports.
for Run
  1. databases/R-cran-sqldf

Deleted ports which required this port:

Expand this list of 1 deleted port
  1. databases/R-cran-RSQLite.extfuns*
  2. Collapse this list of deleted ports.
* - deleted ports are only shown under the This port is required by section. It was harder to do for the Required section. Perhaps later...

Configuration Options:
No options to configure
Options name:
databases_R-cran-RSQLite
USES:
cran:auto-plist,compiles
FreshPorts was unable to extract/find any pkg message
Master Sites:
Expand this list (16 items)
Collapse this list.
  1. http://cran.utstat.utoronto.ca/src/contrib/
  2. http://cran.utstat.utoronto.ca/src/contrib/Archive/RSQLite/
  3. https://cloud.r-project.org/src/contrib/
  4. https://cloud.r-project.org/src/contrib/Archive/RSQLite/
  5. https://cran.csiro.au/src/contrib/
  6. https://cran.csiro.au/src/contrib/Archive/RSQLite/
  7. https://cran.ism.ac.jp/src/contrib/
  8. https://cran.ism.ac.jp/src/contrib/Archive/RSQLite/
  9. https://cran.ma.imperial.ac.uk/src/contrib/
  10. https://cran.ma.imperial.ac.uk/src/contrib/Archive/RSQLite/
  11. https://mirror.las.iastate.edu/CRAN/src/contrib/
  12. https://mirror.las.iastate.edu/CRAN/src/contrib/Archive/RSQLite/
  13. https://mirrors.tuna.tsinghua.edu.cn/CRAN/src/contrib/
  14. https://mirrors.tuna.tsinghua.edu.cn/CRAN/src/contrib/Archive/RSQLite/
  15. https://stat.ethz.ch/CRAN/src/contrib/
  16. https://stat.ethz.ch/CRAN/src/contrib/Archive/RSQLite/
Collapse this list.
Port Moves

Number of commits found: 31

Commit History - (may be incomplete: for full details, see links to repositories near top of page)
CommitCreditsLog message
2.3.6
05 Apr 2024 08:36:58
commit hash: d4fe7a47308c3c1be107deebfd7a799a1387a30dcommit hash: d4fe7a47308c3c1be107deebfd7a799a1387a30dcommit hash: d4fe7a47308c3c1be107deebfd7a799a1387a30dcommit hash: d4fe7a47308c3c1be107deebfd7a799a1387a30d files touched by this commit
Nuno Teixeira (eduardo) search for other commits by this committer
Author: Einar Bjarni Halldórsson
databases/R-cran-RSQLite: Update to 2.3.6

While I'm here,

- remove conditionals regarding llvm16 build fix as port build fine
  without it.
- add test target

ChangeLog: https://cran.r-project.org/web/packages/RSQLite/news/news.html

Differential Revision:	https://reviews.freebsd.org/D44592
2.2.19_1
26 Jul 2023 00:48:20
commit hash: 95274bf4f99c71fc056013d966aec239161dfd74commit hash: 95274bf4f99c71fc056013d966aec239161dfd74commit hash: 95274bf4f99c71fc056013d966aec239161dfd74commit hash: 95274bf4f99c71fc056013d966aec239161dfd74 files touched by this commit
Muhammad Moinur Rahman (bofh) search for other commits by this committer
*/*: Fix build with llvm16 on 13.2-STABLE

As like as HEAD(14.0-RELEASE) llvm16 was merged in base for 13.2-STABLE
with the OSVERSION 1302507.

- Utilize USE_CXXSTD=c++14 or similar solution where applicable
- Update conditionals to addtionally check for OSVERSION greater than
  1302507 and less than 1400000

Approved by:	portmgr (blanket)
Sponsored by:	The FreeBSD Foundation
2.2.19_1
30 Jun 2023 00:53:12
commit hash: 2a1d6e5e5473fb53dfdab5862416728115ab6a37commit hash: 2a1d6e5e5473fb53dfdab5862416728115ab6a37commit hash: 2a1d6e5e5473fb53dfdab5862416728115ab6a37commit hash: 2a1d6e5e5473fb53dfdab5862416728115ab6a37 files touched by this commit
Muhammad Moinur Rahman (bofh) search for other commits by this committer
databases/R-cran-RSQLite: Fix build with llvm16

Approved by:	portmgr (blanket)
Sponsored by:	The FreeBSD Foundation
2.2.19_1
23 Apr 2023 09:09:58
commit hash: 8d3e020ed032a8db00208994d0db646de7dc6f5bcommit hash: 8d3e020ed032a8db00208994d0db646de7dc6f5bcommit hash: 8d3e020ed032a8db00208994d0db646de7dc6f5bcommit hash: 8d3e020ed032a8db00208994d0db646de7dc6f5b files touched by this commit
Gerald Pfeifer (gerald) search for other commits by this committer
*: Bump PORTREVISIONs for math/mpc update to 1.3.1
2.2.19
01 Dec 2022 16:55:47
commit hash: 3ed9cdad45dd9106ad9463863f9fb0d6164d7b7bcommit hash: 3ed9cdad45dd9106ad9463863f9fb0d6164d7b7bcommit hash: 3ed9cdad45dd9106ad9463863f9fb0d6164d7b7bcommit hash: 3ed9cdad45dd9106ad9463863f9fb0d6164d7b7b files touched by this commit
Steven Kreuzer (skreuzer) search for other commits by this committer
databases/R-cran-RSQLite: update to 2.2.19

Changes:
  * Upgrade bundled SQLite to 3.40.0
  * Add missing boost headers for icpc compiler
07 Sep 2022 21:58:51
commit hash: fb16dfecae4a6efac9f3a78e0b759fb7a3c53de4commit hash: fb16dfecae4a6efac9f3a78e0b759fb7a3c53de4commit hash: fb16dfecae4a6efac9f3a78e0b759fb7a3c53de4commit hash: fb16dfecae4a6efac9f3a78e0b759fb7a3c53de4 files touched by this commit
Stefan Eßer (se) search for other commits by this committer
Remove WWW entries moved into port Makefiles

Commit b7f05445c00f has added WWW entries to port Makefiles based on
WWW: lines in pkg-descr files.

This commit removes the WWW: lines of moved-over URLs from these
pkg-descr files.

Approved by:		portmgr (tcberner)
2.2.14
07 Sep 2022 21:10:59
commit hash: b7f05445c00f2625aa19b4154ebcbce5ed2daa52commit hash: b7f05445c00f2625aa19b4154ebcbce5ed2daa52commit hash: b7f05445c00f2625aa19b4154ebcbce5ed2daa52commit hash: b7f05445c00f2625aa19b4154ebcbce5ed2daa52 files touched by this commit
Stefan Eßer (se) search for other commits by this committer
Add WWW entries to port Makefiles

It has been common practice to have one or more URLs at the end of the
ports' pkg-descr files, one per line and prefixed with "WWW:". These
URLs should point at a project website or other relevant resources.

Access to these URLs required processing of the pkg-descr files, and
they have often become stale over time. If more than one such URL was
present in a pkg-descr file, only the first one was tarnsfered into
the port INDEX, but for many ports only the last line did contain the
port specific URL to further information.

There have been several proposals to make a project URL available as
a macro in the ports' Makefiles, over time.
(Only the first 15 lines of the commit message are shown above View all of this commit message)
2.2.14
20 Jul 2022 14:21:07
commit hash: d076ad94e206dda108061fe99ddb860d93cc6d16commit hash: d076ad94e206dda108061fe99ddb860d93cc6d16commit hash: d076ad94e206dda108061fe99ddb860d93cc6d16commit hash: d076ad94e206dda108061fe99ddb860d93cc6d16 files touched by this commit
Tobias C. Berner (tcberner) search for other commits by this committer
databases: remove 'Created by' lines

A big Thank You to the original contributors of these ports:

  *  "Choe, Cheng-Dae" whitekid
  *  "Mahdi Mokhtari <mokhi64@gmail.com>"
  *  "Meikel Brandmeyer" <ocaml-sqlite3-port@kotka.de>
  *  <hvo.pm@xs4all.nl>
  *  <jsmith@resonatingmedia.com>
  *  <ports@c0decafe.net>
  *  Aaron Dalton <aaron@FreeBSD.org>
  *  Adam Weinberger <adamw@FreeBSD.org>
  *  Ade Lovett <ade@FreeBSD.org>
  *  Akinori MUSHA aka knu <knu@idaemons.org>
  *  Alan Snelson <Alan@Wave2.org>
(Only the first 15 lines of the commit message are shown above View all of this commit message)
2.2.14
07 May 2022 17:49:25
commit hash: e3f0381466929ea21e050337cdb17a2747e54ecbcommit hash: e3f0381466929ea21e050337cdb17a2747e54ecbcommit hash: e3f0381466929ea21e050337cdb17a2747e54ecbcommit hash: e3f0381466929ea21e050337cdb17a2747e54ecb files touched by this commit
Steven Kreuzer (skreuzer) search for other commits by this committer
databases/R-cran-RSQLite: update to version 2.2.14

Changes:
  * Upgrade bundled SQLite to version 3.38.5
1.0.0_5
06 Apr 2021 14:31:07
commit hash: 305f148f482daf30dcf728039d03d019f88344ebcommit hash: 305f148f482daf30dcf728039d03d019f88344ebcommit hash: 305f148f482daf30dcf728039d03d019f88344ebcommit hash: 305f148f482daf30dcf728039d03d019f88344eb files touched by this commit
Mathieu Arnold (mat) search for other commits by this committer
Remove # $FreeBSD$ from Makefiles.
1.0.0_5
05 May 2020 16:07:54
Revision:534095Original commit files touched by this commit
jrm search for other commits by this committer
math/R: Update to version 4.0.0

Upstream changes:
https://stat.ethz.ch/pipermail/r-announce/2020/000653.html

Also bump PORTREVISION of ports that depend on math/R.

Submitted by:	wen (in part)
Reviewed by:	jwb, Rainer Hurling <rhurlin@gwdg.de>, thierry
Differential Revision:	https://reviews.freebsd.org/D24572
1.0.0_4
26 Jul 2019 20:46:57
Revision:507372Original commit files touched by this commit
gerald search for other commits by this committer
Bump PORTREVISION for ports depending on the canonical version of GCC
as defined in Mk/bsd.default-versions.mk which has moved from GCC 8.3
to GCC 9.1 under most circumstances now after revision 507371.

This includes ports
 - with USE_GCC=yes or USE_GCC=any,
 - with USES=fortran,
 - using Mk/bsd.octave.mk which in turn features USES=fortran, and
 - with USES=compiler specifying openmp, nestedfct, c11, c++0x, c++11-lang,
   c++11-lib, c++14-lang, c++17-lang, or gcc-c++11-lib
plus, everything INDEX-11 shows with a dependency on lang/gcc9 now.

PR:		238330
1.0.0_3
12 Dec 2018 01:35:36
Revision:487272Original commit files touched by this commit
gerald search for other commits by this committer
Bump PORTREVISION for ports depending on the canonical version of GCC
defined via Mk/bsd.default-versions.mk which has moved from GCC 7.4 t
GCC 8.2 under most circumstances.

This includes ports
 - with USE_GCC=yes or USE_GCC=any,
 - with USES=fortran,
 - using Mk/bsd.octave.mk which in turn features USES=fortran, and
 - with USES=compiler specifying openmp, nestedfct, c11, c++0x, c++11-lang,
   c++11-lib, c++14-lang, c++17-lang, or gcc-c++11-lib
plus, as a double check, everything INDEX-11 showed depending on lang/gcc7.

PR:		231590
1.0.0_2
10 Mar 2018 17:46:06
Revision:464084Original commit files touched by this commit
gerald search for other commits by this committer
Bump PORTREVISIONs of all users of math/mpc that we just updated to
version 1.1.0 (via revision 464079).
1.0.0_1
18 Jun 2017 18:09:17
Revision:443845Original commit files touched by this commit
dbn search for other commits by this committer
qa: add check for NO_ARCH

If NO_ARCH is set then check that no FreeBSD elf(5) files are in $STAGEDIR.
If an elf(5) file is bundles as part of the package, but is not meant to be
run directly (i.e. the elf(5) file is a payload, and not compiled) then
those files can be added to NO_ARCH_IGNORE to avoid the check from failing,

Changes to ports:
 - Ports that have NO_ARCH set, but actually compile files have had NO_ARCH
   removed.
 - Ports that have elf(5) payloads have had those files added to
   NO_ARCH_IGNORE.
 - R-cran ports that do not set USES=cran:compiles have NO_ARCH set,

PR:		218976
Reviewed by:	antoine, mat
Approved by:	portmgr
1.0.0
19 May 2016 10:21:25
Revision:415498Original commit files touched by this commit
amdmi3 search for other commits by this committer
- Fix trailing whitespace in pkg-descrs, categories [a-f]*

Approved by:	portmgr blanket
1.0.0
01 Apr 2016 14:00:57
Revision:412346Original commit files touched by this commit
mat search for other commits by this committer
Remove ${PORTSDIR}/ from dependencies, categories d, e, f, and g.

With hat:	portmgr
Sponsored by:	Absolight
1.0.0
27 Oct 2014 17:31:59
Revision:371596Original commit files touched by this commit
skreuzer search for other commits by this committer
Update to 1.0.0
0.11.4
08 Oct 2014 22:03:45
Revision:370491Original commit files touched by this commit
robak search for other commits by this committer
databases/R-cran-RSQLite: update 0.11.2 -> 0.11.4

- Fix RUN_DEPENDS variable assignment
- Pet portlint
- Maintainer's timeout

PR:		190803
Submitted by:	Bartek Rutkowski <robak@FreeBSD.org>
Approved by:	mentors (implicit)
0.11.2_7
10 Sep 2014 20:50:37
Revision:367888Original commit files touched by this commit
gerald search for other commits by this committer
Update the default version of GCC in the Ports Collection from GCC 4.7.4
to GCC 4.8.3.

Part II, Bump PORTREVISIONs.

PR:		192025
Tested by:	antoine (-exp runs)
Approved by:	portmgr (implicit)
0.11.2_6
10 Mar 2014 20:55:22
Revision:347809Original commit files touched by this commit
gerald search for other commits by this committer
Update the default version of GCC used in the Ports Collection from
GCC 4.6.4 to GCC 4.7.3.  This entails updating the lang/gcc port as
well as changing the default in Mk/bsd.default-versions.mk.

Part II, Bump PORTREVISIONs.

PR:		182136
Supported by:	Christoph Moench-Tegeder <cmt@burggraben.net> (fixing many ports)
Tested by:	bdrewery (two -exp runs)
0.11.2_5
28 Dec 2013 10:28:41
Revision:337846Original commit files touched by this commit
dbn search for other commits by this committer
Convert Mk/bsd.cran.mk to the Uses framework.

PR:		ports/184699
Reviewed by:	bapt
Approved by:	portmgr (bdrewery), wen (maintainer, timeout > 2 weeks)
0.11.2_5
27 Nov 2013 18:56:44
Revision:335044Original commit files touched by this commit
dbn search for other commits by this committer
Add stage support to Mk/bsd.cran.mk and all USE_R_MOD ports (aka R-cran-*).

Since this patch converts all affected ports, bsd.cran.mk no longer supports
NO_STAGE and errors out if NO_STAGE is set.

Exp-run:	ports/184216
Reviewed by:	bdrewery
Approved by:	portsmgr, wen
0.11.2_5
13 Nov 2013 08:19:35
Revision:333659Original commit files touched by this commit
bf search for other commits by this committer
Update math/R to 3.0.2 patched r64207 and math/R-cran-SuppDists to 1.1-9.1;
adjust dependent ports

Reviewed by:	pfg, thierry, tota
0.11.2_4
26 Oct 2013 00:52:36
Revision:331644Original commit files touched by this commit
gerald search for other commits by this committer
Update to libmpc version 1.0.1 which brings the following fixes:

 - Switched to automake 1.11.6, see CVE-2012-3386.
 - #14669: Fixed extraction of CC from gmp.h.
 - Fixed case of intermediate zero real or imaginary part in mpc_fma,
   found by hydra with GMP_CHECK_RANDOMIZE=1346362345.

This is on top of the following changes from version 1.0

 - Licence change towards LGPLv3+ for the code and GFDLv1.3+ (with no
   invariant sections) for the documentation.
 - 100% of all lines are covered by tests
 - Renamed functions
   . mpc_mul_2exp to mpc_mul_2ui
   . mpc_div_2exp to mpc_div_2ui
(Only the first 15 lines of the commit message are shown above View all of this commit message)
0.11.2_3
20 Sep 2013 16:13:49
Revision:327717Original commit files touched by this commit
bapt search for other commits by this committer
Add NO_STAGE all over the place in preparation for the staging support (cat:
databases)
0.11.2_3
28 May 2013 15:15:06
Revision:319316Original commit files touched by this commit
bf search for other commits by this committer
Update math/R to 3.0.1-patched, and adjust dependent ports;
synchronize math/rpy with upstream repository

Reviewed by:	wen
Approved by:	wen, tota
0.11.2_2
07 Mar 2013 04:21:35
Revision:313562Original commit files touched by this commit
bf search for other commits by this committer
update math/R to 2.15.3, and adjust dependent ports
0.11.2_1
04 Jan 2013 17:51:39
Revision:309935Original commit files touched by this commit
bf search for other commits by this committer
update the R base ports to 2.15.2 and adjust dependent ports

Reviewed by:	thierry, tota, wen
0.11.2
11 Dec 2012 22:35:36
Revision:308721Original commit files touched by this commit
skreuzer search for other commits by this committer
Update to 0.11.2
0.11.1
22 Aug 2012 18:02:56
Original commit files touched by this commit
skreuzer search for other commits by this committer
Database Interface R driver for SQLite. This package embeds the SQLite database
engine in R and provides an interface compliant with the DBI package.

WWW:	http://cran.r-project.org/web/packages/RSQLite/

Number of commits found: 31