Hello, I’m trying to insert large JSON strings in a column using prisma. My datamodel looks like that.

type Area {
    ...
    name: String! @unique
    areaType: AreaType!
    geometry: Json
    ...
}

It works fine, except for some of the entries where I get this error message :

Error: Value for field geometry is too long.

The thing is the JSON are not that large, they’re between 10kb and 100kb. The whole dataset has roughly 10000 entries, and a size of 515mb. The maximum size for a column entry should be around 1GB according to the documentation. Has anyone encountered a similar situation? Is there any way to increase that limit ?

https://github.com/prisma/prisma/issues/2705 I ran in to this issue myself. My workaround was to go around primsa, make a connection to the DB through a service, to save the JSON.

Thank you. I’m using the same workaround right now (connecting directly to the db and using knex, which is not that bad it my use case since it’s a one time operation), but it would be nice to have a way to remove those limits or tweaks them without running a forked version of prisma … https://github.com/prisma/prisma/issues/2705 @Harshit Do you think any change can happen in the short term regarding that ? I obviously don’t have the visibility on the project, but it looks like it’s a simple change with low repercussions (like a flag that’d remove those limits).