4 ms·
Hm... is this is like JOOQ[1] for non-Java languages? Or maybe more like a typed version of massivejs[2]? [1] https://www.jooq.org/ https://www.jooq.org/ [2] h
by hn_reddit_human 7y ago
Hm... is this is like JOOQ[1] for non-Java languages? Or maybe more like a typed version of massivejs[2]?
[1] https://www.jooq.org/ https://www.jooq.org/
[2] https://massivejs.org/ https://massivejs.org/
- rishav_sharan 7y agoSorry for being out of context, but why is your name in green? This is the first time I have seen a green name in HN.
- Illniyar 7y agonew accounts (below 14 days I think) are colored green.
- deleted 7y ago[deleted]
- mavilein 7y agoNo Prisma is not like JOOQ. We are happily using JOOQ internally at Prisma so i happen to know. The main differences in my opinion are: - JOOQ is a SQL Query Builder which is typesafe in regards to the fact that you cannot make SQL syntax errors in your query. However you can still write queries that are e.g. using a table that does not exist. In contrast the Prisma Client gets generated for all your tables and columns and this error is impossible. You also don't need to do any mapping from SQL result sets to your application models. - JOOQ is about SQL. Prisma is not only about SQL but also any other kind of database. Prismas architecture is comprised of a database agnostic core and database specific connectors. Therefore it can connect to any database for which a connector exists. Right now we have connectors for Postgres, MySQL and MongoDB. More are in the works and in the future people will be able to implement their own connectors :-) - Prisma has a migration system but JOOQ does not have one.
- querulous 7y agojooq can also introspect your database and ensure you only use existing tables and columns and your data types are in agreement it however requires you do this at compile time, not runtime. does prisma do the introspection at runtime?