- unix ·
- ·
- ·
SSH Tunnel for PostgreSQL Connection on AWS EC2
AWS has become a fairly ubiquitous hosting option for small companies. But developers typically work on local dev setups outside the host and occasionally need access to the main dev and staging databases located on AWS. How do you do this and still run in a secure environment? One thing you don’t do is poke…
SMB+SSH: Ubuntu server and OSX client
The title above is pretty close to the Google search query I used in vain to find a recipe for tunneling an OSX Samba client to an Ubuntu 14.04 server. Hopefully this post will save someone the hours I spent trying to set this up. In the end, like so many Unix projects, the answer turned out…
- postgresql ·
- sql ·
- ·
- ·
Optimizing a Result Set Pager
It’s ubiquitous on data driven web sites: the result set pager. We’ve all used them whether we built them from scratch or used one provided by the framework. Pagers are by nature performance suckers because we’re asking the database to re-run the same query for each “page”, slicing off just one set of contiguous rows…
- ssh ·
- ·
- ·
Remote SSH Filesystems on OSX
Developers, particularly web developers, have a need to work on external computers, often not within their local networks. Over the years I’ve employed everything from FTP to SFTP/SCP to Samba to NFS to VPNs to cranky Novell networks. All have their downsides, particularly with regard to security. I have a MacPro and originally ran NFS to connect to machines on my LAN. But as…
- drupal ·
- ·
- ·
Embedding a View in a Node
A couple of people asked me how I embedded the client logo slideshow inside the content area of the “Brooklyn Technical Services has over 20 years’ experience…” node on the front page here. Actually, that was the easy part. The hard part was building that slideshow, mainly because I hadn’t done it with Drupal 7…
- applications ·
- stained glass ·
- ·
- ·
Holiday fun: Designing a stained glass Christmas tree with GlassEye 2000
One of my hobbies is constructing stained glass, which is something I got into out of necessity while restoring an old house in Brooklyn. The cost for replacing or, worse, restoring old stained glass panels was frightening enough that I took some classes to learn how to do it myself. Fortunately, I learned that working…