Re: [sqlite] [System.Data.SQLite] Using sqlite3.dll instead of Interop.dll - what's the trade-off?

2016-10-20 Thread John Reynolds
A follow-up on this (and a late thanks!):

I've used your answer to write some build instructions for Ubuntu and Raspbian 
at
http://blog.wezeku.com/2016/10/09/using-system-data-sqlite-under-linux-and-mono/

I've also modified the F# SQLProvider type provider so that it no longer always 
loads
Mono.Data.SQLite under Mono, but allows you to specify that System.Data.SQLite 
should be
loaded regardless of whether the platform is .NET or Mono:
http://fsprojects.github.io/SQLProvider/core/sqlite.html#SQLiteLibrary

/John

> There are various compile-options and extensions baked into the
> "SQLite.Interop.dll" that are not enabled and/or included by
> default with "sqlite3.dll".
>
> One that is somewhat important, is the "vtshim" extension.  It
> is required if you want to implement a virtual table in managed
> code.  It's also fairly tightly integrated into the resulting
> "SQLite.Interop.dll", by necessity.
>
> It is possible to compile the "SQLite.Interop.dll" for Linux,
> Mac OS X, and probably other POSIX compliant systems, using
> the following build script:
>
>   https://urn.to/r/7C
>
> --
> Joe Mistachkin @ https://urn.to/r/mistachkin

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] [System.Data.SQLite] Using sqlite3.dll instead of Interop.dll - what's the trade-off?

2016-09-16 Thread Joe Mistachkin

John Reynolds wrote:
>
> My question is: what are the trade-offs of not using
> SQLite.Interop.dll? 
> 

There are various compile-options and extensions baked into the
"SQLite.Interop.dll" that are not enabled and/or included by
default with "sqlite3.dll".

One that is somewhat important, is the "vtshim" extension.  It
is required if you want to implement a virtual table in managed
code.  It's also fairly tightly integrated into the resulting
"SQLite.Interop.dll", by necessity.

It is possible to compile the "SQLite.Interop.dll" for Linux,
Mac OS X, and probably other POSIX compliant systems, using
the following build script:

https://urn.to/r/7C

--
Joe Mistachkin @ https://urn.to/r/mistachkin

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users