Jump to:

17452 Posts in 4473 Topics by 1971 members


SilverStripe Forums » Archive » Silverstripe for UI, but external database

Our old forums are still available as a read-only archive.

Moderators: martimiz, Sean, biapar, Willr, Ingo, simon_w

Page: 1
Go to End
Author Topic: 1286 Views
  • mikehenrty
    Community Member
    2 Posts

    Silverstripe for UI, but external database Link to this post


    We are implementing a multi-functional data-driven website, and we are planning to use Silverstripe/Sapphire as the CMS/Framework. The issue that we have been struggling with is this:

    We already have a fully-fleshed out database schema, and we are planning on implementing a db api that will utilize a mix of stored procedures and php coded business logic to interact with the data. We are doing this so that other applications can interface with the same db, and if we ever change our business rules, we only have to change it in one place. So ideally we want to create our api first, and have our framework interact with this api, or perhaps write SS classes to interact directly with those db tables.

    So is Silverstripe the right solution for this situation? As I understand it, the SS db is built using the DataObject classes as definitions, but we want a situation where the framework model interacts with pre-exiting tables. Is this possible in SS?

    Also, if SS would be good for this situation, would it be beneficial or necessary to have our api classes implement DataObjectInterface so that Silverstripe can recognize and interact with our objects? Are there any good examples out there showing how to properly implement DataObjectInterface?

    Any advice you SS gurus can give me would be greatly appreciated.

    Thank you in advance,

  • Ingo
    Forum Moderator
    801 Posts

    Re: Silverstripe for UI, but external database Link to this post

    you'll run into problems when trying to use the sapphire object relational model without the database tables it expects. i think you're on the right track with building the external api first (controller layer), but that's not necessarily connected to building the datalayer without silverstripe. its pretty easy to build a silverstripe datamodel without any views to it

Page: 1
Go to Top

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.