News for hackers. Stuff that matters.
Re:Ask HN: Is there a way to efficiently subscribe to an SQL... by toolslive on Friday April 23, 2021 @02:35AM (#26911610)
Mind:

  - the query language is quite limited (fe, searching on the absence of an attribute is not possible)
  - shame you can't do projections on the changes server side.
    you get the whole thing and not just the fields you're interested in
Re:Ask HN: Is there a way to efficiently subscribe to an SQL... by rockwotj on Friday April 23, 2021 @02:48AM (#26911730)
The query language is limited, but a lot of the limitations are intentional.

Here is a post from a while back where I explained some of the reason for some of these limitations; https://groups.google.com/g/google-cloud-firestore-discuss/c...

Granted not all of them are due to this philosophy and some are just hard problems due to other constraints like the security rules verification system.

RE projections: this is actually due to some limitations in processing security rules and not a limitation in the query matching.

Edit: RE matching on missing attributes. This is due to Firestore having sparse indexes and being schemaless, if you write explicit null values you can query for those fields being null.

Re:Ask HN: Is there a way to efficiently subscribe to an SQL... by toolslive on Friday April 23, 2021 @03:02AM (#26911837)
If your building a reactive website then firestore is actually great. Edit: but yes IMNSHO, there are also some design mistakes (schemaless, silly limitations on keys, ...) both in the service and the client libs. I only used the python and js clients though. I might be biased
Re:Ask HN: Is there a way to efficiently subscribe to an SQL... by rockwotj on Friday April 23, 2021 @03:21AM (#26911989)
Yupp, certainly don't disagree. It's not a perfect system - to comment on those two issues: there were some pipe dreams when I was there to support schemas, including partial schemas, but we needed a better migration story (and someone to convince the powers that be it was the right thing to work on). The limitations on keys are mostly due to the system being compatible with Cloud Datastore.