Hey everyone! I am working on a project and we are currently using Sequelize (MySQL) with TypeScript. Today, I suggested my tech lead to use Prisma instead of Sequelize because the latter one doesn't had a good TypeScript support. She's almost convinces but she has a couple of questions/concerns regarding Prisma over Sequelize: 1. As we all know, Prisma uses only one

prisma.schema

file for data modelling. Let's suppose. the application grows and so do the number of database tables. Since all the models will be in one schema file does it impact performance in any way? 2. Related to previous question, can we separate models in

prisma.schema

file across multiple "schemas"? Thanks!

Hey there! 1. Performance is not affected by the size of the schema as it just maps to the underlying database. 2. Currently there is no way to split the schema into multiple files, however it is on the roadmap. I have built a library called Aurora that can handle split schemas, however it is not a 1-1 mapping to Prisma’s capabilities and still has some kinks. Would not call Aurora production ready by any means

Here’s the official GitHub Feature Request for adding support for splitting Prisma schema into multiple files: #2377 I would suggest subscribing to the Feature Request so that you are updated about the progress on the Feature.