FreshPorts -- The Place For Ports If you buy from Amazon USA, please support us by using this link.
Follow us
Blog
Twitter

We also have a status page: https://freshports.wordpress.com/

Port details
sqlite-ext-miscfuncs Math, string, and aggregate function library for SQLite
1.1_1 databases on this many watch lists=0 search for ports that depend on this port Find issues related to this port Report an issue related to this port

There is no maintainer for this port.
Any concerns regarding this port should be directed to the FreeBSD Ports mailing list via ports@FreeBSD.org search for ports maintained by this maintainer
Port Added: 05 Mar 2010 19:29:51
License: not specified in port
Provide mathematical, string and aggregate functions for SQL queries
using the SQLite loadable extensions mechanism.

Math functions:

  acos, asin, atan, atn2, atan2, acosh, asinh, atanh, difference,
  degrees, radians, cos, sin, tan, cot, cosh, sinh, tanh, coth,
  exp, log, log10, power, sign, sqrt, square, ceil, floor, pi

String functions:

  replicate, charindex, leftstr, rightstr, ltrim, rtrim, trim,
  replace, reverse, proper, padl, padr, padc, strfilter

Aggregate functions:

  stdev, variance, mode, median, lower_quartile, upper_quartile

WWW: http://www.sqlite.org/contrib
SVNWeb : Homepage : PortsMon
    Pseudo-pkg-plist information, but much better, from make generate-plist
    Expand this list (3 items)
  1. libexec/sqlite-ext/libsqlitemiscfuncs.so
  2. @postexec /sbin/ldconfig -m /usr/local/libexec/sqlite-ext
  3. @postunexec /sbin/ldconfig -R
  4. Collapse this list.

To install the port: cd /usr/ports/databases/sqlite-ext-miscfuncs/ && make install clean
To add the package: pkg install sqlite-ext-miscfuncs

PKGNAME: sqlite-ext-miscfuncs

distinfo:

SHA256 (sqlite-ext/extension-functions-1.1.c) = 991b40fe8b2799edc215f7260b890f14a833512c9d9896aa080891330ffe4052
SIZE (sqlite-ext/extension-functions-1.1.c) = 52188


NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.

Library dependencies:
  1. libsqlite3.so : databases/sqlite3
There are no ports dependent upon this port

Configuration Options
===> The following configuration options are available for sqlite-ext-miscfuncs-1.1_1:
     DOCS=on: Build and/or install documentation
===> Use 'make config' to modify these settings

USES:
sqlite

pkg-message:
*********************************************************************
Loading extensions is by default prohibited as a security measure;
see "Security Considerations" in
http://www.sqlite.org/cvstrac/wiki?p=LoadableExtensions.

If the sqlite3 program and library are built this way, you cannot
use these functions from the program, you must write your own program
using the sqlite3 API, and call sqlite3_enable_load_extension as
described above, or else rebuilt the sqlite3 program to allow
loadable extensions.
*********************************************************************

Master Sites:
  1. http://distcache.FreeBSD.org/local-distfiles/glarkin/
  2. http://distcache.eu.FreeBSD.org/local-distfiles/glarkin/
  3. http://distcache.us-east.FreeBSD.org/local-distfiles/glarkin/
  4. http://distcache.us-west.FreeBSD.org/local-distfiles/glarkin/
  5. http://www.sourcehosting.net/freebsd/distfiles/

Number of commits found: 13

Commit History - (may be incomplete: see SVNWeb link above for full details)
DateByDescription
19 Jul 2016 11:04:14
Original commit files touched by this commit  1.1_1
Revision:418767
mat search for other commits by this committer
When there is a do-install target, do not use a post-install target, do
everything at once.  Sometime, rename post-install into a options helper
target.

I did not fix ports that were such a mess that I could not figure out
what they really wanted to do.  I also did not change ports that had
some version of an auto-plist code in post-install, for the same reason.

With hat:	portmgr
Sponsored by:	Absolight
25 Apr 2016 16:13:39
Original commit files touched by this commit  1.1_1
Revision:414014
mat search for other commits by this committer
Remove USE_SQLITE from bsd.databases.mk, replaced by USES=sqlite.

While there replace USE_SQLITE=x by USES=sqlite:x.

PR:		208971
Submitted by:	mat
Exp-run by:	antoine
With hat:	portmgr
Sponsored by:	Absolight
Differential Revision:	https://reviews.freebsd.org/D5951
20 Dec 2014 17:40:54
Original commit files touched by this commit  1.1_1
Revision:375020
bapt search for other commits by this committer
Cleanup plist
04 Jul 2014 09:41:00
Original commit files touched by this commit  1.1_1
Revision:360588
tijl search for other commits by this committer
Bump PORTREVISION on all ports with USE_SQLITE=yes or USE_SQLITE=3 that
have not been bumped yet after the latest libsqlite3.so library version
change.

Approved by:	portmgr (implicit)
03 Jul 2014 21:48:44
Original commit files touched by this commit  1.1
Revision:360463  Sanity Test Failure
adamw search for other commits by this committer
Nuke NOPORTDOCS. While, here, correct a couple offenders who label examples
with PORTDOCS. And, fix a couple WITH_foo invocations.
16 May 2014 03:11:14
Original commit files touched by this commit  1.1
Revision:354192
vanilla search for other commits by this committer
Support STAGEDIR.
16 Dec 2013 18:24:49
Original commit files touched by this commit  1.1
Revision:336656
glarkin search for other commits by this committer
[Errno 11] Resource Temporarily Unavailable

Reassigning my ports back to the pool with the hope of freeing up
to do more FreeBSD work in the future.

Submitted by:	glarkin
20 Sep 2013 16:13:49
Original commit files touched by this commit  1.1
Revision:327717
bapt search for other commits by this committer
Add NO_STAGE all over the place in preparation for the staging support (cat:
databases)
20 Mar 2011 12:54:45
Original commit files touched by this commit  1.1
miwi search for other commits by this committer
- Get Rid MD5 support
03 Jun 2010 14:28:03
Original commit files touched by this commit  1.1
glarkin search for other commits by this committer
- Upgraded to latest version 1.1 (made up since distfile is not under
  revision control).  Upstream argument assertion fix in square root
  function.
03 Jun 2010 14:24:13
Original commit files touched by this commit  1.0_1
glarkin search for other commits by this committer
- Added distfile version numbering so older versions can be installed
  without running into checksum errors.
05 Mar 2010 19:52:24
Original commit files touched by this commit  1.0
glarkin search for other commits by this committer
- Fixed the fetch URL

Feature safe:   yes
05 Mar 2010 19:29:17
Original commit files touched by this commit  1.0
glarkin search for other commits by this committer
Provide mathematical, string and aggregate functions for SQL queries
using the SQLite loadable extensions mechanism.

Math functions:

  acos, asin, atan, atn2, atan2, acosh, asinh, atanh, difference,
  degrees, radians, cos, sin, tan, cot, cosh, sinh, tanh, coth,
  exp, log, log10, power, sign, sqrt, square, ceil, floor, pi

String functions:

  replicate, charindex, leftstr, rightstr, ltrim, rtrim, trim,
  replace, reverse, proper, padl, padr, padc, strfilter

Aggregate functions:

  stdev, variance, mode, median, lower_quartile, upper_quartile

WWW: http://www.sqlite.org/contrib

Submitted by:   myself (glarkin)
Feature safe:   yes

Number of commits found: 13

Login
User Login
Create account

Servers and bandwidth provided by
New York Internet, SuperNews, and RootBSD

This site
What is FreshPorts?
About the authors
Issues
FAQ
How big is it?
The latest upgrade!
Privacy
Forums
Blog
Contact

Search
Enter Keywords:
 
more...

Latest Vulnerabilities
opensslNov 02
openssl-develNov 02
wordpressNov 01
php56Oct 30
php70Oct 30
php71Oct 30
wiresharkOct 30
chromiumOct 28
wgetOct 27
wgetOct 27
openoffice-4*Oct 26
openoffice-devel*Oct 26
gitlabOct 25
nodeOct 25
node4Oct 25

1 vulnerabilities affecting 7 ports have been reported in the past 14 days

* - modified, not new

All vulnerabilities


Ports
Home
Categories
Deleted ports
Sanity Test Failures
Newsfeeds

Statistics
Graphs
NEW Graphs (Javascript)
Traffic

Calculated hourly:
Port count 31864
Broken 126
Deprecated 55
Ignore 364
Forbidden 0
Restricted 175
No CDROM 78
Vulnerable 51
Expired 11
Set to expire 47
Interactive 0
new 24 hours 2
new 48 hours3183
new 7 days3218
new fortnight3392
new month3444

Servers and bandwidth provided by
New York Internet, SuperNews, and RootBSD
Valid HTML, CSS, and RSS.
Copyright © 2000-2017 Dan Langille. All rights reserved.