[flagged]
[deleted]
Show HN: Node.js ORM to query SQL database through an array-like API
11–20 of 108 posts
Re: Show HN: Node.js ORM to query SQL database through an array-like API
#12[flagged]
[deleted]
Re: Show HN: Node.js ORM to query SQL database through an array-like API
#13I've come to the conclusion that ORMs are good for simple queries like User.find_by(email: "john@snow.com"), but once you get beyond that you are better off just writing sql.
[deleted]
Re: Show HN: Node.js ORM to query SQL database through an array-like API
#14The API doesn’t really look “array-like”.
Re: Show HN: Node.js ORM to query SQL database through an array-like API
#15Scala has a library called Slick which takes a similar approach: https://scala-slick.org
The DSL is nice for simple querying and for composing queries based upon user input. But, for anything slightly complex, I found it's better to just use regular SQL.
Re: Show HN: Node.js ORM to query SQL database through an array-like API
#16I am not sure I am understanding array-like in this context?
It seems to be more like knex or https://kysely.dev/
Re: Show HN: Node.js ORM to query SQL database through an array-like API
#17The API doesn’t really look “array-like”.
[deleted]
Re: Show HN: Node.js ORM to query SQL database through an array-like API
#18I am not sure I am understanding array-like in this context? It seems to be more like knex or https://kysely.dev/
[deleted]
Re: Show HN: Node.js ORM to query SQL database through an array-like API
#19I love your syntax for joins and unions!
A bit puzzled by why the connector slots into the query, instead of the query slotting into the connector, given that it’s the connector that’s actually doing the work. I.e. ‘connector.fetch(query)‘ … rather than… ‘query.fetch(connector)‘
Re: Show HN: Node.js ORM to query SQL database through an array-like API
#20Scala has a library called Slick which takes a similar approach: https://scala-slick.org The DSL is nice for simple querying and for composing queries based upon user input. But, for anything slightly complex, I found it's better to just use regular SQL.
[deleted]