Sqlite3-pcre2: Regex Extension

This is sqlite3-pcre2, an extension for sqlite3 that uses libpcre2 to provide the REGEXP() function.

The original source code was written by Alexey Tourbin and can be found at: http://git.altlinux.org/people/at/packages/?p=sqlite3-pcre.git

Build

Prerequisite

Debian

sudo apt-get install \
    libsqlite3-dev \
    libpcre2-dev

Installation

git clone https://github.com/christian-proust/sqlite3-pcre2
cd sqlite3-pcre2
make
make install

Development

The tests and the documentation can be generated using:

make check
make doc

See test documentation.

Usage

REGEXP instruction

-- Test if asdf starts with the letter A with the case insensitive flag
SELECT 'asdf' REGEXP '(?i)^A'
; -- => 1
-- Test if asdf starts with the letter A
SELECT 'asdf' REGEXP '(?i)^A'
; -- => 0

PCRE2 library

The documentation of the PCRE2 library can be found at: http://pcre.org/.

The regular expression syntax documentation can be found https://perldoc.perl.org/perlre.

Changelog

2021 UPDATE

Rename the lib from pcre.so to pcre2.so.
Use the libpcre2 instead of libpcre.
Handle a NULL value for both pattern and subject.
Handle a NULL character into a string.

2020 UPDATE

Updated to work with MacOS. Modified the Makefile to compile and install on MacOS, changed C source code to get rid of "no string" error. (credit to @santiagoyepez for a less hacky fix of explicitly checking for nulls)

2006-11-02 Initial version