[sqlite] Adding comments to a ticket

2016-10-28 Thread John Reynolds
I've submitted a ticket,
https://system.data.sqlite.org/index.html/tktview?name=d4728aecb7, and want to 
add a
comment to it. I can't find any obvious way to do it in the ticket page (I'm 
logged on as
anonymous). Is it possible?

-John
___
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-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


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

2016-09-16 Thread John Reynolds
Hi,

(Sorry if this becomes a double post - I first tried posting from Nabble)

I've compiled System.Data.SQLite.dll with the
"/property:UseSqliteStandard=true" option, so that it will load
sqlite3.dll (or it's Linux equivalent) instead of SQLite.Interop.dll.

The advantage of this is that you can run the exact same code on Windows
and Mono+Linux without resorting to using the rarely updated
Mono.Data.SQLite package (about 1.5 years old right now, and with
unfixed bugs critical to my application).

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

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