Port details |
- R-cran-sqldf SQL select on R data frames
- 0.4.11_1 databases =2 0.4.11_1Version of this port present on the latest quarterly branch.
- Maintainer: skreuzer@FreeBSD.org
- Port Added: 2012-08-22 18:10:33
- Last Update: 2023-04-23 09:09:58
- Commit Hash: 8d3e020
- People watching this port, also watch:: jdictionary, py311-Automat, py311-python-gdsii, py39-PyOpenGL, p5-Sane
- License: GPLv2
- WWW:
- https://cran.r-project.org/web/packages/sqldf/
- Description:
- The sqldf() function is typically passed a single argument which is an SQL
select statement where the table names are ordinary R data frame names. sqldf()
transparently sets up a database, imports the data frames into that database,
performs the SQL select or other statement and returns the result using a
heuristic to determine which class to assign to each column of the returned
data frame. The sqldf() or read.csv.sql() functions can also be used to read
filtered files into R even if the original files are larger than R itself can
handle. 'RSQLite', 'RH2', 'RMySQL' and 'RPostgreSQL' backends are supported.
- ¦ ¦ ¦ ¦
- Manual pages:
- FreshPorts has no man page information for this port.
- pkg-plist: as obtained via:
make generate-plist - Dependency lines:
-
- R-cran-sqldf>0:databases/R-cran-sqldf
- To install the port:
- cd /usr/ports/databases/R-cran-sqldf/ && make install clean
- To add the package, run one of these commands:
- pkg install databases/R-cran-sqldf
- pkg install R-cran-sqldf
NOTE: If this package has multiple flavors (see below), then use one of them instead of the name specified above.- PKGNAME: R-cran-sqldf
- Flavors: there is no flavor information for this port.
- distinfo:
- TIMESTAMP = 1651944475
SHA256 (sqldf_0.4-11.tar.gz) = cee979d4e8c67b4924655365d925a8d67104e62adf71741f645cdc5196de2260
SIZE (sqldf_0.4-11.tar.gz) = 63097
Packages (timestamps in pop-ups are UTC):
- Dependencies
- NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
- Build dependencies:
-
- R-cran-proto>=0.3.9.2_6 : devel/R-cran-proto
- R-cran-chron>=2.3.42 : devel/R-cran-chron
- R-cran-gsubfn>=0.6.4 : devel/R-cran-gsubfn
- R-cran-DBI>=1.1.0 : databases/R-cran-DBI
- R-cran-RSQLite>=2.2.14 : databases/R-cran-RSQLite
- R : math/R
- Runtime dependencies:
-
- R-cran-proto>=0.3.9.2_6 : devel/R-cran-proto
- R-cran-chron>=2.3.42 : devel/R-cran-chron
- R-cran-gsubfn>=0.6.4 : devel/R-cran-gsubfn
- R-cran-DBI>=1.1.0 : databases/R-cran-DBI
- R-cran-RSQLite>=2.2.14 : databases/R-cran-RSQLite
- R : math/R
- There are no ports dependent upon this port
Configuration Options:
- No options to configure
- Options name:
- databases_R-cran-sqldf
- USES:
- cran:auto-plist
- FreshPorts was unable to extract/find any pkg message
- Master Sites:
|
Commit History - (may be incomplete: for full details, see links to repositories near top of page) |
Commit | Credits | Log message |
0.4.11_1 23 Apr 2023 09:09:58 |
Gerald Pfeifer (gerald) |
*: Bump PORTREVISIONs for math/mpc update to 1.3.1 |
07 Sep 2022 21:58:51 |
Stefan Eßer (se) |
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) |
0.4.11 07 Sep 2022 21:10:59 |
Stefan Eßer (se) |
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 ) |
0.4.11 20 Jul 2022 14:21:07 |
Tobias C. Berner (tcberner) |
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 ) |
0.4.11 07 May 2022 17:49:25 |
Steven Kreuzer (skreuzer) |
databases/R-cran-sqldf: update to version 0.4-11
Changes:
* modifications for RSQLite 2.0.0
* read.csv.sql now accepts https and ftps |
0.4.7.1_5 06 Apr 2021 14:31:07 |
Mathieu Arnold (mat) |
Remove # $FreeBSD$ from Makefiles. |
0.4.7.1_5 05 May 2020 16:07:54 |
jrm |
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 |
0.4.7.1_4 26 Jul 2019 20:46:57 |
gerald |
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 |
0.4.7.1_3 12 Dec 2018 01:35:36 |
gerald |
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 |
0.4.7.1_2 10 Mar 2018 17:46:06 |
gerald |
Bump PORTREVISIONs of all users of math/mpc that we just updated to
version 1.1.0 (via revision 464079). |
0.4.7.1_1 01 Apr 2016 14:00:57 |
mat |
Remove ${PORTSDIR}/ from dependencies, categories d, e, f, and g.
With hat: portmgr
Sponsored by: Absolight |
0.4.7.1_1 10 Sep 2014 20:50:37 |
gerald |
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.4.7.1 05 Aug 2014 14:54:56 |
skreuzer |
Update to 0.4-7.1
PR: 190804
Submitted by: Bartek Rutkowski <robak@freebsd.org> |
0.4.7_1 10 Mar 2014 20:55:22 |
gerald |
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.4.7 24 Feb 2014 14:33:14 |
skreuzer |
Update to 0.4-7 |
0.4.6.4_5 28 Dec 2013 10:28:41 |
dbn |
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.4.6.4_5 27 Nov 2013 18:56:44 |
dbn |
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.4.6.4_5 13 Nov 2013 08:19:35 |
bf |
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.4.6.4_4 26 Oct 2013 00:52:36 |
gerald |
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 ) |
0.4.6.4_3 20 Sep 2013 16:13:49 |
bapt |
Add NO_STAGE all over the place in preparation for the staging support (cat:
databases) |
0.4.6.4_3 28 May 2013 15:15:06 |
bf |
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.4.6.4_2 07 Mar 2013 04:21:35 |
bf |
update math/R to 2.15.3, and adjust dependent ports |
0.4.6.4_1 04 Jan 2013 17:51:39 |
bf |
update the R base ports to 2.15.2 and adjust dependent ports
Reviewed by: thierry, tota, wen |
0.4.6.4 22 Aug 2012 18:09:58 |
skreuzer |
sqldf is an R package for runing SQL statements on R data frames, optimized
for convenience. The user simply specifies an SQL statement in R using data
frame names in place of table names and a database with appropriate table
layouts/schema is automatically created, the data frames are automatically
loaded into the database, the specified SQL statement is performed, the
result is read back into R and the database is deleted all automatically
behind the scenes making the database's existence transparent to the user
who only specifies the SQL statement.
WWW: https://code.google.com/p/sqldf/ |