I am trying to interface Yancy to a pre-existing Postgres DB with over 900 tables. But I am only interested in 4 tables, for which I have written the schemas in my config file. Could you maybe setup the config reader to read only the tables in the config file rather than read the entire schema from the DB, which currently fails because other tables created by other users have consistency issues (which do not affect the tables I am interested in), and also reading all that info takes a long time (tens of seconds). The 'x-ignore' property does not seem to work for this case. Also, I cannot use mojolicious migrations ( I do not have permissions to create tables in the DB, since it is a production DB).
I am using Yancy version 1.088 and perl 5, version 30, subversion 0 (v5.30.0)
Hi Folks:
I am trying to interface Yancy to a pre-existing Postgres DB with over 900 tables. But I am only interested in 4 tables, for which I have written the schemas in my config file. Could you maybe setup the config reader to read only the tables in the config file rather than read the entire schema from the DB, which currently fails because other tables created by other users have consistency issues (which do not affect the tables I am interested in), and also reading all that info takes a long time (tens of seconds). The 'x-ignore' property does not seem to work for this case. Also, I cannot use mojolicious migrations ( I do not have permissions to create tables in the DB, since it is a production DB).
I am using Yancy version 1.088 and perl 5, version 30, subversion 0 (v5.30.0)
Thanks, --greg