Does anyone have any advice on either building a datamodel first and thereby creating tables, vs building your database first and then introspecting it?
I’m in the process of experimenting with both paths. Using the datamodel to produce the DB, Prisma creates many join tables to create the relationships between your types. When I was thinking about my DB design before using Prisma, I had in mind to use a bunch of foreign keys on the same tables without needing many join tables. Just from a performance perspective this would seem the better way to go although introspecting the DB is more complicated and it doesn’t appear to be as easy to update the DB and the datamodel in the future.
What are the tradeoffs? When would it be more ideal to use one method over the other?