[sqlite] System.Data.SQLite and spellfix under VB.net

[sonypsx]

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

[Keith Medcalf]

Make sure that you have all the necessary .h files in the same directory as the 
spellfix.c source code (the #include's use " " rather than < >, which means 
look in the current directory, not the include path).

Use the following command line in the directory containing source (.c) and 
header (.h) files:

gcc -mdll -s spellfix.c -o spellfix.dll

Notes:  -mthreads is not necessary.  static lib-gcc is not necessary.  This 
will generate only dependancies on KERNEL32 and the MSVCRT.DLL subsystem 
runtime.  If you want to use a specific (common) runtime, then you need to link 
that runtime.

The long form might be required for some modules:

gcc -mdll -mthreads -s -DSQLITE_API=__declspec(dllexport) -Wl,-Bstatic 
 -o  -static-libgcc

plus any special platform runtimes you want to use in preference to the 
subsystem runtime (such as msvcrt90 etc).

---
Theory is when you know everything but nothing works.  Practice is when 
everything works but no one knows why.  Sometimes theory and practice are 
combined:  nothing works and no one knows why.


>-Original Message-
>From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-
>bounces at mailinglists.sqlite.org] On Behalf Of sonypsx
>Sent: Thursday, 12 March, 2015 11:56
>To: 'General Discussion of SQLite Database'
>Subject: 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

[sqlite] System.Data.SQLite and spellfix under VB.net

[sonypsx]

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

[Hick Gunter]

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] System.Data.SQLite and spellfix under VB.net

[sonypsx]

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] System.Data.SQLite and spellfix under VB.net

[sonypsx]

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



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

[sqlite] System.Data.SQLite and spellfix under VB.net

[Joe Mistachkin]

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] System.Data.SQLite and spellfix under VB.net

[sonypsx]

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