SQLite the only database you will ever need in most cases
Postgres is the database I use for everything.I find databases of all sorts extremely interesting and I've tried many of them, of all flavors.In the end, I always come back to Postgres.  It's unbelievably powerful, lightweight and there's not much it can't do.Why not use sqlite?  Here's one example - I like to access my database from my IDE remotely - my understanding is that remote access is not possible with sqlite.Another example - multitenancy is dead easy in postgres, makes things more secure and makes coding easier.Another is that Postgres had an extremely rich set of data types, including arrays and json.Also Postgres is designed for symmetric multiprocessing which matters in today's multicore world.