Hi, I have an iPad and a small network of macs and fedora/windoze machines at home. I am running pg 8.4.4 on all of the 'real' computers. I have been hoping that some developer would create an iPad app that would allow me to access my home database ( i am getting a bit long in the tooth and remembering passwords for discussion groups and similar stuff is getting hard to remember). I can securely access my home net via VPN (or ssh ). I do have a terminal app on the iPad that groks ssh ( or just use the VPN). But psql on the terminal apps is not pleasant to use, I get a lot of wrapping due to the screen size... I recalled that I had written a 'cgi' that would let me connect to a pg database, execute sql and display the results in a html table. The bad news is that after 11 or so years my perl foo has vanished. This afternoon I tried my hand at installing the necessary perl modules to be able to talk to pg. I am running the latest MacOSX and using the Apple installed perl. I had to force install DBD::Pg and was afraid it would die when invoked. Much to my surprise the cgi worked! I can access the db and execute single sql statements and select results are displayed in a table. I have a 'more' button in case there are more than 500 rows... The cgi has two meta-commands, 'table' and 'describe <table>'. The 'table' command lists all of the tables in a db and the describe command attempts to list the column names and data types ( does not work for schema qualified table names). So what I have does give me access to my Pg db from anywhere on my iPad but now that I have a taste: Is there an idiot installable package for MacOsX Snow Leopard that will provide a 'better' user experience for accessing Pg via the web, especially when viewed on the iPad? I would be grateful if a Perl/Pg person would take a look at the rempgsql.pl script and make it mo'better. The script is located at http://homepage.mac.com/levanj/Perl/ Thanks, Jerry -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
