It’s a functional improvement over old init, but the thing I hate about it is how unnecessarily arcane it is. It seems “designed for job security” or more likely designed for consulting revenue.
There is absolutely no need for its command names and everything else about it to be so counterintuitive.
I feel the same way about Postgres. It's powerful but it's insanely arcane and full of land mines and footguns. It's great for forcing you to hire consultants, DBAs, or pay cloud providers a lot to run it for you.
Which SQL RDBMS isn't, though? Postgres is a breeze compared to someting like DB2. High-performance relational databases just seem to be an inherently arcane target.
MySQL and SQLite, but the former is not a real transactional database, it's quite a joke compared to Postgres. The latter is a file based database. We use MySQL at work and I am exasperated by it. It's possible that even Firebird is better.
If Postgres is unnecessary arcane, then surely MySQL is that squared, given all the legacy traps? You know, stuff like "utf8" not actually being UTF-8.
Proper transactions, like the ones that aren't closed by create, alter or drop table, proper rollbacks, statement timeouts so that a single stalled statement doesn't block the table until you kill it, subscribe/notify among other things. My issue is primarily with performance under load, where you'll eventually end up with lots of blocked queries and an unresponsive database and the only way to solve it is to throw hardware resources at it.
Do yourselvs a favour and pick Postgres for new projects. If you properly vacuum your tables you'll probably be fine.
How do I list what's running? I have to Google that every time. How do I list units? What are units? What the fuck are... and so on. The output is hard to read. The files are all over. The directory and file names are counterintuitive. It’s just… needlessly arcane.
Git has the same problem but at least git is excellent enough software in other ways that it makes up for the horrible UX. Systemd is mediocre.
There is absolutely no need for its command names and everything else about it to be so counterintuitive.