Prisma

Hi. I am running Prisma with PostgreSQL. Is there a way to have custom queries for CREATE TABLE and for INSERT ?

I would like to have a primary key that uses 4 columns

And I have many documents to upsert into the DB at once (like hundreds/thousands).

I know there's a ticket for the index support, but I'm looking for a way to have this now, because otherwise my app doesn't work :disappointed:

afaik you can always run raw custom queries

<https://www.prisma.io/docs/prisma-graphql-api/reference/raw-database-access-qwe4/>

Seems like a "proceed with caution" feature

Thanks a lot :slightly_smiling_face: I will have caution. I can `INSERT INTO olhcv_${base}_${quote}_${period} ...` like this. That would be a nice solution. One table per period per market :slightly_smiling_face:. I'd only need a primary key index on the `timestamp` per table.

Just as a note: I am no prisma expert or employee. I just happen to hang out in this channel and like prisma :wink: