4 ms·
> 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 yo
by 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.