Beefy Boxes and Bandwidth Generously Provided by pair Networks
laziness, impatience, and hubris

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.

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://959980]
[Happy-the-monk]: Good morning! "You have 666 points until level ..." - alright then, prepare for the worst.

How do I use this? | Other CB clients
Other Users?
Others exploiting the Monastery: (5)
As of 2017-12-18 10:05 GMT
Find Nodes?
    Voting Booth?
    What programming language do you hate the most?

    Results (476 votes). Check out past polls.