How to Query Only 2 Tables from a 68-Table Database Using Drizzle for single micro service/function?
Hi Drizzle team,
I’m building a microservice that only interacts with 2 tables, while our full database schema has 68 tables. I’d like to keep this microservice code lightweight and not have to include or maintain all 68 tables in my schema definitions.
Questions:
1. Can I use Drizzle in such a way that only the 2 relevant tables are defined/used in my code?
2. If so, how do I isolate those 2 tables without referencing the rest of the schema?
3. Are there any performance or best-practice considerations for keeping Drizzle (and the microservice) focused on just those two tables?
Any guidance or code examples would be greatly appreciated!
Thank you!
I’m building a microservice that only interacts with 2 tables, while our full database schema has 68 tables. I’d like to keep this microservice code lightweight and not have to include or maintain all 68 tables in my schema definitions.
Questions:
1. Can I use Drizzle in such a way that only the 2 relevant tables are defined/used in my code?
2. If so, how do I isolate those 2 tables without referencing the rest of the schema?
3. Are there any performance or best-practice considerations for keeping Drizzle (and the microservice) focused on just those two tables?
Any guidance or code examples would be greatly appreciated!
Thank you!
