On Tue, Apr 28, 2015 at 3:30 PM, Michael Andrews <[email protected]> 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 <[email protected]> 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 > [email protected] > http://lists.roundcube.net/mailman/listinfo/dev > > > > _______________________________________________ > Roundcube Development discussion mailing list > [email protected] > http://lists.roundcube.net/mailman/listinfo/dev _______________________________________________ Roundcube Development discussion mailing list [email protected] http://lists.roundcube.net/mailman/listinfo/dev
