4 ms·
> Docker swarm is to Kubernetes what SQLite is to PostgreSQL. To some extent. curious what do you mean? To me Postgresql doesn't have disadvantages over SQLite
by riku_iki 3y ago
> Docker swarm is to Kubernetes what SQLite is to PostgreSQL. To some extent.
curious what do you mean? To me Postgresql doesn't have disadvantages over SQLite, everything is just better..
- mulmen 3y agoPostgreSQL is more complex to use and operate and requires more setup than SQLite. If you don’t need the capabilities of PostgreSQL then you can avoid paying the setup and maintenance costs by using the simpler SQLite.
- riku_iki 3y agoIn simplest case, you do sudo apt install ... in both cases, connect to database and do your work..
- mulmen 3y agoI have never had a Postgres install go that easily. There’s still initialization and setup of the server and users. And you’ll have to do something about upgrades as well. Postgres isn’t difficult to set up but SQLite is just a file. It’s much simpler. And that’s only the installation. Interaction with SQLite as a database is also simpler. They both have uses but it’s strange to me to assert that they’re equally complex.
- riku_iki 3y ago> There’s still initialization and setup of the server and users. that command will create postgres user in the system, you do su to that user, run psql and you all set. > And you’ll have to do something about upgrades as well apt will take care of it too > but SQLite is just a file there is some "file" in postgresql distribution, people just don't use it, because why they would? > Interaction with SQLite as a database is also simpler. any specifics?
- mulmen 3y agoSQLite datatypes are advisory so it pretty much just accepts anything you give it. PostgreSQL definitely says no to schema violations. These are both features.