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
On Aug 15, 2016 10:17 PM, "o1bigtenor via talk" <talk@gtalug.org> wrote:
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?
When in a pure terminal box, I go with postgresql CLI, but if I have a linux box with GUI, I would always consider a front emd tool like pgadmin.
On 16-08-15 10:17 PM, o1bigtenor via talk wrote:
Just looking into how to use a database like Postgresql. [snip] What is a 'normal' or common approach in the linux world?
You could use the web based tool phpPgAdmin. -- Cheers! Kevin. http://www.ve3syb.ca/ |"Nerds make the shiny things that distract Owner of Elecraft K2 #2172 | the mouth-breathers, and that's why we're | powerful!" #include <disclaimer/favourite> | --Chris Hardwick
On Mon 15 Aug 2016 21:17 -0500, o1bigtenor via talk wrote:
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?
"How to use" is an extremely open ended question. What is the application? What are your requirements? What do you already know? What are you willing to learn? etc... My experience is with php, mysql, cli So I would say php, <postgres>, cli The least amount I have to change the better.
On Mon, 15 Aug 2016 23:04:23 -0400 Loui Chang via talk <talk@gtalug.org> wrote:
On Mon 15 Aug 2016 21:17 -0500, o1bigtenor via talk wrote:
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?
"How to use" is an extremely open ended question.
What is the application? What are your requirements? What do you already know? What are you willing to learn? etc...
My experience is with php, mysql, cli So I would say php, <postgres>, cli The least amount I have to change the better.
+1
--- Talk Mailing List talk@gtalug.org https://gtalug.org/mailman/listinfo/talk
I use the cli tool, psql, which gets pretty regularly enhanced to do things like tab completion on keywords and object names. There are many that would swear by pgAdmin, which also gets pretty steadily enhanced. The iOS folk also seem to have some preferred tools that take advantage of their GUI environment; I never remember the names... Psql and pgAdmin, tho, seem to be memorably good choices.
participants (6)
-
ac -
Christopher Browne -
Kevin Cozens -
Loui Chang -
Marcelo Cavalcante -
o1bigtenor