[sqlite] REGEXP pcre DLL for Windows
Yes of course - the answer is: didn't even know that a default do exist. Sorry! Grabbed the regexp.c compiled it - and yes - it works - plain and simple! Thanks a lot! For the archive if someone else try to compile it: gcc -s -O4 -I c:\sqlite\src\ -shared -o c:\sqlite\bin\regexp.dll c:\sqlite\ext\misc\regexp.c -Urspr?ngliche Nachricht- Von: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-bounces at mailinglists.sqlite.org] Im Auftrag von Richard Hipp Gesendet: Dienstag, 19. Mai 2015 00:34 An: General Discussion of SQLite Database Betreff: Re: [sqlite] REGEXP pcre DLL for Windows On 5/18/15, Keith Medcalf wrote: > > Is there any reason why the default REGEXP is unsuitable? > > ext/misc/regexp.c > > in the source distribution ... > Just in case it helps to answer the above question The RE syntax recognized by regexp.c is summarized in the header comment which can be perused here: https://www.sqlite.org/src/artifact/af92cdaa5058fcec The RE syntax recognized by regexp.c is a subset of PCRE. (The languages recognized by PCRE actually go beyond true Regular Expressions - but that is a topic for purists and theoreticians.) On the other hand, the regexp.c matcher is guaranteed to run in constant time (relative to the size of the string being scanned) whereas PCREs can run in exponential time for certain pathological cases. -- D. Richard Hipp drh at sqlite.org ___ sqlite-users mailing list sqlite-users at mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] REGEXP pcre DLL for Windows
Hello Coder, yes that is working fine! Thank you! As I'm always in struggle when I try to compile such things for sqlite. Do you have a small step by step HOWTO compiled this? Especially the used gcc parameters and so ... Would be great for the future but anyway - the provided DLL is working. Thanks! Best regards Martin -Urspr?ngliche Nachricht- Von: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-bounces at mailinglists.sqlite.org] Im Auftrag von Random Coder Gesendet: Montag, 18. Mai 2015 19:59 An: General Discussion of SQLite Database Betreff: Re: [sqlite] REGEXP pcre DLL for Windows On Mon, May 18, 2015 at 9:43 AM, sonypsx wrote: > may i kindly ask again about REGEX pcre DLL for Windows? > > Do someone have an idea or even a precompiled DLL which works under sqlite? As you've found, you don't just need a pcre dll for windows, you need a sqlite3 module to implement the callbacks sqlite uses. I'm not aware if there's version generally available. I have a version I built for internal use, based off some public domain code, you can grab the source or DLL from: http://bucket-1f8c9d86.s3.amazonaws.com/sqlite3-pcre-src.zip http://bucket-1f8c9d86.s3.amazonaws.com/sqlite3-pcre.zip It works for my purposes. I can't support it beyond that, though. ___ sqlite-users mailing list sqlite-users at mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] REGEXP pcre DLL for Windows
Dear SQLite Users, may i kindly ask again about REGEX pcre DLL for Windows? Do someone have an idea or even a precompiled DLL which works under sqlite? Best regards Martin -Urspr?ngliche Nachricht- Von: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-bounces at mailinglists.sqlite.org] Im Auftrag von sonypsx Gesendet: Mittwoch, 06. Mai 2015 16:55 An: sqlite-users at mailinglists.sqlite.org Betreff: [sqlite] REGEXP pcre DLL for Windows Hello, can somebody me please and provide a working almost recent precompiled windows dll version of "pcre" which is capable to load within sqlite3? I did try hard, found some precompiled ones at http://www.airesoft.co.uk/pcre. But they cannot be loaded within sqlite3. I did the try with the version 8.33. I did tried both 32bit and 64bit version. Of course an older version produce the same error. At the end I just show that a working dll (spellfix.dll) is loading fine. I also tried to compile some pcre versions but I ended up either with errors while compiling or with the same error found below. Here is the output of my try: (as I'm using a german version I translated the error message when try to load that dll) 16.06.2013 00:30 321 536 pcre3.dll 13.03.2015 19:4833 792 spellfix.dll 13.03.2015 20:07 566 272 sqlite3.exe 03.05.2015 02:22 305 152 test2.s3db c:\sqlite.test>sqlite3.exe SQLite version 3.8.8.3 2015-02-25 13:29:11 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILENAME" to reopen on a persistent database. sqlite> .open test2.s3db sqlite> .load pcre3.dll Error: Cannot find the procedure sqlite> .load spellfix.dll sqlite> Best regards Martin ___ sqlite-users mailing list sqlite-users at mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] REGEXP pcre DLL for Windows
On 5/18/15, Keith Medcalf wrote: > > Is there any reason why the default REGEXP is unsuitable? > > ext/misc/regexp.c > > in the source distribution ... > Just in case it helps to answer the above question The RE syntax recognized by regexp.c is summarized in the header comment which can be perused here: https://www.sqlite.org/src/artifact/af92cdaa5058fcec The RE syntax recognized by regexp.c is a subset of PCRE. (The languages recognized by PCRE actually go beyond true Regular Expressions - but that is a topic for purists and theoreticians.) On the other hand, the regexp.c matcher is guaranteed to run in constant time (relative to the size of the string being scanned) whereas PCREs can run in exponential time for certain pathological cases. -- D. Richard Hipp drh at sqlite.org
[sqlite] REGEXP pcre DLL for Windows
Is there any reason why the default REGEXP is unsuitable? ext/misc/regexp.c in the source distribution ... > -Original Message- > From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users- > bounces at mailinglists.sqlite.org] On Behalf Of sonypsx > Sent: Monday, 18 May, 2015 10:44 > To: 'General Discussion of SQLite Database' > Subject: Re: [sqlite] REGEXP pcre DLL for Windows > > Dear SQLite Users, > > may i kindly ask again about REGEX pcre DLL for Windows? > > Do someone have an idea or even a precompiled DLL which works under > sqlite? > > Best regards > Martin > > -Urspr?ngliche Nachricht- > Von: sqlite-users-bounces at mailinglists.sqlite.org > [mailto:sqlite-users-bounces at mailinglists.sqlite.org] Im Auftrag von > sonypsx > Gesendet: Mittwoch, 06. Mai 2015 16:55 > An: sqlite-users at mailinglists.sqlite.org > Betreff: [sqlite] REGEXP pcre DLL for Windows > > Hello, > > can somebody me please and provide a working almost recent precompiled > windows dll version of "pcre" which is capable to load within sqlite3? > I did try hard, found some precompiled ones at > http://www.airesoft.co.uk/pcre. > But they cannot be loaded within sqlite3. I did the try with the version > 8.33. I did tried both 32bit and 64bit version. Of course an older version > produce the same error. > At the end I just show that a working dll (spellfix.dll) is loading fine. > > I also tried to compile some pcre versions but I ended up either with > errors > while compiling or with the same error found below. > Here is the output of my try: (as I'm using a german version I translated > the error message when try to load that dll) > > 16.06.2013 00:30 321 536 pcre3.dll > 13.03.2015 19:4833 792 spellfix.dll > 13.03.2015 20:07 566 272 sqlite3.exe > 03.05.2015 02:22 305 152 test2.s3db > > c:\sqlite.test>sqlite3.exe > > SQLite version 3.8.8.3 2015-02-25 13:29:11 > Enter ".help" for usage hints. > Connected to a transient in-memory database. > Use ".open FILENAME" to reopen on a persistent database. > sqlite> .open test2.s3db > sqlite> .load pcre3.dll > Error: Cannot find the procedure > sqlite> .load spellfix.dll > sqlite> > > Best regards > Martin > > ___ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > ___ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] REGEXP pcre DLL for Windows
On Mon, May 18, 2015 at 9:43 AM, sonypsx wrote: > may i kindly ask again about REGEX pcre DLL for Windows? > > Do someone have an idea or even a precompiled DLL which works under sqlite? As you've found, you don't just need a pcre dll for windows, you need a sqlite3 module to implement the callbacks sqlite uses. I'm not aware if there's version generally available. I have a version I built for internal use, based off some public domain code, you can grab the source or DLL from: http://bucket-1f8c9d86.s3.amazonaws.com/sqlite3-pcre-src.zip http://bucket-1f8c9d86.s3.amazonaws.com/sqlite3-pcre.zip It works for my purposes. I can't support it beyond that, though.
[sqlite] REGEXP pcre DLL for Windows
Hello, can somebody me please and provide a working almost recent precompiled windows dll version of "pcre" which is capable to load within sqlite3? I did try hard, found some precompiled ones at http://www.airesoft.co.uk/pcre. But they cannot be loaded within sqlite3. I did the try with the version 8.33. I did tried both 32bit and 64bit version. Of course an older version produce the same error. At the end I just show that a working dll (spellfix.dll) is loading fine. I also tried to compile some pcre versions but I ended up either with errors while compiling or with the same error found below. Here is the output of my try: (as I'm using a german version I translated the error message when try to load that dll) 16.06.2013 00:30 321 536 pcre3.dll 13.03.2015 19:4833 792 spellfix.dll 13.03.2015 20:07 566 272 sqlite3.exe 03.05.2015 02:22 305 152 test2.s3db c:\sqlite.test>sqlite3.exe SQLite version 3.8.8.3 2015-02-25 13:29:11 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILENAME" to reopen on a persistent database. sqlite> .open test2.s3db sqlite> .load pcre3.dll Error: Cannot find the procedure sqlite> .load spellfix.dll sqlite> Best regards Martin