I’ve posted a developer preview of Materialized Views for Drupal 6. I’d like ambitious Drupal developers to try it out so I can get feedback on the developer experience.

From sites/all/modules:
bzr branch bzr://vcs.fourkitchens.com/drupal/modules/materialized_view/6 materialized_view (all on one line)

To get them running:

  1. Install all three MV-related modules.
  2. Run cron.

This will create the mv_forum_topic materialized view, which is populated and indexed for fast Forum module topic listings.

Specific developer experience areas I’d like feedback on:

  • Creating new materialized views.
  • Creating new data sources.

If you create or modify MVs, run cron to generate the tables and index the data.