News for hackers. Stuff that matters.
Re:Show HN: InstantDB – A Modern Firebase by unsupp0rted on Friday August 23, 2024 @12:37PM (#41330463)
Building a logistics app, I wish I could query in Firebase for items that don’t have a “shipped” field.

But I can’t.

Re:Show HN: InstantDB – A Modern Firebase by randomdata on Friday August 23, 2024 @01:09PM (#41330791)
Technically you can: Scan all of the documents. A "relational query language" would have to do the same thing.
Re:Show HN: InstantDB – A Modern Firebase by unsupp0rted on Saturday August 24, 2024 @10:08AM (#41338418)
That wouldn’t be querying though, right?

Grabbing all the docs in the db into my controller and filtering down that array is what Firebase makes me do instead of writing queries.

Re:Show HN: InstantDB – A Modern Firebase by randomdata on Saturday August 24, 2024 @11:47AM (#41339065)
> That wouldn’t be querying though, right?

Why not? You're asking a question, of sorts, and getting an answer from the result. That's the literal definition of querying.

> Grabbing all the docs in the db into my controller and filtering down that array is what Firebase makes me do instead of writing queries.

A query language is just an abstraction. One you can have in your code. At some point you still need to "grab all the docs into a controller and filter them down", though. You could push that step into the Firebase service, but it would still have to do the same thing you're doing. There is no magic.

Better would be to provide something indexable so that you don't have to go through all the docs, but you can't index that which does not exist.