| Port details |
- sqlite-ext-pcre Regexp function for SQLite based on PCRE library
- 20100208_2 databases
 =2      20100208_2Version of this port present on the latest quarterly branch. - Maintainer: vivek@khera.org
- Port Added: 2014-08-24 20:01:04
- Last Update: 2022-09-07 21:58:51
- Commit Hash: fb16dfe
- People watching this port, also watch:: jdictionary, py311-Automat, py311-python-gdsii, py39-PyOpenGL, p5-Sane
- License: PD
- WWW:
- https://github.com/ralight/sqlite3-pcre
- Description:
- This is sqlite3-pcre, an extension for sqlite3 that uses libpcre to provide
a regexp() function to use with the REGEXP operator.
  ¦  ¦  ¦  ¦ 
- Manual pages:
- FreshPorts has no man page information for this port.
- pkg-plist: as obtained via:
make generate-plist - Dependency lines:
-
- sqlite-ext-pcre>0:databases/sqlite-ext-pcre
- To install the port:
- cd /usr/ports/databases/sqlite-ext-pcre/ && make install clean
- To add the package, run one of these commands:
- pkg install databases/sqlite-ext-pcre
- pkg install sqlite-ext-pcre
NOTE: If this package has multiple flavors (see below), then use one of them instead of the name specified above.- PKGNAME: sqlite-ext-pcre
- Flavors: there is no flavor information for this port.
- distinfo:
- SHA256 (sqlite-ext/ralight-sqlite3-pcre-20100208-c98da41_GH0.tar.gz) = 44840bfc7fb7b6aa5397143c3f70216e3a61911528ef011d48cf54100ab06292
SIZE (sqlite-ext/ralight-sqlite3-pcre-20100208-c98da41_GH0.tar.gz) = 2414
Packages (timestamps in pop-ups are UTC):
- Dependencies
- NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
- Build dependencies:
-
- gmake>=4.3 : devel/gmake
- pkgconf>=1.3.0_1 : devel/pkgconf
- Library dependencies:
-
- libpcre.so : devel/pcre
- libsqlite3.so : databases/sqlite3
- There are no ports dependent upon this port
Configuration Options:- No options to configure
- Options name:
- databases_sqlite-ext-pcre
- USES:
- gmake pkgconfig sqlite
- pkg-message:
- For install:
- 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.
- Master Sites:
|
| Commit History - (may be incomplete: for full details, see links to repositories near top of page) |
| Commit | Credits | Log message |
|---|
07 Sep 2022 21:58:51
 |
Stefan Eßer (se) |
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) |
20100208_2
07 Sep 2022 21:10:59
|
Stefan Eßer (se) |
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.
(Only the first 15 lines of the commit message are shown above  ) |
20100208_2
07 Apr 2021 08:09:01
|
Mathieu Arnold (mat) |
One more small cleanup, forgotten yesterday.
Reported by: lwhsu |
20100208_2
06 Apr 2021 14:31:07
|
Mathieu Arnold (mat) |
Remove # $FreeBSD$ from Makefiles. |
20100208_2
13 Aug 2019 16:01:59
  |
mat |
Convert to UCL & cleanup pkg-message (categories d) |
20100208_2
10 Jun 2018 04:46:53
|
yuri |
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) |
20100208_1
21 Dec 2017 09:00:39
|
amdmi3 |
- Pet portlint
- Add LICENSE
- Cosmetic fixes
- Unsilence installation commands
Approved by: portmgr blanket |
20100208_1
08 Dec 2016 17:26:10
|
tijl |
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. |
20100208
25 Apr 2016 16:13:39
|
mat |
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 |
20100208
01 Apr 2016 14:00:57
|
mat |
Remove ${PORTSDIR}/ from dependencies, categories d, e, f, and g.
With hat: portmgr
Sponsored by: Absolight |
20100208
06 May 2015 15:16:54
|
mat |
Update ports in the [bcd]* categories to not use GH_COMMIT.
With minor cleanups to make things simpler.
With hat: portmgr
Sponsored by: Absolight |
20100208
20 Dec 2014 17:40:54
|
bapt |
Cleanup plist |
20100208
24 Aug 2014 20:00:57
|
pi |
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> |
As an Amazon Associate I earn from qualifying purchases.