The events of 1/6/2020, and the proliferation of unfounded 2020 election fraud claims, would suggest otherwise. Not to mention his plans to "be a dictator for a day" and persecute his political opponents if elected this fall.
The man and those in his orbit have a hard-on for Putin/Xi/Kim-style autocracy.
Australia is on an America-led course to humiliate and destroy whistleblowers. Our governments were upset in public, but no doubt cheering on Assange's treatment in private. Just look at what they did to David McBride.
This happens to a lot of sites sadly. You see old forums shut down all the time citing costs when the community could’ve saved it if they’d been given any kind of notice.
I hate to break it to you, but yeah. There are, sadly, many countries in the world that rely on petty and punitive action on harmless things online in order to frighten would-be "troublemakers".
It's not just Russia, either. The UK does this almost three times as often.
While what is described here is a legitimate political movement, it's important to remember most 'militias' in these contexts are very often funded by, part of, or become rival criminal groups.
I remember watching Vice lionize rival Cartel thugs as "fed up anti-Cartel paramilitaries". I had to laugh.
True but it lacks the tools you’d want to have to deal with larger databases, for example everything is one file and no table-level locking. You can split into different databases and use ATTACH but at that point you might as well install Postgres.
SQLite really shines when you know that a database can only get so large, let’s say you have a paid product that is only ever going to have a moderate number of users.
For me the biggest limitation is replicating the SQLite across machines. If my app is running on multiple nodes, then we need to write/use some tooling to replicate the database file across nodes. With that comes the problem of figuring out how we want to handle error scenarios like failed replication, partial replication and such other things.
And these are all hairy problems. At that point it might be just simpler to use a centralized Postgres or a proper distributed database.
Modern AAA games are meant to be disposable, with a killswitch for when the next consumable is released. This isn't possible with community servers. They don't want longevity. Cheating is an entirely self-inflicted problem caused by this. Self-policing communities with moderation tools are far more effective.
These companies are so greed driven, that they lobby to make cheating a federal offence and for private police raids and private house searches, instead of making a healthy community based on previous experience. As has, disturbingly, already happened in Australia (https://torrentfreak.com/images/gtaorders-1.pdf)