I almost knew that postgresql would be the winner just because of how much people recommend it here or literally anywhere. Postgres is cool.
My personal favourite depending on situations are postgres (technically supabase is postgres too),sqlite,duckdb,(valkey?)
I am just curious but guys what are your favourite options and why?