I've been using it to build a dynamic blog/newsletter. Local DX with https://github.com/kitsonk/kview has been nice.

Haven't deployed it yet, but the API seems decent when doing local development.

It's a bit low-level compared to a SQL database; you're building your own indexes and need to write transactions to update them atomically along with the main record. (But it does have transactions, so it's reasonable.) It reminds me of App Engine datastore, back in the day.

There are some fairly tight limits. (64k for records.) I wouldn't use it for storing images or larger files.

Not sure what I'm going to do for full-text search. But I've built simple search engines from scratch before.