pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedGUI tool for Raspberry Pi - PostgreSQL 11.5
13+ messages / 11 participants
[nested] [flat]
* GUI tool for Raspberry Pi - PostgreSQL 11.5
@ 2019-09-20 13:03 Ertan Küçükoðlu <ertan.kucukoglu@1nar.com.tr>
2019-09-20 14:08 ` Re: GUI tool for Raspberry Pi - PostgreSQL 11.5 robert@redo2oo.ch <robert@redo2oo.ch>
2019-09-20 14:10 ` Re: GUI tool for Raspberry Pi - PostgreSQL 11.5 robert rottermann <robert@redcor.ch>
2019-09-20 14:37 ` Re: GUI tool for Raspberry Pi - PostgreSQL 11.5 Laurenz Albe <laurenz.albe@cybertec.at>
2019-09-20 15:05 ` Re: GUI tool for Raspberry Pi - PostgreSQL 11.5 Joshua Kramer <joskra42.list@gmail.com>
2019-09-21 14:12 ` Re: GUI tool for Raspberry Pi - PostgreSQL 11.5 Björn Lundin <b.f.lundin@gmail.com>
0 siblings, 5 replies; 13+ messages in thread
From: Ertan Küçükoðlu @ 2019-09-20 13:03 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
Hello,
I am looking for a tool other than pgAdmin3 for Raspberry Pi running on
Debian 10 Buster. I need basic things like create user, run SQL on tables,
view structure of a table.
pgAdmin3 is barely running and raising a lot of errors. pgAdmin4 is not in
"apt" list of applications and I really do not like that I have to run a
browser for it. There are a lot of alternatives for Windows based solution.
I cannot find something for Raspberry Pi.
It would be good to have a free tool though I am willing to pay a small fee
for a tool that will do my basics.
Any help is appreciated.
Thanks & regards,
Ertan Küçükoðlu
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: GUI tool for Raspberry Pi - PostgreSQL 11.5
2019-09-20 13:03 GUI tool for Raspberry Pi - PostgreSQL 11.5 Ertan Küçükoðlu <ertan.kucukoglu@1nar.com.tr>
@ 2019-09-20 14:08 ` robert@redo2oo.ch <robert@redo2oo.ch>
2019-09-20 15:57 ` Re: GUI tool for Raspberry Pi - PostgreSQL 11.5 Ertan Küçükoğlu <ertan.kucukoglu@1nar.com.tr>
4 siblings, 1 reply; 13+ messages in thread
From: robert@redo2oo.ch @ 2019-09-20 14:08 UTC (permalink / raw)
To: Ertan Küçükoğlu <ertan.kucukoglu@1nar.com.tr>; pgsql-admin@lists.postgresql.org
Ertan
On 20.09.19 15:03, Ertan Küçükoðlu wrote:
> Hello,
>
> I am looking for a tool other than pgAdmin3 for Raspberry Pi running on
> Debian 10 Buster. I need basic things like create user, run SQL on tables,
> view structure of a table.
>
> pgAdmin3 is barely running and raising a lot of errors. pgAdmin4 is not in
> "apt" list of applications and I really do not like that I have to run a
> browser for it. There are a lot of alternatives for Windows based solution.
> I cannot find something for Raspberry Pi.
pgadmin4 is simple to setup
have you ever done anything with python?
Do you feel somehow comfortable with linux?
robert
>
> It would be good to have a free tool though I am willing to pay a small fee
> for a tool that will do my basics.
>
> Any help is appreciated.
>
> Thanks & regards,
> Ertan Küçükoðlu
>
>
>
--
Robert Rottermann CEO
031 333 10 20
robert@redo2oo.ch <mailto:robert@redo2oo.ch>
Sickingerstrasse 3, 3014 Bern <http://maps.apple.com/?q=Sickingerstrasse
3,3014 Bern>
https://Redo2oo.ch <https://redo2oo.ch;
*Ihr Partner wenn es um ERP Lösungen geht.*
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: GUI tool for Raspberry Pi - PostgreSQL 11.5
2019-09-20 13:03 GUI tool for Raspberry Pi - PostgreSQL 11.5 Ertan Küçükoðlu <ertan.kucukoglu@1nar.com.tr>
2019-09-20 14:08 ` Re: GUI tool for Raspberry Pi - PostgreSQL 11.5 robert@redo2oo.ch <robert@redo2oo.ch>
@ 2019-09-20 15:57 ` Ertan Küçükoğlu <ertan.kucukoglu@1nar.com.tr>
2019-09-20 18:11 ` Re: GUI tool for Raspberry Pi - PostgreSQL 11.5 robert <robert@redo2oo.ch>
2019-09-20 18:16 ` Re: GUI tool for Raspberry Pi - PostgreSQL 11.5 robert <robert@redcor.ch>
0 siblings, 2 replies; 13+ messages in thread
From: Ertan Küçükoğlu @ 2019-09-20 15:57 UTC (permalink / raw)
To: robert@redo2oo.ch <robert@redo2oo.ch>; +Cc: pgsql-admin@lists.postgresql.org
Hello,
> On 20 Sep 2019, at 18:21, robert@redo2oo.ch <robert@redo2oo.ch> wrote
> pgadmin4 is simple to setup
>
> have you ever done anything with python?
>
Not really.
> Do you feel somehow comfortable with linux?
>
I am comfortable with Linux, yes.
Thanks.
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: GUI tool for Raspberry Pi - PostgreSQL 11.5
2019-09-20 13:03 GUI tool for Raspberry Pi - PostgreSQL 11.5 Ertan Küçükoðlu <ertan.kucukoglu@1nar.com.tr>
2019-09-20 14:08 ` Re: GUI tool for Raspberry Pi - PostgreSQL 11.5 robert@redo2oo.ch <robert@redo2oo.ch>
2019-09-20 15:57 ` Re: GUI tool for Raspberry Pi - PostgreSQL 11.5 Ertan Küçükoğlu <ertan.kucukoglu@1nar.com.tr>
@ 2019-09-20 18:11 ` robert <robert@redo2oo.ch>
1 sibling, 0 replies; 13+ messages in thread
From: robert @ 2019-09-20 18:11 UTC (permalink / raw)
To: Ertan Küçükoğlu <ertan.kucukoglu@1nar.com.tr>; +Cc: pgsql-admin@lists.postgresql.org
On 20/09/2019 17:57, Ertan Küçükoğlu wrote:
> Hello,
>
>> On 20 Sep 2019, at 18:21, robert@redo2oo.ch <robert@redo2oo.ch> wrote
>>
>> pgadmin4 is simple to setup
>>
>> have you ever done anything with python?
>>
> Not really.
>>
>> Do you feel somehow comfortable with linux?
>>
> I am comfortable with Linux, yes.
ok,
I will write a description how to do it
hope to do it tomorow or (rather) sunday
robert
>
> Thanks.
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: GUI tool for Raspberry Pi - PostgreSQL 11.5
2019-09-20 13:03 GUI tool for Raspberry Pi - PostgreSQL 11.5 Ertan Küçükoðlu <ertan.kucukoglu@1nar.com.tr>
2019-09-20 14:08 ` Re: GUI tool for Raspberry Pi - PostgreSQL 11.5 robert@redo2oo.ch <robert@redo2oo.ch>
2019-09-20 15:57 ` Re: GUI tool for Raspberry Pi - PostgreSQL 11.5 Ertan Küçükoğlu <ertan.kucukoglu@1nar.com.tr>
@ 2019-09-20 18:16 ` robert <robert@redcor.ch>
1 sibling, 0 replies; 13+ messages in thread
From: robert @ 2019-09-20 18:16 UTC (permalink / raw)
To: Ertan Küçükoğlu <ertan.kucukoglu@1nar.com.tr>; +Cc: pgsql-admin@lists.postgresql.org
On 20/09/2019 17:57, Ertan Küçükoğlu wrote:
> Hello,
>
>> On 20 Sep 2019, at 18:21, robert@redo2oo.ch <robert@redo2oo.ch> wrote
>>
>> pgadmin4 is simple to setup
>>
>> have you ever done anything with python?
>>
> Not really.
>> Do you feel somehow comfortable with linux?
>>
> I am comfortable with Linux, yes.
ok,
I will write a description how to do it
hope to do it tomorow or (rather) sunday
robert
> Thanks.
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: GUI tool for Raspberry Pi - PostgreSQL 11.5
2019-09-20 13:03 GUI tool for Raspberry Pi - PostgreSQL 11.5 Ertan Küçükoðlu <ertan.kucukoglu@1nar.com.tr>
@ 2019-09-20 14:10 ` robert rottermann <robert@redcor.ch>
4 siblings, 0 replies; 13+ messages in thread
From: robert rottermann @ 2019-09-20 14:10 UTC (permalink / raw)
To: Ertan Küçükoğlu <ertan.kucukoglu@1nar.com.tr>; pgsql-admin@lists.postgresql.org
Ertan
On 20.09.19 15:03, Ertan Küçükoðlu wrote:
> Hello,
>
> I am looking for a tool other than pgAdmin3 for Raspberry Pi running on
> Debian 10 Buster. I need basic things like create user, run SQL on tables,
> view structure of a table.
>
> pgAdmin3 is barely running and raising a lot of errors. pgAdmin4 is not in
> "apt" list of applications and I really do not like that I have to run a
> browser for it. There are a lot of alternatives for Windows based solution.
> I cannot find something for Raspberry Pi.
pgadmin4 is simple to setup
have you ever done anything with python?
Do you feel somehow comfortable with linux?
robert
> It would be good to have a free tool though I am willing to pay a small fee
> for a tool that will do my basics.
>
> Any help is appreciated.
>
> Thanks & regards,
> Ertan Küçükoðlu
>
>
>
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: GUI tool for Raspberry Pi - PostgreSQL 11.5
2019-09-20 13:03 GUI tool for Raspberry Pi - PostgreSQL 11.5 Ertan Küçükoðlu <ertan.kucukoglu@1nar.com.tr>
@ 2019-09-20 14:37 ` Laurenz Albe <laurenz.albe@cybertec.at>
2019-09-20 16:03 ` Re: GUI tool for Raspberry Pi - PostgreSQL 11.5 Ertan Küçükoğlu <ertan.kucukoglu@1nar.com.tr>
4 siblings, 1 reply; 13+ messages in thread
From: Laurenz Albe @ 2019-09-20 14:37 UTC (permalink / raw)
To: Ertan Küçükoğlu <ertan.kucukoglu@1nar.com.tr>; pgsql-admin@lists.postgresql.org
Ertan Küçükoğlu wrote:
> I am looking for a tool other than pgAdmin3 for Raspberry Pi running
> on Debian 10 Buster. I need basic things like create user, run SQL on
> tables, view structure of a table.
Why do you want a GUI for that?
On a resource constrained machine, use the command line client "psql".
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: GUI tool for Raspberry Pi - PostgreSQL 11.5
2019-09-20 13:03 GUI tool for Raspberry Pi - PostgreSQL 11.5 Ertan Küçükoðlu <ertan.kucukoglu@1nar.com.tr>
2019-09-20 14:37 ` Re: GUI tool for Raspberry Pi - PostgreSQL 11.5 Laurenz Albe <laurenz.albe@cybertec.at>
@ 2019-09-20 16:03 ` Ertan Küçükoğlu <ertan.kucukoglu@1nar.com.tr>
2019-09-20 16:06 ` Re: GUI tool for Raspberry Pi - PostgreSQL 11.5 Geoff Winkless <pgsqladmin@geoff.dj>
0 siblings, 1 reply; 13+ messages in thread
From: Ertan Küçükoğlu @ 2019-09-20 16:03 UTC (permalink / raw)
To: Laurenz Albe <laurenz.albe@cybertec.at>; +Cc: pgsql-admin@lists.postgresql.org
> On 20 Sep 2019, at 17:37, Laurenz Albe <laurenz.albe@cybertec.at> wrote:
>
> Ertan Küçükoğlu wrote:
>> I am looking for a tool other than pgAdmin3 for Raspberry Pi running
>> on Debian 10 Buster. I need basic things like create user, run SQL on
>> tables, view structure of a table.
>
> Why do you want a GUI for that?
For convenience.
>
> On a resource constrained machine, use the command line client "psql".
I have tables with relatively many columns. Anything printed on console won't fit it's boundaries and won't be easy to read. I am using some gui application on it and most of the time find it easy to put two window next to each other to see what I'm looking for.
Even it is resource constrained Raspberry Pi, it still can handle quite a good job for somewhat big jobs. Especially latest version 4 with high ram models.
Thanks.
Ertan
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: GUI tool for Raspberry Pi - PostgreSQL 11.5
2019-09-20 13:03 GUI tool for Raspberry Pi - PostgreSQL 11.5 Ertan Küçükoðlu <ertan.kucukoglu@1nar.com.tr>
2019-09-20 14:37 ` Re: GUI tool for Raspberry Pi - PostgreSQL 11.5 Laurenz Albe <laurenz.albe@cybertec.at>
2019-09-20 16:03 ` Re: GUI tool for Raspberry Pi - PostgreSQL 11.5 Ertan Küçükoğlu <ertan.kucukoglu@1nar.com.tr>
@ 2019-09-20 16:06 ` Geoff Winkless <pgsqladmin@geoff.dj>
0 siblings, 0 replies; 13+ messages in thread
From: Geoff Winkless @ 2019-09-20 16:06 UTC (permalink / raw)
To: Ertan Küçükoğlu <ertan.kucukoglu@1nar.com.tr>; +Cc: pgsql-admin@lists.postgresql.org
On Fri, 20 Sep 2019 at 17:03, Ertan Küçükoğlu
<ertan.kucukoglu@1nar.com.tr> wrote:
> > On 20 Sep 2019, at 17:37, Laurenz Albe <laurenz.albe@cybertec.at> wrote:
> > On a resource constrained machine, use the command line client "psql".
> I have tables with relatively many columns. Anything printed on console won't fit it's boundaries and won't be easy to read. I am using some gui application on it and most of the time find it easy to put two window next to each other to see what I'm looking for.
Can heartily recommend the superb pspg. Use two putty windows if that helps.
https://github.com/okbob/pspg
Geoff
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: GUI tool for Raspberry Pi - PostgreSQL 11.5
2019-09-20 13:03 GUI tool for Raspberry Pi - PostgreSQL 11.5 Ertan Küçükoðlu <ertan.kucukoglu@1nar.com.tr>
@ 2019-09-20 15:05 ` Joshua Kramer <joskra42.list@gmail.com>
2019-09-20 16:09 ` Re: GUI tool for Raspberry Pi - PostgreSQL 11.5 Ertan Küçükoğlu <ertan.kucukoglu@1nar.com.tr>
4 siblings, 1 reply; 13+ messages in thread
From: Joshua Kramer @ 2019-09-20 15:05 UTC (permalink / raw)
To: Ertan Küçükoğlu <ertan.kucukoglu@1nar.com.tr>; +Cc: pgsql-admin@lists.postgresql.org
There is a program called "pspg" that makes it easy to browse query results
in a terminal... but it would be beneficial for you to learn the SQL syntax
to do things such as create user.
On Fri, Sep 20, 2019, 9:03 AM Ertan Küçükoğlu <ertan.kucukoglu@1nar.com.tr>
wrote:
> Hello,
>
> I am looking for a tool other than pgAdmin3 for Raspberry Pi running on
> Debian 10 Buster. I need basic things like create user, run SQL on tables,
> view structure of a table.
>
> pgAdmin3 is barely running and raising a lot of errors. pgAdmin4 is not in
> "apt" list of applications and I really do not like that I have to run a
> browser for it. There are a lot of alternatives for Windows based solution.
> I cannot find something for Raspberry Pi.
>
> It would be good to have a free tool though I am willing to pay a small fee
> for a tool that will do my basics.
>
> Any help is appreciated.
>
> Thanks & regards,
> Ertan Küçükoğlu
>
>
>
>
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: GUI tool for Raspberry Pi - PostgreSQL 11.5
2019-09-20 13:03 GUI tool for Raspberry Pi - PostgreSQL 11.5 Ertan Küçükoðlu <ertan.kucukoglu@1nar.com.tr>
2019-09-20 15:05 ` Re: GUI tool for Raspberry Pi - PostgreSQL 11.5 Joshua Kramer <joskra42.list@gmail.com>
@ 2019-09-20 16:09 ` Ertan Küçükoğlu <ertan.kucukoglu@1nar.com.tr>
2019-09-21 13:25 ` Re: GUI tool for Raspberry Pi - PostgreSQL 11.5 Anthony E. Greene <agreene@pobox.com>
0 siblings, 1 reply; 13+ messages in thread
From: Ertan Küçükoğlu @ 2019-09-20 16:09 UTC (permalink / raw)
To: Joshua Kramer <joskra42.list@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org
> On 20 Sep 2019, at 18:06, Joshua Kramer <joskra42.list@gmail.com> wrote:
>
>
> There is a program called "pspg" that makes it easy to browse query results in a terminal... but it would be beneficial for you to learn the SQL syntax to do things such as create user.
Hello,
I know basic sql syntax for running select queries, inserts, etc. For other tasks like create user I mostly open documentation and check syntax. It's easy for me to mix different create user syntax between several dbms. I don't run such commands frequently.
My main usage is to see select results.
Thanks.
Ertan
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: GUI tool for Raspberry Pi - PostgreSQL 11.5
2019-09-20 13:03 GUI tool for Raspberry Pi - PostgreSQL 11.5 Ertan Küçükoðlu <ertan.kucukoglu@1nar.com.tr>
2019-09-20 15:05 ` Re: GUI tool for Raspberry Pi - PostgreSQL 11.5 Joshua Kramer <joskra42.list@gmail.com>
2019-09-20 16:09 ` Re: GUI tool for Raspberry Pi - PostgreSQL 11.5 Ertan Küçükoğlu <ertan.kucukoglu@1nar.com.tr>
@ 2019-09-21 13:25 ` Anthony E. Greene <agreene@pobox.com>
0 siblings, 0 replies; 13+ messages in thread
From: Anthony E. Greene @ 2019-09-21 13:25 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
On 20-Sep-2019/19:09 +0300, Ertan Küçükoğlu <ertan.kucukoglu@1nar.com.tr> wrote:
>
>My main usage is to see select results.
I have used zenity and a shell script for this.
The script uses zenity to present a list of databases. The script assumes
you do not need credentials to connect to the database. You could specify
a connection string if username/password credentials are needed.
After selecting a database, a zenity text input dialog is displayed so
that you can enter a command. The script uses psql to run the command,
with the --html option to output to an HTML file. It then uses xdg-open to
launch your default HTML viewer with the file.
My browser opens a new tab every time, but I can live with that.
The script redisplays the zenity text input box after each command, until
you select the Cancel button, use the Escape key, or close the zenity
window.
It does not check syntax, and it does not report errors. It only provides
a quick way to run queries and get the results in a browser.
Let me know if you're interested.
--
Anthony E. Greene <mailto:agreene@pobox.com>
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: GUI tool for Raspberry Pi - PostgreSQL 11.5
2019-09-20 13:03 GUI tool for Raspberry Pi - PostgreSQL 11.5 Ertan Küçükoðlu <ertan.kucukoglu@1nar.com.tr>
@ 2019-09-21 14:12 ` Björn Lundin <b.f.lundin@gmail.com>
4 siblings, 0 replies; 13+ messages in thread
From: Björn Lundin @ 2019-09-21 14:12 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
> 20 sep. 2019 kl. 15:03 skrev Ertan Küçükoğlu <ertan.kucukoglu@1nar.com.tr>:
>
> Hello,
>
> I am looking for a tool other than pgAdmin3 for Raspberry Pi running on
> Debian 10 Buster. I need basic things like create user, run SQL on tables,
> view structure of a table.
I use pgadmin3 from Mac to query a database on my raspberry pi
Use a client-tool from another computer, or use psql on the pi
--
Björn Lundin
b.f.lundin <AT> gmail.com
^ permalink raw reply [nested|flat] 13+ messages in thread
end of thread, other threads:[~2019-09-21 14:12 UTC | newest]
Thread overview: 13+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2019-09-20 13:03 GUI tool for Raspberry Pi - PostgreSQL 11.5 Ertan Küçükoðlu <ertan.kucukoglu@1nar.com.tr>
2019-09-20 14:08 ` robert@redo2oo.ch <robert@redo2oo.ch>
2019-09-20 15:57 ` Ertan Küçükoğlu <ertan.kucukoglu@1nar.com.tr>
2019-09-20 18:11 ` robert <robert@redo2oo.ch>
2019-09-20 18:16 ` robert <robert@redcor.ch>
2019-09-20 14:10 ` robert rottermann <robert@redcor.ch>
2019-09-20 14:37 ` Laurenz Albe <laurenz.albe@cybertec.at>
2019-09-20 16:03 ` Ertan Küçükoğlu <ertan.kucukoglu@1nar.com.tr>
2019-09-20 16:06 ` Geoff Winkless <pgsqladmin@geoff.dj>
2019-09-20 15:05 ` Joshua Kramer <joskra42.list@gmail.com>
2019-09-20 16:09 ` Ertan Küçükoğlu <ertan.kucukoglu@1nar.com.tr>
2019-09-21 13:25 ` Anthony E. Greene <agreene@pobox.com>
2019-09-21 14:12 ` Björn Lundin <b.f.lundin@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox