Prisma

If you are wanting to use postgres inherited tables, what is the best way to manage that with prisma migrate? or if you are using that does that mean you can’t really use prisma migrate?

Anyone have a good pattern for using postgres inherited tables with prisma migrate? Is this even possible or just asking for trouble?

If not, what are you using to track db schema changes

<@U02U6RJMUNM> :wave:
PostgreSQL Table inheritance is not yet supported by Prisma Migrate. Here is the <https://www.prisma.io/docs/reference/database-reference/database-features#misc|Database features matrix> which gives an overview of Table Inheritance feature across all Prisma Supported Databases

There is a similar <https://github.com/prisma/prisma/issues/2506|feature request> which might be of interest for you. If it is then leaving a :+1: would help prisma team in prioritising it.

Yeah for me I kind of like some of the features the postgres inheritance uses. Specially being able to have common data on a single table, so if I have multiple types inherited I can do things like build a global list easily or a global search for multiple types.  From what I see in the feature request, that is also needed but keeping the prisma schema much simpler while enforcing consistency across your models.