[Kde-pim] akonadi with postgresql (patch)

[Javier Goday]

Ok, i post it in reviewboard http://reviewboard.kde.org/r/797/.
Thanks both for the answer.

2009/6/7 Tom Albers <toma at kde.org>

> Op Sunday 07 June 2009 18:21 schreef u:
> > Well,
> >
> > Nobody are working on that and we are very interested on that work :>
> > Volker Krause can review better, but for me look likes good.
> >
> > Javier Goday <jgoday at gmail.com> wrote:
> >
> > > De: Javier Goday <jgoday at gmail.com>
> > > Assunto: [Kde-pim] akonadi with postgresql (patch)
> > > Para: kde-pim at kde.org
> > > Data: Domingo, 7 de Junho de 2009, 12:18
> > > Hi,
> > >
> > > i was trying to set akonadi working with postgresql,
> > > i made a patch for it (attached)
> > >
> > > to make it work i manually change configuration in
> > > ~/.config/akonadi/akonadiserverrc
> > > and creating the database (createuser and createdb ...)
> > > [%General]
> > > Driver=QPSQL
> > > SizeThreshold=4096
> > > ExternalPayload=false
> > >
> > > [QPSQL]
> > > Name=akonadi
> > > User=akonadi
> > > Password=akonadi
> > > Options=
> > > StartServer=false
> > >
> > > list of changes :
> > > 1. Akonadi database description file and schema
> > > (kdesupport/akonadi/server/src/storage/akonadidb.xml and
> > > kdesupport/akonadi/server/src/storage/akonadidb.xsd)
> > >  - New element 'columnproperty' into column, to describe
> > > database type
> > > dependent properties
> > > 2. Akonadi database storage initializer
> > > (kdesupport/akonadi/server/src/storage/dbinitializer.cpp)
> > >  - When postgresql, create database relations with complete
> > > table name
> > >  - Check for database type dependent properties
> > > 3. Collection list handler
> > > (kdesupport/akonadi/server/src/handler/aklist.cpp)
> > >  - Get root collections (without parent) with null
> > > parent_id instead of 0
> > > 4. Entity header
> > > (kdesupport/akonadi/server/src/storage/entity.h)
> > >  - Include QSqlRecord header, to manually access recent
> > > inserted id when
> > > using postgresql
> > > 5. Entity xsl template (
> > > kdesupport/akonadi/server/src/storage/entities.xsl
> > > and entities-source.xsl)
> > >  - extractResult method: check if the value is null before
> > > setting it
> > >  - retrieveFiltered method: if using postgresql, when
> > > filtering by a
> > > reference column and null value, use 'is null' instead of '
> > > = 0'
> > >  - insert method: - add 'returning id' option when using
> > > postgresql to get
> > > the inserted id
> > >
> > >   - not insert 0 or null references values
> > >
> > >   - get the inserted id manually when using postgresql
> > > ( i
> > > cannot make DataStore::lastinsertid work )
> > >
> > > i don't know if postgresql support is planned or someone is
> > > working on it
> > > i will appreciate any comments, to make sure i do not make
> > > any mistake
> > > and maybe to continue with it (allowing postgresql
> > > configuration too)
> > >
> > > Thanks.
> > >
> > > -----Anexo incorporado-----
> > >
> > > _______________________________________________
> > > 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/
> >
>
> Hi,
>
> Indeed, we are very interested to get it to work on postgresql too. Looks
> like you invested some time in it already and I hope you continue to work on
> it.
>
> Would you mind posting the patch on reviewboard.kde.org, I think a couple
> of changes need some discussion and that's a lot easier over on reviewboard.
>
> Best,
>
> Toma
> --
> KDE Developer
> _______________________________________________
> 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/
>
_______________________________________________
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/