databases/sqlite-ext-miscfuncs 1.1_2 DragonFly

Math, string, and aggregate function library for SQLite

System: DragonFly
Repository: DPorts
Maintainer: [email protected] (as in FreeBSD)
Categories: databases
Package size: 11.0 KiB, 33.3 KiB installed

Description

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

In the other systems

System

Port

Version

DragonFly

databases/sqlite-ext-miscfuncs

1.1_2

FreeBSD

databases/sqlite-ext-miscfuncs

1.1_3

Install

Binary package:

pkg install sqlite-ext-miscfuncs

From DPorts:

cd /usr/dports/databases/sqlite-ext-miscfuncs && make install clean

Dependencies

Run dependencies 1

databases/sqlite3

No port depends on this one.

Configuration

No options to configure.

Service scripts: none

Message after installing

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.

===>   NOTICE:

The sqlite-ext-miscfuncs port currently does not have a maintainer. As a result, it is
more likely to have unresolved issues, not be up-to-date, or even be removed in
the future. To volunteer to maintain this port, please create an issue at:

https://bugs.freebsd.org/bugzilla

More information about port maintainership is available at:

https://docs.freebsd.org/en/articles/contributing/#ports-contributing