undefined | Better HN

0 pointsriku_iki2y ago0 comments

> 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?

0 comments

1 comments · 1 top-level

SQLite datatypes are advisory so it pretty much just accepts anything you give it.

PostgreSQL definitely says no to schema violations.

These are both features.

j / k navigate · click thread line to collapse