It depends on the type of app. If I expect few concurrent writes and don't need RLS, then sqlite. If the application is write heavy I am happy to get RLS for free by picking Postgres.

The DB choice is independent of the language. The language might be Python, Go or C# depending on the usecase.