Category Archives: Postgresql

SSH Tunnels Are Like a Free Cheap VPN

By Andrew Hopper1 | Published: August 21, 2009
If you’re not already familiar with the concept I bet you’d be very interested to learn that you can simulate VPN access to a network as long as you have access to a linux host on that network. These instructions work on OS X and Linux. Putty also has tunneling capabilities, but those are beyond [...]
Also posted in Linux Admin, Networking | Tagged | Leave a comment

Postgres Update from function

By Andrew Hopper | Published: June 3, 2009
I always forgot the syntax of the Postgresql update from functionality UPDATE employees SET sales_count = sales_count + 1 FROM accounts WHERE accounts.name = 'Acme Corporation' AND employees.id = accounts.sales_person;
Posted in Postgresql | Leave a comment