[Shotwell] mysql/postgresql as backend?

[Bengt Thuree]

Yes I can see that this ticket (D-Bus) would solve some issues.
But not the one with a family and a number of computers.

For instance, I am updating the photos from my laptop (connected to our
file server), while my wife is looking at the old photos (again, through
our file server) as well as possible publishing some photos or modifying
some tags/ratings here and there.

This would not be possible with sqlite as far as I am aware (single
program who reads), but very possible with a sql backbone.
Perhaps a function that informs all other connected clients to re-read
part/all of the database?

While on the subject of family :) Perhaps a locking feature, to ensure
children can not modify any photos/tags :)

/Bengt

On Wed, 2010-04-28 at 10:41 -0700, Jim Nelson wrote:
> We've thought down these lines, but it's not as simple as it seems.
> 
> The database is not used by Shotwell in a traditional sense, a la a
> web application.  If we hit the database every time we needed
> information about a photo or a tag or an event, Shotwell would be slow
> indeed.  This is not a limitation of SQLite; using MySQL or PostgreSQL
> would not make things different.
> 
> Much of the database is loaded into memory at startup and maintained
> there.  When a field is changed, it's written out to disk, but kept in
> memory as well.  If another application were to write to the database
> while Shotwell was running, Shotwell would have no idea the change has
> been made, and now things are messed up.
> 
> Some of this thinking is reflected in this ticket:
> http://trac.yorba.org/ticket/1699  There's a lot to think about there,
> however.
> 
> -- Jim
> 
> On Wed, Apr 28, 2010 at 7:39 AM, Bengt Thuree <bengt.thuree at gmail.com> wrote:
> > Hi
> >
> > Any thoughts/plans on coming up with a proper backend, so the database
> > can be accessed by different persons at the same time.
> >
> > I saw GnuCASH is using libdbi. Would this be of interest in Shotwell?
> >
> > In my case, I have a number of desktops/laptops/thin clients, and one
> > fileserver. I am having the photos and photo db on the file server, and
> > would like to be able to access my photos from which ever computer I
> > want, as well as from multiple computers at the same time.
> >
> > Fingers crossed for this has been thought of :)
> >
> > Bengt
> >
> > _______________________________________________
> > Shotwell mailing list
> > Shotwell at lists.yorba.org
> > http://lists.yorba.org/cgi-bin/mailman/listinfo/shotwell
> >
>