Beefy Boxes and Bandwidth Generously Provided by pair Networks
Just another Perl shrine

Re: Catalyst On the fly Dynamic Schema

by Your Mother (Chancellor)
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.

Comment on Re: Catalyst On the fly Dynamic Schema

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://959980]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others wandering the Monastery: (8)
As of 2016-05-27 17:24 GMT
Find Nodes?
    Voting Booth?