If you had to make a few users and passwords and specify which tables were allowed for different users it is only because you chose to design your app this way. You must have felt there was some good reason to divide it up like that.
If that was the case, sqlite would have been unsuitable for your needs.
In other words, the complexity you describe was not caused by postgres. It was caused by your app design. Postgres was able to accommodate your app in a way that sqlite cannot.
Sqlite does have the "it's all contained in this single file" characteristic though. So if and when that's an advantage, there is that. Putting postgres in a container doesn't exactly provide the same characteristic.
For young impressionable readers, this is just a note that the parent comment is one person's opinion. There are opposing opinions here and throughout society.
I think it would be super interesting if there became a GMail of Matrix--one super-dominant provider--but it was still possible to have Fastmail and Protonmail etc of Matrix. So you could actually still host your own little community that could still interact with the giant gorilla even if it was challenging to do so. Imagine that whichever federated protocol were extended with spam-blocking features that complicated federation such that it was even harder to run a server than it is today. But it was still possible, especially for those with enough money.
So every once in a while a newcomer like TikTok could blow up and become a fad, but some old grandma could just keep plugging away on their hilariously old-school service and still follow their granddaughter's high school swim team hosted on the hip new shiny service all the kids are going for today.
Ellsberg very eloquently articulated the fallacy that juniors were less trustworthy. I don't think their junior status is an issue. I think perhaps the bigger concern is their quantity. I'll leave it to probability and game theory experts to discuss whether it is better or worse to have more people capable of wielding such a weapon.
That's a completely different topic. I'm tired of hearing people spout about a legal obligation to grow.
If you mean "it will hurt somebody's feelings" don't say "it's illegal". Those words do not mean the same thing.
If a company earned a $1 dividend for the last five years and the stock price is $10, what is wrong with paying out $1 dividend again next year and having the stock price stay at $10?
If a stockholder wants a bigger payout they can sell their share and invest the $10 in some other stock and take their chances.
Personally, I think a $10 share that pays out $1 and is still worth $10 is incredible. It doesn't bother me at all that neither the price nor the dividend has grown. It doesn't bother me that the square meters of manufacturing floor space hasn't grown. I don't mind that the number of employees hasn't grown. It's ok that the number of SKUs has stayed the same.
Perhaps you missed the part about not needing distro-specific packagers by providing a way to run third party apps without having to trust third party packagers. You can deny access to the camera or filesystem or network without ever auditing the source code and trust that the software cannot misbehave in that aspect.
This isn't a knock on the value of package managers or maintainers. It's just an obvious step in better security. It seems silly to argue that integrity among package maintainers is the only safeguard we need. I personally like the little piece of plastic that my laptop has that slides across the built-in camera. It's not a software solution, or even an electronic safeguard. It's even better than the little DIP switch on my phone. I say, why not?
I'm not convinced that people who are not paying Redhat for RHEL Workstation support count as customers on this question.
But this is still an odd statement. Previous customers who very much relied on LibreOffice might move to some other platform or at least some other support service. Thus they would no longer be Redhat customers and Redhat would still be loyal to their customers.
I suspect the number of RHEL Workstation customers to be a relatively small part of Redhat's customer base. And those that depend on LO support to be even smaller. I don't expect this to affect RH's bottom line in any negative way.
So only people capable of auditing source code and build scripts deserve to be able to trust software? There should never be any other way to offer trustability?
There were plenty of plausible alternatives before Sun bought StarOffice and made it Free software. There were plenty of plausible alternatives when the Libre folks "freed" LibreOffice from Oracle.
LibreOffice is still the standard-bearer for open source office suites. It isn't competing with WordPerfect or AmiPro or Lotus 1-2-3 or Quattro Pro like it used to. The proprietary stuff have largely died and lost to the two big gorillas.
It is as important as ever to have the likes of LibreOffice around. There are plenty of plausible alternatives to Redhat itself, but surely everyone understands how important they and their like have been and continue to be.
Please read the book. One guy follows a funky compass provided by...God(?) from Jerusalem to some coast. On the coast God shows him where to mine ore to make tools. God shows him how to build a ship that can weather a long sea voyage all the way to the Americas.
The whole book has all sorts of interventions from God. Like every page is about God. If you're hung up on Egyptian writing you missed the whole point. That's the least incredulous part.
And some 18-year-old kid in the 1820s says an angel led him to these gold plates with all this modified Egyptian writing and God showed him how to translate it into English.
So this book is going to be a bunch of crazy nonsense, right? Read it. Seriously, read it. It is a better read than anything you did in your high school or college lit class. We can't have a decent critical discussion about the physics of it until you've read it.
I'm open to a discussion about this. It just so happens that I have recently witnessed many very generous people give out 100,000s of dollars in scholarships to local high schoolers. I'm willing to consider that those donations should also be taxed.
I'm also open to discussions of a flat tax and abolishing food tax and lots of other tax ideas. Including allowing tax deductions for charitable giving and tax exemptions for lots of things. I'm ok with allowing some, but I see the room for abuse. We'll never eliminate all abuse and we'll never get everything exactly fair. But we can keep making tweaks in the never-ending pursuit.
My family is amused when I criticize the physics in a movie when a bridge collapses in an unrealistic way. Apparently I don't have any issue with the talking dog that flies across the river and uses mental telepathy to form a giant wave that catches all the pieces of the fallen bridge and pushes them back into place to restore the bridge. No, my beef is with the poor grasp of physics because of how the bridge fell down.
Joseph Smith didn't discover gold plates. He was led to them by an angel sent by God. The question of whether a decendant of inhabitants of Jerusalem could have buried some modified Egyption writings in North America 1000+ years before Joseph was born... that question is kind of small when considering if there is a God and if any such God takes a direct interest in individual people.
FWIW, I happen to believe that there is a God and that God cares very much about you.
The church in question regularly teaches that people should build up their savings against any reversal of fortune. It also teaches to be generous to those in need. It strives to set an example in both things.
Your wikipedia link is about some rumor started a half century after the founder was murdered. It's a bit like George Washington's cherry tree. It may be a well-known story, but it isn't part of the constitution or a motivation for any governing action.
I think it is entirely appropriate for the government of Sweden to build some security for a rainy day. I think it is appropriate for my neighbor to do the same. I don't see any reason why the local community church should not. So why should a multinational church be different?
I'm reading other headlines about whether US politicians will extend the debt limit in time. Wouldn't it be a relief if instead we criticized them for building too large a reserve?
It is a current truth that there are modern apps of interest to me written in Python that I can't install because I need some special dependency manager or environment manager or something and it looks like I will do serious harm to my system environment if I follow the installation instructions.
If that was the case, sqlite would have been unsuitable for your needs.
In other words, the complexity you describe was not caused by postgres. It was caused by your app design. Postgres was able to accommodate your app in a way that sqlite cannot.
Sqlite does have the "it's all contained in this single file" characteristic though. So if and when that's an advantage, there is that. Putting postgres in a container doesn't exactly provide the same characteristic.