PHPackages                             taitava/silverstripe-dataview - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. taitava/silverstripe-dataview

ActiveSilverstripe-module

taitava/silverstripe-dataview
=============================

Creates MySQL views automatically during dev/build .

0.2.0(6y ago)21061MITPHPCI failing

Since Aug 29Pushed 6y ago1 watchersCompare

[ Source](https://github.com/Taitava/silverstripe-dataview)[ Packagist](https://packagist.org/packages/taitava/silverstripe-dataview)[ RSS](/packages/taitava-silverstripe-dataview/feed)WikiDiscussions master Synced 2mo ago

READMEChangelog (3)Dependencies (2)Versions (4)Used By (0)

silverstripe-dataview
=====================

[](#silverstripe-dataview)

This module allows you to create MySQL views that are automatically built and updated during the `/dev/build` process (or via a separate `BuildTask`, if you prefer not to do this during `/dev/build`).

Example:

```
class MyView extends DataView
{
	public static function getViewStatement()
        {
        	//Borrow SQL from a DataList:
        	return MyDataObject::get()->filter('SoftDeleted', false);

        	//Custom SQL:
        	return new SQLSelect(['Book.Title','Author.Name'],'Book')->addLeftJoin('Author','Book.AuthorID = Author.ID');

        	//The quick and dirty way: hard coded SQL:
        	return 'SELECT quantity, price, quantity*price AS amount FROM Product';
        }
}
```

Now just run `/dev/build` in your browser or `php framework/cli-script.php dev/tasks/UpdateDataViewsTask` in terminal. Now you have your new view defined in the database. Note that you do need to gave CREATE VIEW and DROP VIEW permissions in the database! DROP VIEW is mandatory for updating the structure of existing views.

Unfortunately this module does not currently offer any method to read data from views, but I'm planning to do some research to determine what would be the most meaningful way to achieve this.

Roadmap
-------

[](#roadmap)

For version 1.0 I would like this module to have:

- DataList style way to filter and iterate records from views
- DataObject style way to read properties from records (no write ability. Writing should be done through regular DataObjects or custom SQL commands)
- Support for SilverStripe 4.x
- A better documentation
- Probably something more...

Contribution
------------

[](#contribution)

If you have any ideas about how to improve this module or any questions, I would be glad to hear them! :) Please raise an issue or create a pull request - which ever you like.

###  Health Score

26

—

LowBetter than 43% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity13

Limited adoption so far

Community8

Small or concentrated contributor base

Maturity54

Maturing project, gaining track record

 Bus Factor1

Top contributor holds 100% of commits — single point of failure

How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window.

**Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores.

**Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement.

**Maturity (30%)** — Project age, version count, PHP version support, and release stability.

###  Release Activity

Cadence

Every ~250 days

Total

3

Last Release

2310d ago

### Community

Maintainers

![](https://www.gravatar.com/avatar/611d4d836f6db7ba7357ea174bf48ab8cf86af5ac40be4a7a6101e67267333f9?d=identicon)[taitava](/maintainers/taitava)

---

Top Contributors

[![Taitava](https://avatars.githubusercontent.com/u/13002142?v=4)](https://github.com/Taitava "Taitava (5 commits)")

---

Tags

silverstripeMySQL viewdatabase view

### Embed Badge

![Health badge](/badges/taitava-silverstripe-dataview/health.svg)

```
[![Health](https://phpackages.com/badges/taitava-silverstripe-dataview/health.svg)](https://phpackages.com/packages/taitava-silverstripe-dataview)
```

###  Alternatives

[silverstripe-terraformers/gridfield-rich-filter-header

Rich filter header component for GridField

1325.7k1](/packages/silverstripe-terraformers-gridfield-rich-filter-header)

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)