before Postgresql was big, the only opensource databases i saw in use was MySQL(later Mariadb) and SQLite. SQLite support is single application and MySQL suffer

before Postgresql was big, the only opensource databases i saw in use was MySQL(later Mariadb) and SQLite. SQLite support is single application and MySQL suffers from problems like incomplete utf8 support(unless you use utf8mb4), or the problem of the database engines. Postres configuration and running multiple servers on one domain is from my perspective much easier. Some minor features are more interesting for me: native uuid, row level locks ("SELECT * FROM mytable FOR UPDATE SKIP LOCKED LIMIT 1;" is an query where you can get one row and process it like an queue, but if it fails (error or crash of client) it can rollback and give to the next worker.