[RCD] NoSQL Backend

Thomas Bruederli thomas at roundcube.net
Tue Apr 28 16:25:32 CEST 2015


On Tue, Apr 28, 2015 at 3:30 PM, Michael Andrews <list at airstreamcomm.net> wrote:
> Looks fairly straightforward.  The reason I am choosing to start now is the
> folks at Datastax have finally released their own supported PHP driver
> https://github.com/datastax/php-driver.  Depending on how many JOINs, or
> aggregation functions are implemented in the SQL it will make for an
> interesting data model in C*.  If anyone has some thoughts on how the
> current data is structured in SQL and how it might commute to a denormalized
> data model I would very much appreciate your input.

There's a schema published at
http://trac.roundcube.net/wiki/Dev_Docs#DatabaseSchema
Might not be 100% up-to-date but sums it up. Joins are mainly used in
address book queries (with groups). See
https://github.com/roundcube/roundcubemail/blob/master/program/lib/Roundcube/rcube_contacts.php#L213
and https://github.com/roundcube/roundcubemail/blob/master/program/lib/Roundcube/rcube_contacts.php#L303
for examples.


~Thomas


> On Apr 28, 2015, at 1:36 AM, A.L.E.C <alec at alec.pl> wrote:
>
> On 04/27/2015 06:18 PM, Michael Andrews wrote:
>
> I have been wanting for sometime to implement a Cassandra backend for
> Roundcube
>
>
> Take a look at rcube_db and rcube_db_* classes. In general you need to
> create rcube_db_cassandra class that overwrites some of rcube_db methods.
>
> If you use a PHP driver that supports CQL it should be quite
> straightforward. There are a few
> http://planetcassandra.org/client-drivers-tools/#PHP. Some are PDO
> drivers which would make the work even simpler.
>
> --
> Aleksander 'A.L.E.C' Machniak
> Kolab Groupware Developer        [http://kolab.org]
> Roundcube Webmail Developer  [http://roundcube.net]
> ---------------------------------------------------
> PGP: 19359DC1 @@ GG: 2275252 @@ WWW: http://alec.pl
> _______________________________________________
> Roundcube Development discussion mailing list
> dev at lists.roundcube.net
> http://lists.roundcube.net/mailman/listinfo/dev
>
>
>
> _______________________________________________
> Roundcube Development discussion mailing list
> dev at lists.roundcube.net
> http://lists.roundcube.net/mailman/listinfo/dev


More information about the dev mailing list