Sqlite with Docker and mounted volumes

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|

Sqlite with Docker and mounted volumes

Sebastián Guevara
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
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: Sqlite with Docker and mounted volumes

Simon Slavin-3

On 1 Feb 2017, at 5:08pm, Sebastián Guevara <[hidden email]> 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
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: Sqlite with Docker and mounted volumes

Sebastián Guevara
Hi Simon.  Thank you for your answer. It's single user and without
concurrency.


On Feb 1, 2017 18:32, "Simon Slavin" <[hidden email]> wrote:


On 1 Feb 2017, at 5:08pm, Sebastián Guevara <[hidden email]>
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
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: Sqlite with Docker and mounted volumes

Keith Medcalf
In reply to this post by Sebastián Guevara

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:[hidden email]]
> On Behalf Of Sebastián Guevara
> Sent: Wednesday, 1 February, 2017 12:09
> To: [hidden email]
> 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
> [hidden email]
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users



_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: Sqlite with Docker and mounted volumes

Keith Medcalf
In reply to this post by Sebastián Guevara
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" <[hidden email]> wrote:
>
>
> On 1 Feb 2017, at 5:08pm, Sebastián Guevara <[hidden email]>
> 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
> [hidden email]
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> _______________________________________________
> sqlite-users mailing list
> [hidden email]
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users



_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: Sqlite with Docker and mounted volumes

Sebastián Guevara
That's a good point. Thank you Keith!

On Thu, Feb 2, 2017 at 12:12 AM, Keith Medcalf <[hidden email]> 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" <[hidden email]> wrote:
> >
> >
> > On 1 Feb 2017, at 5:08pm, Sebastián Guevara <[hidden email]
> >
> > 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
> > [hidden email]
> > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> > _______________________________________________
> > sqlite-users mailing list
> > [hidden email]
> > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
>
>
> _______________________________________________
> sqlite-users mailing list
> [hidden email]
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users