4 ms·
FWIW Google Cloud Datastore had similar functionality over a decade ago. They are called kindless queries: https://cloud.google.com/datastore/docs/samples/datas
by rockwotj 3y ago
FWIW Google Cloud Datastore had similar functionality over a decade ago. They are called kindless queries: https://cloud.google.com/datastore/docs/samples/datastore-kindless-query https://cloud.google.com/datastore/docs/samples/datastore-ki...
Essentially it allows for querying over all kinds (aka collection/table).
One usecase where these can be useful to implement account wipeout. If all entities (aka document/row) have a commonly named field like “owner” which is an account ID you can delete all their records in a single query. I mean for deletes you can do a similar use case with cascading deletes and foreign keys, but those don’t always scale well because they have too all happen in one transaction (but then it’s not transparent to the application)