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. [Database & ORM](/categories/database)
4. /
5. taitava/silverstripe-dataview

ActiveSilverstripe-module[Database & ORM](/categories/database)

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 2w 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

27

—

LowBetter than 46% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity13

Limited adoption so far

Community8

Small or concentrated contributor base

Maturity55

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

2406d 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/userforms

UserForms enables CMS users to create dynamic forms via a drag and drop interface and without getting involved in any PHP code

1321.1M92](/packages/silverstripe-userforms)[dnadesign/silverstripe-elemental

Elemental pagetype and collection of Elements

1101.1M339](/packages/dnadesign-silverstripe-elemental)[symbiote/silverstripe-advancedworkflow

Adds configurable workflow support to the CMS, with a GUI for creating custom workflow definitions.

46304.8k9](/packages/symbiote-silverstripe-advancedworkflow)

PHPackages © 2026

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