Has anyone tried using prisma just for migrations, and using drizzle for querying on Postgres DB?
I have a postgres database used by another non JS backend and we were using drizzle to manage the schema and migrations as well as querrying it from this another BFF where drizzle is installed. But facing a lot of issues, seems like Postgres is not a priority for drizzle at the moment seeing some perpetually open issues https://github.com/drizzle-team/drizzle-orm/issues/295 that are unaddressed.
I love the query structure of drizzle and the performance gains are also nice to have. Is it advisable to use prisma just for the migrations? Has anyone had any success with this? If so how is the experience. Would really appreciate more insight into this.
I love the query structure of drizzle and the performance gains are also nice to have. Is it advisable to use prisma just for the migrations? Has anyone had any success with this? If so how is the experience. Would really appreciate more insight into this.
GitHub
It's basically the newer (and recommended) way to make auto incrementing columns. Example: create table old_way (id serial primary key); create table new_way (id integer primary key generated a...
