[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
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] System.Data.SQLite and spellfix under VB.net
Hello, thank you very much! The zip does the trick! The speed of spellfix is simply mindblowing! Cheers sonypsx -Urspr?ngliche Nachricht- Von: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-bounces at mailinglists.sqlite.org] Im Auftrag von Hick Gunter Gesendet: Donnerstag, 12. M?rz 2015 19:17 An: 'General Discussion of SQLite Database' Betreff: Re: [sqlite] System.Data.SQLite and spellfix under VB.net The zip should contain 4 files shell.c sqlite3.c sqlite3.h sqlite3ext.h sqlite-amalgamation-3080803.zip -Urspr?ngliche Nachricht- Von: sonypsx [mailto:sonypsx at gmx.net] Gesendet: Donnerstag, 12. M?rz 2015 18:56 An: 'General Discussion of SQLite Database' Betreff: Re: [sqlite] System.Data.SQLite and spellfix under VB.net Hello, may i ask again ... Can somebody help to successfully compile spellfix.c for windows? Errors see below! Cheers sonypsx -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, 04. M?rz 2015 19:54 An: 'General Discussion of SQLite Database' Betreff: Re: [sqlite] System.Data.SQLite and spellfix under VB.net Hello Joe, ok i'll tried: gcc -s -O4 -I /path/to/sqlite/headers/ -shared -o spellfix.dll spellfix.c and got this error: c:\MinGW\bin>gcc -s -O4 -I c:\Sqlite\src\ -shared -o spellfix.dll c:\Sqlite\ext \misc\spellfix.c In file included from c:\Sqlite\ext\misc\spellfix.c:17:0: c:\Sqlite\src/sqlite3ext.h:20:21: fatal error: sqlite3.h: No such file or direct ory #include "sqlite3.h" ^ compilation terminated. c:\MinGW\bin> If I look into sqlite3ext.h i see the reference to the sqlite3.h file which does not exist in the whole sqlite source (zip) which I downloaded from http://www.sqlite.org/src/info/e693e11d1b926597 Can you help me please? Best regards sonypsx -Urspr?ngliche Nachricht- Von: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-bounces at mailinglists.sqlite.org] Im Auftrag von Joe Mistachkin Gesendet: Montag, 02. M?rz 2015 22:37 An: 'General Discussion of SQLite Database' Betreff: Re: [sqlite] System.Data.SQLite and spellfix under VB.net sonypsx wrote: > > could some please post a sample how to use the spellfix module with > System.Data.SQLite under VB.net? > The first step would be to compile the spellfix extension as a loadable module, as documented here: https://www.sqlite.org/loadext.html Next, you can load it using the SQLiteConnection.LoadExtension method. Finally, you should be able to follow along with the normal spellfix docs, here: https://www.sqlite.org/spellfix1.html -- Joe Mistachkin ___ 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-users mailing list sqlite-users at mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users ___ Gunter Hick Software Engineer Scientific Games International GmbH FN 157284 a, HG Wien Klitschgasse 2-4, A-1130 Vienna, Austria Tel: +43 1 80100 0 E-Mail: hick at scigames.at This communication (including any attachments) is intended for the use of the intended recipient(s) only and may contain information that is confidential, privileged or legally protected. Any unauthorized use or dissemination of this communication is strictly prohibited. If you have received this communication in error, please immediately notify the sender by return e-mail message and delete all copies of the original communication. Thank you for your cooperation. ___ sqlite-users mailing list sqlite-users at mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] System.Data.SQLite and spellfix under VB.net
Hello, may i ask again ... Can somebody help to successfully compile spellfix.c for windows? Errors see below! Cheers sonypsx -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, 04. M?rz 2015 19:54 An: 'General Discussion of SQLite Database' Betreff: Re: [sqlite] System.Data.SQLite and spellfix under VB.net Hello Joe, ok i'll tried: gcc -s -O4 -I /path/to/sqlite/headers/ -shared -o spellfix.dll spellfix.c and got this error: c:\MinGW\bin>gcc -s -O4 -I c:\Sqlite\src\ -shared -o spellfix.dll c:\Sqlite\ext \misc\spellfix.c In file included from c:\Sqlite\ext\misc\spellfix.c:17:0: c:\Sqlite\src/sqlite3ext.h:20:21: fatal error: sqlite3.h: No such file or direct ory #include "sqlite3.h" ^ compilation terminated. c:\MinGW\bin> If I look into sqlite3ext.h i see the reference to the sqlite3.h file which does not exist in the whole sqlite source (zip) which I downloaded from http://www.sqlite.org/src/info/e693e11d1b926597 Can you help me please? Best regards sonypsx -Urspr?ngliche Nachricht- Von: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-bounces at mailinglists.sqlite.org] Im Auftrag von Joe Mistachkin Gesendet: Montag, 02. M?rz 2015 22:37 An: 'General Discussion of SQLite Database' Betreff: Re: [sqlite] System.Data.SQLite and spellfix under VB.net sonypsx wrote: > > could some please post a sample how to use the spellfix module with > System.Data.SQLite under VB.net? > The first step would be to compile the spellfix extension as a loadable module, as documented here: https://www.sqlite.org/loadext.html Next, you can load it using the SQLiteConnection.LoadExtension method. Finally, you should be able to follow along with the normal spellfix docs, here: https://www.sqlite.org/spellfix1.html -- Joe Mistachkin ___ 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] System.Data.SQLite and spellfix under VB.net
Hello Joe, ok i'll tried: gcc -s -O4 -I /path/to/sqlite/headers/ -shared -o spellfix.dll spellfix.c and got this error: c:\MinGW\bin>gcc -s -O4 -I c:\Sqlite\src\ -shared -o spellfix.dll c:\Sqlite\ext \misc\spellfix.c In file included from c:\Sqlite\ext\misc\spellfix.c:17:0: c:\Sqlite\src/sqlite3ext.h:20:21: fatal error: sqlite3.h: No such file or direct ory #include "sqlite3.h" ^ compilation terminated. c:\MinGW\bin> If I look into sqlite3ext.h i see the reference to the sqlite3.h file which does not exist in the whole sqlite source (zip) which I downloaded from http://www.sqlite.org/src/info/e693e11d1b926597 Can you help me please? Best regards sonypsx -Urspr?ngliche Nachricht- Von: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-bounces at mailinglists.sqlite.org] Im Auftrag von Joe Mistachkin Gesendet: Montag, 02. M?rz 2015 22:37 An: 'General Discussion of SQLite Database' Betreff: Re: [sqlite] System.Data.SQLite and spellfix under VB.net sonypsx wrote: > > could some please post a sample how to use the spellfix module with > System.Data.SQLite under VB.net? > The first step would be to compile the spellfix extension as a loadable module, as documented here: https://www.sqlite.org/loadext.html Next, you can load it using the SQLiteConnection.LoadExtension method. Finally, you should be able to follow along with the normal spellfix docs, here: https://www.sqlite.org/spellfix1.html -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users at mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] [ANN] SQLiteAdmin V1.3.6
Hello Peter, may i inform you that the link provided in your announcement is wrong - you end up with a 404 error. Please crosscheck: Working link: http://www.lcsql.com/sqliteadmin.html Your link: www.lcsql.com/sqliteadmin.htm I guess it?s the lower case typo ... Cheers sonypsx -Urspr?ngliche Nachricht- Von: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-bounces at mailinglists.sqlite.org] Im Auftrag von Peter Haworth Gesendet: Montag, 02. M?rz 2015 20:14 An: sqlite-users at mailinglists.sqlite.org Betreff: [sqlite] [ANN] SQLiteAdmin V1.3.6 I'm happy to announce the release of v1.3.6 of SQLiteAdmin, an SQLite Database administration tool. This is a free release for current users. SQLiteAdmin provides a GUI-based approach to creating your database schema including many capabilities not possible within the SQLite language, plus browse and edit data features. A free trial version is available at www.lcsql.com/sqliteadmin.htm <http://www.lcsql.com/sqliteadmin.html>. The complete release notes for v1.3.6 are available at http://tinyurl.com/o746roq. Some notable enhancements are: - Support for inserting and viewing BLOB columns - The ability to create database diagrams in various formats showing the foreign key relationships between tables and a list of columns and constraints in each table. - Separate preference settings for each database you open. - Open a database by drag/dropping it onto the SQLiteAdmin application window. Peter Haworth lcSQL Software www.lcsql.com ___ sqlite-users mailing list sqlite-users at mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] System.Data.SQLite and spellfix under VB.net
Hello, May I post this question again - since I did not got any reply. could some please post a sample how to use the spellfix module with System.Data.SQLite under VB.net? If i try to create the required table as documented here: <http://www.sqlite.org/spellfix1.html> http://www.sqlite.org/spellfix1.html I end up with an error: "SQL logic error or missing database no such module: spellfix1" I'm already working fine with the FullText Extensions: <http://www.sqlite.org/fts3.html> http://www.sqlite.org/fts3.html So I'm curious how to do spellfix e.g. Levenshtein in SQLite. Thanks in advance sonypsx
[sqlite] System.Data.SQLite and spellfix under VB.net
Hello, could some please post a sample how to use the spellfix module with System.Data.SQLite under VB.net? If i try to create the required table as documented here: http://www.sqlite.org/spellfix1.html I end up with an error: "SQL logic error or missing database no such module: spellfix1" I'm already working fine with the FullText Extensions: http://www.sqlite.org/fts3.html So I'm curious how to do spellfix e.g. Levenshtein in SQLite. Thanks in advance sonypsx