That's still orders of magnitude more complexity for no real benefit. A migration from sqlite to postgres, if really required, is not that hard.

Yes, postgres should support a superset of SQLite functionality.

It's more like comparing assembly against the same program but with comments.

The pattern I notice more frequently at work now is:

"I'm working on X problem, I tried Y solution, AI thinks Z is wrong and W could be better, human opinion?"

This way there's never space for ambiguity, you showed you did your homework to the best of your extent, you already asked AI, all that's left is explicit request for human input.

It works quite well, and I appreciate it from both ends, as it saves everyone time.

This is obviously massively understating what an IDE does.

Do you never use language server features? Showing git blame on files? Doing regex search and replace? Doing multi-cursor editing? Run test?

If you genuinely never do, then that's ok, you don't need an IDE.

I do this all the time in Emacs, which runs on an old computer and handles it quickly. None of the tasks on this list require significant CPU resources.

I actually think these constraints _help_ the average project as well. By enforcing remote builds and execution you completely remove the need for something like docker. You also get cloud backups for your code automatically.

This is not a complete answer.

There are many open source projects that are developed in google3.

Good old capybara

Honestly the simplest option is sometimes the answer. Google docs...

It meets all your requirements. Markdown interop is very good. Always backed up and in sync. Supports offline access. Really easy to export everything if you really need to.

Google Docs doesn't do classic "wiki" things like bi-directional linking. Search, ironically, is also a bit of a mess.

Google Docs was built as a MS Word competitor and that's what it does best. I love Google Docs and I use it every day, but this is one thing I wouldn't use it for.

Not really. Are jelly fishes conscious? Are carrots conscious? Those are biological and serve complex functions.

This reminds me of the critique of certain kinds of art.

"It's so easy, I could have done that myself"

Well yeah, but you didn't.

With JJ I sometimes make a 'jj new a b c' to work on top of multiple changes. Then as I tweak things 'jj absorb' to automatically patch the right changes.

Insanely easy and effective.