How to use REGEXP operator?

[omicronlab]

Quoting from the sqlite doc:

http://www.sqlite.org/lang_expr.html#regexp

The REGEXP operator is a special syntax for the regexp() user function. No regexp() user function is defined by default and so >use of the REGEXP operator will normally result in an error message. If a application-defined SQL function named "regexp" is >added at run-time, that function will be called in order to implement the REGEXP operator.

Is it possible to add this custom function in node-sqlite3 to support REGEXP operator in sql queries?

[kkaefer]

Looks like this could be added by node-sqlite3, e.g. using v8's RegExp or boost regular expressions. I'd be happy to accept a pull request that adds this to node-sqlite3.

[omicronlab]

Adding custom function with sqlite3_create_function seems intuitive, a quick googling shows python/rails users can write their own custom functions pretty easily:
http://stephen-veit.blogspot.com/2009/03/implementing-regexp-in-sqlite3.html
http://stackoverflow.com/questions/5365451/problem-with-regexp-python-and-sqlite

Problem is node-sqlite3 doesn't expose this API, and I haven't hacked into native node modules so far. Where should I start?

[kkaefer]

Closing in favor of #140.

[slawo]

+1 Would it be possible to add a regexp function in the default node package?

[Mithgol]

See #140 (comment)