javascript - Sails.js - Postgresql Adapter multiple schemas -
i've been searching lot sails.js multi tenancy capabilities , know such feature not yet implemented. initial idea build multi tenant app creating 1 database per tenant.
since realized can't such thing in sails.js yet, tried different aproach creating 1 database ( postgres ) lots of schemas, each 1 representing tenant. problem can't/i dunno ( don't know if possible in sails/postgres adapter ) how dynamically ( on runtime ) define schema given object should query aganist, based on logged user.
has faced problem this? how can proceed?
sorry english , thanks.
i thinks issue of waterline sequel adapter, based in answer.
the way add property in model
meta: { schemaname: 'schema' },
but not working, can't define multiple schemas, takes user schema, if property schema set in true ins config/models.js, definition of schema every table not working.
Comments
Post a Comment