Tag: database
Why don't Silverstripe CMS queries run in MySQL?
When debugging an ORM call, you may find yourself collecting the SQL that will be exectued via the DataList::sql() function - this is great, but when copied and pasted into e.g.
Read more about 'Why don't Silverstripe CMS queries run in MySQL?'...
Read more about 'Why don't Silverstripe CMS queries run in MySQL?'...
Connect SilverStripe with another Database on the fly
Imagine you need to grab data from a legacy database, e.g. while migrating stuff to a new setup. How can you easily do that easily and elegantly?
Read more about 'Connect SilverStripe with another Database on the fly'...
Read more about 'Connect SilverStripe with another Database on the fly'...
Debugging database changes while testing
I love to use xdebug and I also love coding with unit tests. It saves me a lot of time clicking around in the backend.
Read more about 'Debugging database changes while testing'...
Read more about 'Debugging database changes while testing'...
Default Domain Route and ModelAdmin Panels on Framework Only Sites
Recently I was tasked with developing a small database driven solution and it sat perfectly in the SS framework being driven by controllers only.
Read more about 'Default Domain Route and ModelAdmin Panels on Framework Only Sites'...
Read more about 'Default Domain Route and ModelAdmin Panels on Framework Only Sites'...
Module Review : SilverGraph
One common question when getting started with silverstripe is how to see the database.
Read more about 'Module Review : SilverGraph'...
Read more about 'Module Review : SilverGraph'...
Howto fix "PDOException: SQLSTATE[HY000] [2002] No such file or directory"
Sometimes everything works fine in the browser and then you want to make a job using CLI and get an error:
Read more about 'Howto fix "PDOException: SQLSTATE[HY000] [2002] No such file or directory"'...
Read more about 'Howto fix "PDOException: SQLSTATE[HY000] [2002] No such file or directory"'...
Access external database
If you wish to access an external database either with the ORM or with a direct DB::Query you can...
Read more about 'Access external database'...
Read more about 'Access external database'...