SQLite the only database you will ever need in most cases
Postgres is the database I use for everything.<p>I find databases of all sorts extremely interesting and I've tried many of them, of all flavors.<p>In the end, I always come back to Postgres.  It's unbelievably powerful, lightweight and there's not much it can't do.<p>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.<p>Another example - multitenancy is dead easy in postgres, makes things more secure and makes coding easier.<p>Another is that Postgres had an extremely rich set of data types, including arrays and json.<p>Also Postgres is designed for symmetric multiprocessing which matters in today's multicore world.