[Kde-pim] Akonadi and PostgreSQL

[Maciej Mrozowski]

On Friday 12 of March 2010 05:58:02 Brian DeRocher wrote:

> (3) I wonder if you need postgresSearchPath at all.  Can we call
> pg_config --bindir? ... Ugh just saw that it belongs to the
> postgresql-server-dev-8.4 package, nevermind.

Hmm, why not just use server executable found in PATH? This way you don't 
interfere in alternatives mechanism in various Linux distributions (for those 
who provide multiple postgresql installation on the same system), and server 
binary is usually in PATH anyway. This may not be the case on Windows however.

> 5) It would be nice to give akondi a schema in an existing database.
> This way i could join with other schemas like krecipe and amarok and
> make that useful... somehow.

Since MySQL does not support schemas, it would need prefixing all table names 
with schema name for PostgreSQL codepath in akonadi. While it should be simple 
to do, it only makes any sense for external akonadi PostgreSQL db. Allowing 
user-specified schema name also requires proper quoting and such (mixed case 
names).

> (6) I think i read the akondi database is usually local, but may be
> remote.  The idea of a remote database is very appealing.  I could
> configure both my laptop at home and my computer at work to connect to
> the same database.  Is that possible?  It would be nice in an enterprise
> environment to have one central database for all employees.  Assuming
> this to be true, we'd have to provide the dba with a script to
> initialize the schemas.  As a strict dba myself, i'm not a fan of having
> applications create their own tables.

I think there's little point in using remote akonadi database instance since 
PIM resources (calendars, contacts) are stored locally as files anyway. 
Akonadi is *not* groupware server, it's "just" PIM resource abstraction layer 
and uses database for resource cache. (One would of course argue whether 
database server is the most appropriate/easiest way to store cache, it's not 
the subject of discussion).

-- 
regards
MM
_______________________________________________
KDE PIM mailing list kde-pim at kde.org
https://mail.kde.org/mailman/listinfo/kde-pim
KDE PIM home page at http://pim.kde.org/