Re: [sqlite] Sqlite with Docker and mounted volumes
That's a good point. Thank you Keith! On Thu, Feb 2, 2017 at 12:12 AM, Keith Medcalf wrote: > If it is a remote filesystem (vs a local filesystem) then you must also > have only one connection (ever) to the database file at any given time. > Otherwise you may have issues. (Note "Single User" does not mean "Single > Connection") > > > Hi Simon. Thank you for your answer. It's single user and without > > concurrency. > > > > > > On Feb 1, 2017 18:32, "Simon Slavin" wrote: > > > > > > On 1 Feb 2017, at 5:08pm, Sebastián Guevara > > > wrote: > > > > > Hello to all. We are contemplating using SQLite from within a Docker > > > container accessing a DB on a mounted volume. > > > > Does your setup involve two or more users accessing the data at the same > > time ? It’s possible that locking won't work properly. > > > > Sorry I can’t answer your question, but the above occurred to me when I > > read it. > > > > Simon. > > ___ > > sqlite-users mailing list > > sqlite-users@mailinglists.sqlite.org > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > ___ > > sqlite-users mailing list > > sqlite-users@mailinglists.sqlite.org > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Sqlite with Docker and mounted volumes
If it is a remote filesystem (vs a local filesystem) then you must also have only one connection (ever) to the database file at any given time. Otherwise you may have issues. (Note "Single User" does not mean "Single Connection") > Hi Simon. Thank you for your answer. It's single user and without > concurrency. > > > On Feb 1, 2017 18:32, "Simon Slavin" wrote: > > > On 1 Feb 2017, at 5:08pm, Sebastián Guevara > wrote: > > > Hello to all. We are contemplating using SQLite from within a Docker > > container accessing a DB on a mounted volume. > > Does your setup involve two or more users accessing the data at the same > time ? It’s possible that locking won't work properly. > > Sorry I can’t answer your question, but the above occurred to me when I > read it. > > Simon. > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Sqlite with Docker and mounted volumes
If it is a local filesystem mounting a remote block device no problem. If it is a remote filesystem, then caveats apply (most remote/network filesystems are very broken when it comes to locking sematics) > -Original Message- > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > On Behalf Of Sebastián Guevara > Sent: Wednesday, 1 February, 2017 12:09 > To: sqlite-users@mailinglists.sqlite.org > Subject: [sqlite] Sqlite with Docker and mounted volumes > > Hello to all. We are contemplating using SQLite from within a Docker > container accessing a DB on a mounted volume. I don't expect any > performance issues if the mounted volume is a directory from the host > machine. But what if it's a shared storage, something like Flocker ( > https://clusterhq.com/flocker/introduction/)? Have anyone of you had > experience using SQLite in such an environment? I fear the degradation > will > be big, but haven't been able to test it yet. > > Regards, > > Sebastian > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Sqlite with Docker and mounted volumes
Hi Simon. Thank you for your answer. It's single user and without concurrency. On Feb 1, 2017 18:32, "Simon Slavin" wrote: On 1 Feb 2017, at 5:08pm, Sebastián Guevara wrote: > Hello to all. We are contemplating using SQLite from within a Docker > container accessing a DB on a mounted volume. Does your setup involve two or more users accessing the data at the same time ? It’s possible that locking won't work properly. Sorry I can’t answer your question, but the above occurred to me when I read it. Simon. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Sqlite with Docker and mounted volumes
On 1 Feb 2017, at 5:08pm, Sebastián Guevara wrote: > Hello to all. We are contemplating using SQLite from within a Docker > container accessing a DB on a mounted volume. Does your setup involve two or more users accessing the data at the same time ? It’s possible that locking won't work properly. Sorry I can’t answer your question, but the above occurred to me when I read it. Simon. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Sqlite with Docker and mounted volumes
Hello to all. We are contemplating using SQLite from within a Docker container accessing a DB on a mounted volume. I don't expect any performance issues if the mounted volume is a directory from the host machine. But what if it's a shared storage, something like Flocker ( https://clusterhq.com/flocker/introduction/)? Have anyone of you had experience using SQLite in such an environment? I fear the degradation will be big, but haven't been able to test it yet. Regards, Sebastian ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users