oracles VS Prisma

Found it https://github.com/helium/oracles/issues/328

What's that folder there for? As far as I can tell, a google search only finds a some github issues that just so happen to contain a path to a sub-item. See: here and here. Also, an empty github profile.

Prisma has this one glaring issue: https://github.com/prisma/prisma/issues/10649

Segmentation fault with NodeJS 18. Its about prisma having linked a different version of OpenSSL than NodeJS. A workaround is to use the "binary" engine, meaning you run another process, talk via IPC to that, and that then talks to the DB, which is ridiculously roundabout.

But this issue is finally worked on, so once that is fixed its good.

If you're already familiar with Express and Node, then I suggest looking into NextJS or Remix. The benefit of having a full-stack app is the integration that you get with the type safety with TypeScript support as well as other useful tools like Prisma for your DB which provides a seamless API for the rest of your app. You can also get server-side rendering and other SSR features from React 18 which are all the rage these days

Prisma does the heavy lifting on our project:

https://www.prisma.io

I don't have experience with Knex so I, unfortunately, don't have an answer to your question.

Besides svelte/sveltekit, it uses Zod and tRCP connected to a Supabase postgres database via Prisma and deployed on vercel.

Maybe starting a level lower is also an option, in which case something like https://www.prisma.io/ might be interesting.

Prisma - is an ORM that enables us to write type safe queries to our database. It is a server-side library that helps developers read and write data to the database in an intuitive, efficient and safe way. It is easy to integrate into your framework of choice => Next.js, Graphql, Apollo, nest, Express e.t.c. Prisma simplifies database access, saves repetitive CRUD boilerplate and increases type safety. Its the perfect companion for building production-grade, robust and scalable web applications.

Supporting Postgres' `SET` across queries of a request #5128

In this article we will cover Prisma, which is a top tier choice for ORM in your next application.

Tabular formats fundamentally don't fit with the usual programming model of JSON-based objects. Something like Prisma, which I use across all my projects, eliminates this gap between programming model of thinking with objects, and SQL way of thinking with very standardized rows.