Organizing data in PostGIS

One seamless database for everything? All joined together then pulled out using views? Or many databases with similar structure?

I have started a spreadsheet to track all this