On Jun 15, 8:06 am, François Beausoleil <[email protected]> wrote: > Hi all! > > I'm thinking of building a multi-tenant SaaS application, with one > database per tenant. In the global config, I'll store the a Sequel > connection string for each tenant, thus when a request comes in, I'll > have to establish a connection. Two questions immediately popped up: > > * Will Sequel cache connections per connection string by default, or > should I implement that myself; > * How will my Sequel models behave? Can I even use models? > > I don't anticipate millions of users: I'm aiming for 500-1000 tenants, > each with one to 5 simultaneous users. > > Any ideas / pointers appreciated.
You can use the sharding support to do this, assuming the same schema is used in all databases: http://sequel.rubyforge.org/rdoc/files/doc/sharding_rdoc.html Jeremy -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sequel-talk?hl=en.
