Seems like a common approach is something like using yjs for sync with a temporary LSM storage like rocksdb for updates and then periodically snapshot to postgres for full text search and compaction.
The syntax is hard without a functional background but I strongly believe this is the next logical step to harden containers and have reproducible builds.
Every interaction with Azure is a pain. Just 3 weeks ago I was trying to use Artifact Signing, after spending one hour on outdated doc on how to set it up I get hit with Identity validation. I did all steps and still "in progress" still to this day. You charge 40$/month for "support" on Microsoft Q&A which we all know is a joke otherwise its 100USD just to get a ticket in to know why your process is so broken.
At this point I get better support on GCP which is telling.
We do that internally and I cant overstate how much better the output is even with small prompts.
IMO things like "dont put abusive comments" as a policy is better in that file, you will never see comment again instead of fighting with dozen of bad contributions.
Like if it was "you need to do the developer 7-tap of the version label in settings", it'd be like "whatever". But given how long this process has taken, I suspect that is not what they've planned - it wouldn't take this long to develop, it certainly wouldn't take this long to explain.
So I suspect that we're actually in the "Maybe Later" phase of "Google wants to control which apps you install: [ ] Yes [ ] Maybe Later". And I mean, if their proposed solution turns out to be "Me and 25 of my closest friends can install apps I make by phoning home to Google servers", then like, I can do that on iOS too. And if I'm not going to have meaningfully more control of my Android device, I may as well just go to iOS where Apple at least have a better privacy record and don't seem to have have an all-encompassing goal of "where can we put AI features to drive AI usage metrics up the most?"
Also worthy of note is that there is talk to add a syntax for explicit captures.
Maybe a bit unlikely, but still an issue no one is really considering.
There has been a single ruling (I think) that AI generated code is uncopyrightable. There has been at least one affirmative fair use ruling. Both of these are from the lower courts. I'm still of the opinion that generative AI is not fair use because its clearly substitutive.