Hacker News Reader

Hacker News

Comment by Bishonen88 | Hacker News Reader

Full thread

Bishonen88

Anything similar with python perhaps?

View on HN

It works with docker, so you don't have to worry about having perl.

>docker run -it --rm jfcoz/postgresqltuner --host=dbhost --user=username --password=pass --database=testdb

You gonna pull a random image into prod and give it access to prod db :)?

It's no more a "random image" than the script itself is a random software.

it's a lot easier to audit a script

Dockerfile is a script of sorts too you can audit that

Nothing guarantees the image in docker hub has anything to do with the Dockerfile or this repo. This is a valid concern.

Except it does, docker hub builds it with that Dockerfile.

Docker hub allows any user with the appropriate permissions to `docker push` any image they want.

It is just a perl script (in this case), just one that needs 45MB of baggage.

Also the Dockerfile seems to be in the repo. Looks like it just installs some apt packages and adds the script file: https://github.com/jfcoz/postgresqltuner/blob/master/Dockerf...

Is not having Perl such a worry? I'd imagine most systems that use this also use Git and that requires Perl, and I'm not aware of any GNU/Linux distro that doens't come with Perl (5, of course) pre-installed. While we're speaking of Perl, I just want to say how amazing Perl 6 is, especially compared to Perl 5, in every regard - from syntax to arrays/lists to the quality of the (admittedly small range of) libraries.

Perl and python are part of LSB.

+1 for Perl 6 shout out. Also there are increasingly nice things for use with Postgres like https://github.com/CurtTilmes/perl6-dbpg with https://github.com/FCO/Red

If you for some reason can not use docker and don't want to pollute your system globally with cpan packages, you can use a locallib install instead. CentOS example:

  sudo yum -y install postgresql-devel   
  sudo useradd -d /home/pgsqltun -m -s /bin/bash -c"pgsql tuner user"  psqltun
  sudo su - psqltun   
  wget -O- https://cpanmin.us | perl - -l $HOME/perl5 App::cpanminus local::lib
  echo 'eval `perl -I $HOME/perl5/lib/perl5 -Mlocal::lib`' >> $HOME/.bash_profile
  echo 'export MANPATH=$HOME/perl5/man:$MANPATH' >> $HOME/.bash_profile
  . .bash_profile
  cpanm DBD::Pg
  <install postgresqltuner.pl>

Reply on news.ycombinator.com