can someone key me in as to why 2D arrays are not ...
# orm-help
b
can someone key me in as to why 2D arrays are not supported? A mutidimensional array is an extremely common use case/data structure
t
would the JSON field help here? https://www.prisma.io/docs/concepts/components/prisma-client/working-with-fields/working-with-json-fields b/c you could store a 2D array there.
b
Hi @Tyler Bell, thank you for response! I used
json
but the problem is I'm storing very large 2D vectors in Postgres (making json retrieval very slow/cumbersome). Postgres supports this natively but I can't use Prisma to insert a 2D arr without using
rawQuery
Ideally, the schema would allow
Float[]
or
Float[][]
for example
esp since multidim arrays are natively supported in Postgres : https://www.postgresql.org/docs/9.3/arrays.html