BSD Ports

databases/sqlite-ext-miscfuncs 1.1_3 FreeBSD

Math, string, and aggregate function library for SQLite

System
FreeBSD
Repository
FreeBSD ports
Maintainer
[email protected]
Categories
databases
Package size
11.7 KiB, 34.9 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

SystemPortVersion
FreeBSDdatabases/sqlite-ext-miscfuncs1.1_3
DragonFlydatabases/sqlite-ext-miscfuncs1.1_2
HardenedBSDdatabases/sqlite-ext-miscfuncs1.1_3
GhostBSDdatabases/sqlite-ext-miscfuncs1.1_3

Install

Binary package:

pkg install sqlite-ext-miscfuncs

From the ports tree:

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

To depend on this port in another port's Makefile:

RUN_DEPENDS=	sqlite-ext-miscfuncs>0:databases/sqlite-ext-miscfuncs

Packages

The version each package repository carries. “-” means the repository builds no package of it, “n/a” that there is no such repository.

Repositoryaarch64amd64armv6armv7i386
FreeBSD:14:latest1.1_31.1_31.1_21.1_21.1_3
FreeBSD:14:quarterly1.1_31.1_3n/a1.1_21.1_3
FreeBSD:15:latest1.1_31.1_3n/a1.1_21.1_2
FreeBSD:15:quarterly1.1_31.1_3n/an/an/a
FreeBSD:16:latest1.1_31.1_3n/an/an/a
FreeBSD:16:quarterlyn/an/an/an/an/a

Dependencies

The Makefile names none itself; they come from USES and USE_*.

The full lists below include those, and their dependencies in turn.

Build dependencies 4
Run dependencies 4

No port depends on this one.

Configuration

Options name: databases_sqlite-ext-miscfuncs

OptionDefaultDescription
DOCSoffBuild and/or install documentation
USES
localbase sqlite
Service scripts
none

Message after installing

===>   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

Files

distinfo 1
FileSizeSHA256
sqlite-ext/extension-functions-1.1.c52188991b40fe8b2799edc215f7260b890f14a833512c9d9896aa080891330ffe4052
Master sites 2
  • http://www.sourcehosting.net/freebsd/distfiles/
  • LOCAL/glarkin

Commit history 0

No commits in the history this site was built from.