[Kde-pim] akonadi with postgresql (patch)

[Tom Albers]

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
-------------- next part --------------
_______________________________________________
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/