Yes, it works well but there is a limit of 16k words. See this reddit comment thread [0] for more details, but if your documents are anywhere near that big then I'd say Postgres is definitely not the right tool for you.
I often see complicated search solutions implemented when PostgreSQL is just sitting there with its incredible FTS powers being ignored. To help some of the teams I'm working with get an idea of the power available to them I wrote up this two part article with a github repo for spinning up a db to follow along.
Agreed, EdgeDB[0] looks to be trying to solve a lot of SQL's perceived flaws with EdgeQL[1]. It's not the first attempt and I suspect it won't be the last but composability is explicitly one of the challenges it addresses.
For a visual tool I'd recommend giving IcePanel [0] a try.
For the diagrams as code solution, happily it looks like mermaid will soon support C4 [1] so their should be native support in lots of places soon (github, gitlab and lots more have built in support for mermaid)
What the GP meant is exactly what they said, "C# and .net 6 are not windows-centric.", sadly it shares a name with .Net Framework which was windows centric.
Is anyone providing unofficial builds of Fuchsia? I can see from the article the requirement is to build it yourself but I'm lazy/time poor and I'd really like to try runnning Fuchsia in an emulator.
https://freedom.gov/