CVE and update status of the FreeBSD ports tree3,864 unaddressed CVEs in 671 portsAll times are CET
Port details

databases/sqlite-ext-pcre 20100208_2

Regexp function for SQLite based on PCRE library

Port info

Maintainer
vivek@khera.org
Packages
latest: 20100208_2
Upstream
up to date
Last update
to 20100208_2 · fb16dfecae
Quarterly
2026Q4: 20100208_2
WWW
https://github.com/ralight/sqlite3-pcre
Links
cgit · VuXML

Install

Package
# pkg install sqlite-ext-pcre
installs 20100208_2 from latest; from quarterly (2026Q4) 20100208_2
Port
# cd /usr/ports/databases/sqlite-ext-pcre && make install clean
Size
3.9 KiB download · 6.6 KiB installed
Depends on
databases/sqlite3 3.53.4,1, devel/pcre 8.45_4
License
PD
pkg-message
Shown 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 rebuild the sqlite3 program to allow
loadable extensions.

Packages by version and architecture

latest

FreeBSD versionamd64aarch64i386
FreeBSD 1620100208_220100208_2–
FreeBSD 1520100208_220100208_2–
FreeBSD 1420100208_220100208_220100208_2

quarterly (2026Q4)

FreeBSD versionamd64aarch64i386
FreeBSD 1520100208_220100208_2–
FreeBSD 1420100208_220100208_220100208_2

version as in the ports tree (latest) or the most common one (quarterly) · different version · ✗ not built · – no packages for this platform. Package sets that have not been rebuilt for 60 days are left out.

Unaddressed and VuXML only (0)

No unaddressed CVE and nothing reported by pkg audit for the packaged version 20100208_2.

Fixed (0)

No VuXML entries for this package.

Problem reports (0) · open in Bugzilla, most recently changed first

None.

Commits (13)

Stefan Eßer (se) · 20100208_2
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)
fb16dfecae
Stefan Eßer (se) · 20100208_2
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.

This commit implements such a proposal and moves one of the WWW: entries
of each pkg-descr file into the respective port's Makefile. A heuristic
attempts to identify the most relevant URL in case there is more than
one WWW: entry in some pkg-descr file. URLs that are not moved into the
Makefile are prefixed with "See also:" instead of "WWW:" in the pkg-descr
files in order to preserve them.

There are 1256 ports that had no WWW: entries in pkg-descr files. These
ports will not be touched in this commit.

The portlint port has been adjusted to expect a WWW entry in each port
Makefile, and to flag any remaining "WWW:" lines in pkg-descr files as
deprecated.

Approved by:		portmgr (tcberner)
b7f05445c0
Mathieu Arnold (mat) · 20100208_2
One more small cleanup, forgotten yesterday. Reported by:	lwhsu
cf118ccf87
Mathieu Arnold (mat) · 20100208_2
Remove # $FreeBSD$ from Makefiles.
305f148f48
Mathieu Arnold (mat) · 20100208_2
Convert to UCL & cleanup pkg-message (categories d)
78d1aff1fc
Yuri Victorovich (yuri) · 20100208_2
databases/sqlite-ext-pcre: Remove USE_LDCONFIG

SQLite extensions are loaded with the full path to the shared library.

Approved by:	portmgr (port compliance, infrastructure)
8220db01a8
Dmitry Marakasov (amdmi3) · 20100208_1
- Pet portlint - Add LICENSE - Cosmetic fixes - Unsilence installation commands

Approved by:	portmgr blanket
e4e666ef51
Tijl Coosemans (tijl) · 20100208_1
Remove libpcre.so.3 compatibility link that was added in r374303 to prevent massive PORTREVISION bumps.  Bump dependent ports that have not been bumped since.
1b6b6d972f
Mathieu Arnold (mat) · 20100208
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
21bc5c0345
Mathieu Arnold (mat) · 20100208
Remove ${PORTSDIR}/ from dependencies, categories d, e, f, and g.

With hat:	portmgr
Sponsored by:	Absolight
4e1b79a0a6
Mathieu Arnold (mat) · 20100208
Update ports in the [bcd]* categories to not use GH_COMMIT.

With minor cleanups to make things simpler.

With hat:	portmgr
Sponsored by:	Absolight
c6457ffef4
Baptiste Daroussin (bapt) · 20100208
Cleanup plist
3f86adbc94
Kurt Jaeger (pi) · 20100208
New port: databases/sqlite-ext-pcre

This is sqlite3-pcre, an extension for sqlite3 that uses libpcre to
provide a regexp() function to use with the REGEXP operator.

PR:		190121
Submitted by:	Vick Khera <vivek@khera.org>
4194772074