Am Mi., 23. Jan. 2019 um 18:23 Uhr schrieb Jens Alfke <j...@mooseyard.com>:

>
>
> > On Jan 23, 2019, at 8:27 AM, Carsten Müncheberg <
> carsten.muencheb...@gmail.com> wrote:
> >
> > A host application (which is a black box for me I cannot change) is
> loading
> > my plugin binaries which each have SQLite linked statically. When two
> > plugins now access the same database file from the process of the host
> > application none of the serialization mechanisms (file lock, mutex)
> works,
> > and my database file will get corrupted eventually.
>
> Build SQLite as a dynamic library, and link each of your plugins with it
> dynamically. (You may need an installation process that copies the SQLite
> library to a known location where each plugin can find it.)
> Then there’s only one instance of SQLite, and locking should work properly.
>
> (And if the platform is macOS or iOS, consider using the built-in system
> copy of SQLite instead of your own; that makes it even easier.)
>
> —Jens
>
> Yes, I was considering that, but wasn't sure if it would make a
difference, so I thought I'd better ask first.

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

Reply via email to