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

Popular posts from this blog

java - UnknownEntityTypeException: Unable to locate persister (Hibernate 5.0) -

python - ValueError: empty vocabulary; perhaps the documents only contain stop words -

ubuntu - collect2: fatal error: ld terminated with signal 9 [Killed] -