On Tue, Apr 28, 2015 at 3:30 PM, Michael Andrews list@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... and https://github.com/roundcube/roundcubemail/blob/master/program/lib/Roundcube... for examples.
~Thomas
On Apr 28, 2015, at 1:36 AM, A.L.E.C alec@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@lists.roundcube.net http://lists.roundcube.net/mailman/listinfo/dev
Roundcube Development discussion mailing list dev@lists.roundcube.net http://lists.roundcube.net/mailman/listinfo/dev