use -Wl,-Bstatic to force static linking (use lib<name>.a in preference to
lib<name>.dll.a when linking)
use -static-libgcc to force a static link of the gcc runtime libraries
ie
gcc -s -O3 -mwin32 -pipe -march=i686 -mtune=i686 -shared
-DSQLITE_API=__declspec(dllexport) -Wl,-Bstatic -mthreads
-DSQLITE_THREADSAFE=1 -D_HAVE_SQLITE_CONFIG_H -DSQLITE_EXTRA_INIT=core_init
-DSQLITE_CORE sqlite3x.c -lz -o SQLite3.dll
-Wl,--output-def,SQLite3.def,--out-implib,SQLite3.a
-static-libgcc
but all on one line. (your options, defines, source, and output may vary) ...
>-----Original Message-----
>From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
>boun...@sqlite.org] On Behalf Of dave
>Sent: Thursday, 25 September, 2014 11:27
>To: 'General Discussion of SQLite Database'
>Subject: Re: [sqlite] A new extension for sqlite to analyze the
>stringmetrics
>
>Update: never mind what I mentioned below; he said he is using mingw (it
>really does help to read the entire thread!)
>
>But I have tried and failed to load it (the prebuilt binary) myself; I
>notice there is a further dependency on libgcc-s-dw2-1.dll, so maybe
>that's
>the origin of Gert's problem.
>
>-dave
>
>> -----Original Message-----
>> From: sqlite-users-boun...@sqlite.org
>> [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of dave
>> Sent: Thursday, September 25, 2014 11:59 AM
>> To: 'General Discussion of SQLite Database'
>> Subject: Re: [sqlite] A new extension for sqlite to analyze
>> the stringmetrics
>>
>>
>> Gert:
>>
>> Did you build it yourself, or download a binary? Are you
>> running on XP, or
>> a later OS?
>>
>> I ask these questions because I have seen this code due to c
>> dll runtime
>> issues like (msvcrt100.dll), etc.
>> Depending on what tool was used to build the binary, some
>> changes may need
>> to be made to the build process so that the binary runs on
>> all platforms XP
>> - win8. In particular, DS2012 broke the ability to make XP-compatible
>> builds, and the builder is using that, then (s)he needs to select the
>> 'v110_xp' toolset to make a binary that runs on all platforms.
>>
>> All this is purely a guess, and could easily be wrong; I
>> can't take a peek
>> at the lib myself right now; but I mention this now on the
>> chance that it
>> saves some time debugging.
>>
>> -dave
>>
>>
>> > -----Original Message-----
>> > From: sqlite-users-boun...@sqlite.org
>> > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Gert
>> Van Assche
>> > Sent: Thursday, September 25, 2014 10:25 AM
>> > To: General Discussion of SQLite Database
>> > Subject: Re: [sqlite] A new extension for sqlite to analyze
>> > the stringmetrics
>> >
>> >
>> > Andea,
>> >
>> > Seems like a very interesting extension to me.
>> > I cannot make it run on Windows.
>> > I get error code 0xc00012f.
>> >
>> > Any idea why this is ?
>> >
>> > thanks
>> >
>> > gert
>> >
>> > 2014-09-25 10:11 GMT+02:00 Andrea Peri <aperi2...@gmail.com>:
>> >
>> > > Hi,
>> > > for who eventually interested.
>> > >
>> > > Fr a specific internal use I develope a new simple
>> > extension for sqlite.
>> > > The LibStringmetrics.
>> > > https://github.com/aperi2007/libstringmetrics
>> > >
>> > > It is based on the LibSimmetrics c lib from Johnathan Botha
>> > > - available from here:
>> https://github.com/jokillsya/libsimmetrics -
>> > > It was a porting of another java library.
>> > >
>> > > The LibStringMetrics is compile using mingw .
>> > > All is released with a GPL3 to follow the same license of
>> > the original
>> > > libsimmetrics.
>> > >
>> > > The extension is usable after the usual load_extension command:
>> > >
>> > > select load_extension("libstringmetrics.dll");
>> > >
>> > > The extension add One new command:
>> > >
>> > > stringmetrics().
>> > >
>> > > calling it without any parameters
>> > > will return a simple help of the parameters and of the available
>> > > algorithms.
>> > >
>> > > Regards,
>> > >
>> > > --
>> > > -----------------
>> > > Andrea Peri
>> > > . . . . . . . . .
>> > > qwerty àèìòù
>> > > -----------------
>> > > _______________________________________________
>> > > sqlite-users mailing list
>> > > sqlite-users@sqlite.org
>> > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>> > >
>> > _______________________________________________
>> > sqlite-users mailing list
>> > sqlite-users@sqlite.org
>> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>> >
>>
>>
>> _______________________________________________
>> sqlite-users mailing list
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>
>
>
>_______________________________________________
>sqlite-users mailing list
>sqlite-users@sqlite.org
>http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
