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
| System | Port | Version |
|---|---|---|
| FreeBSD | databases/sqlite-ext-miscfuncs | 1.1_3 |
| DragonFly | databases/sqlite-ext-miscfuncs | 1.1_2 |
| HardenedBSD | databases/sqlite-ext-miscfuncs | 1.1_3 |
| GhostBSD | databases/sqlite-ext-miscfuncs | 1.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.
| Repository | aarch64 | amd64 | armv6 | armv7 | i386 |
|---|---|---|---|---|---|
| FreeBSD:14:latest | 1.1_3 | 1.1_3 | 1.1_2 | 1.1_2 | 1.1_3 |
| FreeBSD:14:quarterly | 1.1_3 | 1.1_3 | n/a | 1.1_2 | 1.1_3 |
| FreeBSD:15:latest | 1.1_3 | 1.1_3 | n/a | 1.1_2 | 1.1_2 |
| FreeBSD:15:quarterly | 1.1_3 | 1.1_3 | n/a | n/a | n/a |
| FreeBSD:16:latest | 1.1_3 | 1.1_3 | n/a | n/a | n/a |
| FreeBSD:16:quarterly | n/a | n/a | n/a | n/a | n/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
| Option | Default | Description |
|---|---|---|
| DOCS | off | Build and/or install documentation |
- USES
- localbase sqlite
- Service scripts
- none
Message after installing
Files
distinfo 1
| File | Size | SHA256 |
|---|---|---|
| sqlite-ext/extension-functions-1.1.c | 52188 | 991b40fe8b2799edc215f7260b890f14a833512c9d9896aa080891330ffe4052 |
Master sites 2
- http://www.sourcehosting.net/freebsd/distfiles/
- LOCAL/glarkin
Commit history 0
No commits in the history this site was built from.