SQLite Forum

Enabling REGEXP on Windows
Login

Enabling REGEXP on Windows

(1) By anonymous on 2020-12-23 20:11:06 [link] [source]

What are the options?

Which is the easiest option?

(2) By Keith Medcalf (kmedcalf) on 2020-12-23 21:30:00 in reply to 1 [link] [source]

Compile and load the REGEXP extension found in the ext/misc directory https://www.sqlite.org/src/dir?ci=tip&name=ext/misc

(3) By anonymous on 2020-12-23 22:59:11 in reply to 2 [link] [source]

Thank you.

I assume that there is no intention in incorporate this in SQLite3.DLL. I'll try to compile & load.

(4.1) By Warren Young (wyoung) on 2020-12-24 09:32:33 edited from 4.0 in reply to 3 [source]

The whole point of SQLite extensions is to provide functionality not in the core. I'm not aware of any extension provided with the SQLite project that eventually got merged into the core.

Even the list of third-party extensions that were later made obsolete by core improvements is quite short. I can only think of one, across many years of SQLite use: ext/misc/decimal.c replacing sqlite3decimal.

(5) By tom (younique) on 2020-12-24 11:54:15 in reply to 4.1 [link] [source]

And, in current trunk, math functions. I cannot thank you enough for that!!!