In this issue (<https://github.com/prisma/prisma/i...
# orm-help
b
In this issue (https://github.com/prisma/prisma/issues/10710) it is stated that inserting many rows at a time for SQLIte ‘is not supported out of the box’, even though the workaround provided does exactly that. What is meant by this?
a
Hey @Brendan Allan , I think “not supported out of the box” is referring to the lack of a
createMany
method on the Prisma Client when using SQLite. You can still use raw SQL to achieve this, but it isn’t supported by the regular, nice-to-use Prisma methods.
b
It may be that, but given that the workaround allows for very similar functionality to
createMany
, why hasn’t the workaround been used to implement it? I kind of interpreted it as saying inserting many rows at once ‘is not supported out of the box’ for SQLite, externally of Prisma. Would love to be wrong though and see it implemented later.