10 июн. 2024 г. · Turns out Prisma has such terrible performance that even the built in "raw query" function performs twice as bad as actual raw SQL queries.

15 мар. 2023 г. · To sum up, I recommend that you use a query builder for those few queries that need to be generated dynamically, and use raw SQL for everything ...

23 окт. 2024 г. · I personally prefer TypeORM but Drizzle may be more approachable if you're new to SQL databases. Also don't be afraid to spin up a Postgres ...

18 дек. 2023 г. · My current favorite is Drizzle. Once things stabilize, I can rip out the ORM and confidently write raw queries. It can take quite some time ...

27 дек. 2023 г. · The best thing an ORM can do is generate simple insert and lookup statements. For anything more complicated than that you'll end up writing sql anyway.

15 окт. 2024 г. · I have a getPosts function in my server/actions/get-posts.ts file. I am getting an empty array in the console.

29 июл. 2024 г. · Best choices from each category are: mikro-orm, kysely or drizzle, postgresjs. Raw SQL or query builder would be nice and most flexible.

11 июл. 2024 г. · I decide whether to use Drizzle ORM select() or query interface to fetch data from the database? Is it a good idea to ignore query interface and just use ...

27 мая 2024 г. · Writing raw SQL in itself is not bad, and the concept of an ORM has a very compelling reason. How you do either of those things or is ofc going to require some ...

30 окт. 2023 г. · If you don't mind escaping array elements, you can wrap stringFilter in sql.raw (in your t1 query). Otherwise, you need to pass each array ...