Show HN: Node.js ORM to query SQL database through an array-like API

#1

Post by tilyupo » Thu, Sep 05, 2024, 11:55 AM UTC

Hello everyone! I'm exited to share a NodeJS package I was working on for the past two months.

The package is designed to simplify querying SQL databases through an array-like API. Qustar supports PostgreSQL, SQLite, MySQL, and MariaDB, and offers TypeScript support for a robust development experience.

It's in early stage of development. I would like to hear your thoughts about it.

Show HN: Node.js ORM to query SQL database through an array-like API
github.com

Re: Show HN: Node.js ORM to query SQL database through an array-like API

#2

Post by wredcoll » Thu, Sep 05, 2024, 1:30 PM UTC

[flagged]

Re: Show HN: Node.js ORM to query SQL database through an array-like API

#3

Post by [deleted] » Thu, Sep 05, 2024, 1:32 PM UTC

wredcoll wrote: post #2

[flagged]

[deleted]

Re: Show HN: Node.js ORM to query SQL database through an array-like API

#4

Post by EarthLaunch » Thu, Sep 05, 2024, 1:38 PM UTC

An intriguing idea! I like this approach for being an innovative interface to SQL. I wonder if it would reduce cognitive load when interfacing with the DB.

I'm a game dev and often need to avoid situations where I'm using '.map' to iterate an entire array, for performance reasons. It would feel odd to use the concept, knowing it wasn't really iterating and/or was using an index. Is that how it works?

Re: Show HN: Node.js ORM to query SQL database through an array-like API

#5

Post by pjerem » Thu, Sep 05, 2024, 1:42 PM UTC

Oh, that’s Entity Framework but in typescript ?

Re: Show HN: Node.js ORM to query SQL database through an array-like API

#6

Post by tilyupo » Thu, Sep 05, 2024, 1:45 PM UTC

pjerem wrote: post #5

Oh, that’s Entity Framework but in typescript ?

Exactly! Qustar was heavily inspired by EF.

Re: Show HN: Node.js ORM to query SQL database through an array-like API

#7

Post by thr0w » Thu, Sep 05, 2024, 1:45 PM UTC

[flagged]

Re: Show HN: Node.js ORM to query SQL database through an array-like API

#8

Post by fourseventy » Thu, Sep 05, 2024, 1:45 PM UTC

I'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.

Re: Show HN: Node.js ORM to query SQL database through an array-like API

#9

Post by matt-p » Thu, Sep 05, 2024, 1:46 PM UTC

[flagged]

Re: Show HN: Node.js ORM to query SQL database through an array-like API

#10

Post by pjerem » Thu, Sep 05, 2024, 1:47 PM UTC

EarthLaunch wrote: post #4

An intriguing idea! I like this approach for being an innovative interface to SQL. I wonder if it would reduce cognitive load when interfacing with the DB. I'm a game dev and often need to avoid situations where I'm using '.map' to iterate an entire array, for performance reasons. It would feel odd to use the concept, knowing it wasn't really iterating and/or was using an index. Is that how it works?

It’s exactly what Entity Framework does in dotnet. It allows you to query the database like it’s an enumerable.

In fact, in EF, an IQueryable (which is the interface you use to query a SQL dataset) implements IEnumerable. So you can 100% manipulate your dataset like a normal array/list.

Sure it comes with its own shenanigans but 90% of the time it’s easy to read and to manipulate.