Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?
 
PerlMonks  

Re: Catalyst On the fly Dynamic Schema

by Your Mother (Canon)
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?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others meditating upon the Monastery: (6)
As of 2014-12-19 06:39 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    Is guessing a good strategy for surviving in the IT business?





    Results (72 votes), past polls