Beefy Boxes and Bandwidth Generously Provided by pair Networks
Think about Loose Coupling

Re: Catalyst On the fly Dynamic Schema

by Your Mother (Bishop)
on Mar 16, 2012 at 13:49 UTC ( #959980=note: print w/replies, xml ) Need Help??

in reply to Catalyst On the fly Dynamic Schema

roboticus is exactly right. If your tables are identical, you can use the same DBIC schema/model for every account, just supplying the correct connection credentials to get the right DB. Dynamic schemata are quite limiting (no many_to_many auto-discovery) and a performance hit. Per user connections are possible but not the default so you'll have to hit the docs and maybe the mailing list. I've never done it or I'd give a link/example.

Sidenote: DBIC (DBIx::Class) is not Catalyst and does not ship with Catalyst and Catalyst doesn't tie you to any DB or model at all.

Update: strangely enough I came across this today in looking for something unrelated. Though I've never used it, it looks like what you want if you're running DBIC in Cat: Catalyst::TraitFor::Model::DBIC::Schema::PerRequestSchema.

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://959980]
[Corion]: This is a toy clone of Jekyll, currently named MrHyde. But maybe I'll change that name to Jokel / Yokel, or some other play on the name , still mildly unfunny ;)

How do I use this? | Other CB clients
Other Users?
Others perusing the Monastery: (9)
As of 2018-05-22 11:12 GMT
Find Nodes?
    Voting Booth?