4 ms·

The Litestream and LiteFS sections near the beginning of the article cover your first question. And I guess the second one is covered by the "generator" entry,

The Litestream and LiteFS sections near the beginning of the article cover your first question. And I guess the second one is covered by the "generator" entry, but: https://www.prisma.io/docs/concepts/components/prisma-client https://www.prisma.io/docs/concepts/components/prisma-client

sureglymop 4y ago
Do you like Prisma? I think it's cool but it sucks that their prisma schema doesn't support constraints and more complex things. It is very basic and for any real world use migrations need to be used. And I've had issues using it with SQLite. It doesn't support case insensitive filtering when using SQLite (I know, neither does SQLite). But as a result, i have to build a custom query which is pretty much what i wanted to avoid by using Prisma.
- davnicwil 4y ago
  I really like Prisma, and talk about it to anyone who'll listen, but it is still very new and as such I think doesn't have a lot of features figured out yet and some really surprising things do come up. One I discovered just the other day [0] was that if you pass an undefined value into a field in a where clause of findFirst, it's treated the same as if you didn't pass anything at all. If you do this with an id, for example, this can result in just the first record in the table being returned, because it's as though you have no where clause at all. Naturally this can lead to some surprising bugs if undefined values crop up at runtime, even potentially some really bad security bugs (imagine if this happens on the account table for instance). I don't mean this as a criticism, I think it is just a normal part of being new and exciting software, maturing over time. But it's always a tradeoff to be aware of. [0] https://github.com/prisma/prisma/issues/5149#issuecomment-1368247621 https://github.com/prisma/prisma/issues/5149#issuecomment-13...
LAC-Tech 4y ago
The Litestream and LiteFS sections near the beginning of the article cover your first question. I don't feel it did.

sureglymop 4y ago

Do you like Prisma? I think it's cool but it sucks that their prisma schema doesn't support constraints and more complex things. It is very basic and for any real world use migrations need to be used. And I've had issues using it with SQLite. It doesn't support case insensitive filtering when using SQLite (I know, neither does SQLite). But as a result, i have to build a custom query which is pretty much what i wanted to avoid by using Prisma.

davnicwil 4y ago
I really like Prisma, and talk about it to anyone who'll listen, but it is still very new and as such I think doesn't have a lot of features figured out yet and some really surprising things do come up. One I discovered just the other day [0] was that if you pass an undefined value into a field in a where clause of findFirst, it's treated the same as if you didn't pass anything at all. If you do this with an id, for example, this can result in just the first record in the table being returned, because it's as though you have no where clause at all. Naturally this can lead to some surprising bugs if undefined values crop up at runtime, even potentially some really bad security bugs (imagine if this happens on the account table for instance). I don't mean this as a criticism, I think it is just a normal part of being new and exciting software, maturing over time. But it's always a tradeoff to be aware of. [0] https://github.com/prisma/prisma/issues/5149#issuecomment-1368247621 https://github.com/prisma/prisma/issues/5149#issuecomment-13...

LAC-Tech 4y ago

The Litestream and LiteFS sections near the beginning of the article cover your first question. I don't feel it did.