search

o1lab / xmysql

xmysql is now https://github.com/nocodb/nocodb
https://github.com/nocodb/nocodb
MIT License
174 stars 55 forks source link

Is there a way to generate API only on specified tables ? We do have ignoreTables option. #9

Open efrenette11 opened 6 years ago

efrenette11 commented 6 years ago

In fact I"m wondering this because on my BD, XMYSQL takes 185 seconds to be started. Is there a way to improve the speed... to really be the speed of my thought :-)

BTW super project. It will be very interesting to have the same thing for oracle.

o1lab commented 6 years ago

185 seconds - no good!

Could you please mention about the schema like how many tables in it and versions of mysql, os, node etc.

Are you using mysql from docker? in some cases docker mysql takes a little more time but 3+ minutes is new.

Generating APIs only for tables required will be feature going ahead.

extremeshok commented 6 years ago

@efrenette11 If you use my docker image https://hub.docker.com/r/extremeshok/xmysql-https-auth/ You can specify the environment variable : API_FILTERTABLES This is a comma delimitated list of tables to include for the api, all tables NOT listed will be ignored. ie. it generates a list of tables to ignore at run time.

Bnaya commented 5 years ago

I'm also interested in this feature. it be able to expose only small part of my tables. Using blacklist just force me to create long list, that i need to keep upto date, or write code that do that