[GTALUG] Info request

Greetings Just looking into how to use a database like Postgresql. On the other side they use front end programs. What is a 'normal' or common approach in the linux world? TIA Dee