[Digikam-users] Mysql/MariaDb database expert needs...

[Michael Rasmussen]

Are you using MySql, the now Oracle owned product, or MariaDB the MySql fork 
that the original developers of MySql started after they weren't happy with
life at Oracle.


On Thu, Nov 12, 2015 at 03:26:45PM +0100, Gilles Caulier wrote:
> 2015-11-12 15:15 GMT+01:00 Myriam Schweingruber <myriam at kde.org>:
> 
> > Hi all,
> >
> > seems I posted from the wrong address the first time...
> >
> > On Thu, Nov 12, 2015 at 10:55 AM, Gilles Caulier
> > <caulier.gilles at gmail.com> wrote:
> > > At least, somebody can said me if an internal Mysql solution is suitable
> > or
> > > not without to hack the DB installation outside digiKam.
> > >
> > > I read all bugzilla entries, and to setup Mysql, users need to grant
> > > privileges by hand before to configure digiKam with it.
> > >
> > > This is not possible to do the same with an internal server, since few
> > years
> > > ago, Mysql switch DB engine to ImmoDB which require granted privilege to
> > > create DB indexes. And this is typically the problem that i can see when
> > i
> > > want to create the MySql DB through the internal server.
> > >
> > > If i look how Amarok do with Mysql, internal server solution do not
> > exist.
> > > Only a remote server is avaialble in setup.
> >
> > That is not correct, Amarok uses MySQL embedded by default, setting up
> > an external MySQL server is just an additional option for people who
> > need to share a database across computers.
> >
> 
> Ah, it's not SQlite... Interesting...
> 
> So my question is : how to create DB indexes and triggers with an internal
> solution. When i look in bugzilla, some users have investigated and see
> that mysql indexes creation need granted privileges since immodb DB engine
> is used. And this is true : i reproduced the dysfunction and fixed it.
> 
> Or perhaps Amarok do not use Indexes and triggers. In this case, DB
> performances will just down...
> Or perhaps Amarok do not use immodb engine...
> 
> Gilles Caulier

> _______________________________________________
> Digikam-users mailing list
> Digikam-users at kde.org
> https://mail.kde.org/mailman/listinfo/digikam-users


-- 
      Michael Rasmussen, Portland Oregon  
    Be Appropriate && Follow Your Curiosity
Read enough of the top-10 lists that American movie critics put together
and you might wonder whether a single damn film worth watching came out
before the first of October.
    ~ Andrew O'Hehir