How would I go about changing the database connection on the fly with cakephp 3?
On Tuesday, September 9, 2014 3:31:47 AM UTC-5, José Lorenzo wrote: > > You can either have multiple different databses and change the connection > on the fly before you connect to it. That's not bad at all and it is not > inefficient in any way. > > The other option is to have everything in the same database with an extra > column on each table meaning the owning store. You can make the combination > of the id and the store id a primary key for the table. > > I would not recommend using table prefixes as that solution is quite > limiting and very complex to implement. > > On Tuesday, September 9, 2014 12:10:31 AM UTC+2, Chris Hickingbottom wrote: >> >> Is there a way to change Database Connections on the fly? Is it >> efficient? We have clients with multiple databases. They each contain the >> same structures, but we keep them separate to use the same classes in our >> application and security purposes. Is there a better way to do this than >> switching database connections? Perhaps have them all in one database and >> use prefixes for each table. Would I be able to change database prefixes on >> the fly? >> >> To supply more information about my situation. Our client has multiple >> stores that he needs to connect in one application. At the moment, we are >> showing each store in a different application. Because at the time he only >> had one, and now he has three. Each store has its own database. Does that >> help? >> > -- Like Us on FaceBook https://www.facebook.com/CakePHP Find us on Twitter http://twitter.com/CakePHP --- You received this message because you are subscribed to the Google Groups "CakePHP" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/cake-php. For more options, visit https://groups.google.com/d/optout.
