On Oct 11, 1:59 am, "Joe Mistachkin" <[email protected]> wrote:
> Wamiduku wrote:
>
> I suppose the setup could uninstall the VC++
> runtime; however, it's typically considered "bad form" to do so (since
> it's officially a "shared" component).

I agree that the uninstall had better leave it there.

> > One solution to this dependency problem would be to add the VC redist
> > dlls to any portable SQLite app you make, but the redist is 19 dlls
> > and 11MB, so that's not very neat.
>
> I agree, several people have expressed concern about this issue both on
> this mailing list and on the project ticket tracker.

Not a problem though, since you can use the static SQLite DLL, which I
didn't know existed.

> > Rebuilding Sys.Data.SQLite with statically linked C++ libs, so that it
> > becomes standalone, would be a better solution. What would I need to
> > change in the VS2010 project in order to do that?
>
> Nothing.  There are already "Static" projects in the solutions.  Simply
> [also] build the projects named "SQLite.Interop.Static.<year>" in one of
> the solutions.
>
> The resulting binaries will be present in the:
>
>         <root>\bin\<year>\<platform>\<config>Static

Holy hexadecimals, I feel like a moron for wasting all that time with
virtual machines and looking through Thinapp logs to track changes,
when the statically linked Sys.Data.SQLite DLL was just a rebuild
away! Gotta laugh at that ;-).

There's a case that's probably rare, but could be good to be aware of
anyway; Since the name and version is the same for both the static and
non static Sys.Data.SQLite DLL, if there's a Sys.Data.SQLite in the
GAC, .NET will load it and ignore any Sys.Data.SQLite in the app
directory.

So, if any sloppily written app installs a non static Sys.Data.SQLite
in the GAC, but doesn't install the VC runtime, any app with a static
SQLite in the app directory will stop working.

Maybe making the static Sys.Data.SQLite the default version could be
an idea to consider? Not being dependent on a previous VC runtime
installation would emphasize the self-contained and configuration-less
nature of SQLite.

-John
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to