SnippetsAn alternative to _ss_environment Files for easy 'Per Environment' Configuration

9 June 2011 | Pete Bacon Darwin | SiteConfig, Database, Installing | Supports v2.4, v2.3

8 3

Although Silverstripe has a mechanism for alternative configuration per environment, using the ConfigureFromEnv() method in your mysite/_config.php file, it has its limitations and I have often read people complaining about it. Here is a simple yet powerful alternative to using SilverStripe environment files.

TutorialsCustom sorting in the CMS SiteTree

14 February 2011 | Marcus Dalgren | CMS, Site Tree, Database | Supports v2.4, v2.3

10 7

Ever wanted to sort some parts of the SiteTree? Well now you can!

SnippetsOptimizing Complex Models

4 November 2010 | Hamish Campbell | DataObjects, Database, Relations | Supports v2.4, v2.3

11 12

The SilverStripe ORM engine (Sapphire) makes working with your database a breeze, but that simplicity comes at a cost. Each database query contributes to slower page load times and a complicated data structure can create significant performance issues.

Here are a number of strategies that can be employed to improve your website query performance:

SnippetsGetting items from a has_many or many_many relation

7 October 2010 | Aram Balakjian | DataObjects, Database, Relations | Supports v2.4, v2.3

5 10

Have you ever found yourself using DataObject::get() to fetch objects in a has_many so that you can filter/sort them easily?

Well as it happens there is no need to do this thanks to a totally undocumented bit of code!

SnippetsPreventing malicious SQL injections

12 March 2010 | Daniel Hensby | Security, DataObjects, Database | Supports v2.4, v2.3

3 6

PHP has a very shallow learning curve, it's free and anyone can have a go at making a website by following a few tutorials and implementing their experience with other languages. However, coding for the web can be a risky business, especially with dynamic websites that take some kind of user (or external) input and use that to get data from a database.

TutorialsUsing SilverStripe Environment files for Database Configuration

17 February 2010 | Hamish Campbell | Database | Supports v2.4, v2.3

2 1

Wouldn't it be easy to have a single environment configuration for all your SilverStripe sites without having to reconfigure each one individually? Wouldn't it be great not to have to change environment settings when you push your site from development to live servers? This is easy to achieve using the SilverStripe "ConfigureFromEnv" script.