Thread: 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