Best non-networked front end for postgresql

2018-01-21 19:57 GMT+01:00 Sherman Willden <operasopranos@gmail.com>:

Name: Sherman

Single laptop: Compaq 6710b

Operating System: Ubuntu 17.10

Postgresql: 9.6

Used for: Just me and my home database

Seeking advice: Best non-networked front-end

Considerations: I am retired and want to create my own database and database
captures. I have experience with PERL

Basic question 1: Which non-networked front-end would work best for me?

Basic question 2: I am seriously considering HTML fields to capture and
process the information. So to connect with postgresql what do I need to
know? Do I need to know javascript, python, and other languages? How is PERL
for something like this?

I am entering the below values by hand into a functional database. I thought
that I would create some type of front-end to enter the values and then have
the front-end enter the values into the postgresql database.
01). visit_date
02). start_time
03). end_time
04). venue (This is the casino name)
05). city
06). state
07). limit (4/8 20/40 etc)
08). game (7-card-stud etc)
09). variant (fixed-limit no-limit etc)
10). high-low (mixed-high-low high-only etc)
11). buy_in
12). cash_out

Thank you;

Sherman

PGAdmin is among the best tools to manage Postgres.

https://www.pgadmin.org/

As far as a front-end program, perl can be used.
As well as a number of other languages ranging from C, C++, Java, PHP.
Almost all languages have a "module" to interact with Postgres databases.
The best one is IMHO the one you know the best.

P.S.
The differences between a local Unix socket and a TCP one are rather
subtle from your point of view.

--
Vincenzo Romano - NotOrAnd.IT
Information Technologies
--
NON QVIETIS MARIBVS NAVTA PERITVS

On 21/01/18 19:05, Vincenzo Romano wrote:

2018-01-21 19:57 GMT+01:00 Sherman Willden <operasopranos@gmail.com>:

Name: Sherman

Single laptop: Compaq 6710b

Operating System: Ubuntu 17.10

Postgresql: 9.6

Used for: Just me and my home database

Seeking advice: Best non-networked front-end

Considerations: I am retired and want to create my own database and database
captures. I have experience with PERL

Basic question 1: Which non-networked front-end would work best for me?

Basic question 2: I am seriously considering HTML fields to capture and
process the information. So to connect with postgresql what do I need to
know? Do I need to know javascript, python, and other languages? How is PERL
for something like this?

I am entering the below values by hand into a functional database. I thought
that I would create some type of front-end to enter the values and then have
the front-end enter the values into the postgresql database.
01). visit_date
02). start_time
03). end_time
04). venue (This is the casino name)
05). city
06). state
07). limit (4/8 20/40 etc)
08). game (7-card-stud etc)
09). variant (fixed-limit no-limit etc)
10). high-low (mixed-high-low high-only etc)
11). buy_in
12). cash_out

Thank you;

Sherman

PGAdmin is among the best tools to manage Postgres.

https://www.pgadmin.org/

As far as a front-end program, perl can be used.
As well as a number of other languages ranging from C, C++, Java, PHP.
Almost all languages have a "module" to interact with Postgres databases.
The best one is IMHO the one you know the best.

P.S.
The differences between a local Unix socket and a TCP one are rather
subtle from your point of view.

+1 for pgadmin - indeed why bother with anything else for one flat
table? How many rows of data do you envisage?

--
Tim Clarke

On 01/21/2018 10:57 AM, Sherman Willden wrote:

Name: Sherman

Single laptop: Compaq 6710b

Operating System: Ubuntu 17.10

Postgresql: 9.6

Used for: Just me and my home database

Seeking advice: Best non-networked front-end

Considerations: I am retired and want to create my own database and
database captures. I have experience with PERL

Can you explain more what you mean by database captures?

Basic question 1: Which non-networked front-end would work best for me?

Basic question 2: I am seriously considering HTML fields to capture and
process the information. So to connetct with postgresql what do I need to
know? Do I need to know javascript, python, and other languages? How is
PERL for something like this?

So does the above mean you want to use a Web based application to enter
data into your database?

The way I see it you have two components to your question, managing the
database e.g. creating the database and contained objects and
manipulating the data within the created objects. For the management
component Vincenzo's suggestion of pgAdmin or using the Postgres command
line client psql would work. For the second component, building
entry/reporting forms it comes down to how involved you want to get into
coding.

I am entering the below values by hand into a functional database. I
thought that I would create some type of front-end to enter the values
and then have the front-end enter the values into the postgresql database.
01). visit_date
02). start_time
03). end_time
04). venue (This is the casino name)
05). city
06). state
07). limit (4/8 20/40 etc)
08). game (7-card-stud etc)
09). variant (fixed-limit no-limit etc)
10). high-low (mixed-high-low high-only etc)
11). buy_in
12). cash_out

Thank you;

Sherman

--
Adrian Klaver
adrian.klaver@aklaver.com

On Sun, Jan 21, 2018 at 11:57:39AM -0700, Sherman Willden wrote:

Basic question 1: Which non-networked front-end would work best for me?

Basic question 2: I am seriously considering HTML fields to capture and
process the information. So to connect with postgresql what do I need to
know? Do I need to know javascript, python, and other languages? How is
PERL for something like this?

PostgreSQL supports a wide range of drivers:
https://wiki.postgresql.org/wiki/List_of_drivers
If you are fluent with perl, with not playing with DBD::Pg then? Here is
its documentation:
https://metacpan.org/pod/DBD::Pg

I am entering the below values by hand into a functional database. I
thought that I would create some type of front-end to enter the values and
then have the front-end enter the values into the postgresql database.
01). visit_date
02). start_time
03). end_time
04). venue (This is the casino name)
05). city
06). state
07). limit (4/8 20/40 etc)
08). game (7-card-stud etc)
09). variant (fixed-limit no-limit etc)
10). high-low (mixed-high-low high-only etc)
11). buy_in
12). cash_out

This is the kind of area where pgadmin can help I think:
https://www.pgadmin.org/

Still, the most interesting portion in hacking is by doing things
yourself, so why not giving a shot to perl and write your own set of
scripts?
--
Michael