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…
Read more

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…
Read more

Did your wallpaper suddenly turn grey?

This can occasionally happen when OSX recovers from a deep sleep, particularly on dual-monitor systems where there already issues with the cabling. The fix: Open up Terminal and type the following: sudo killall Dock That should restore the wallpaper for both terminals. I ran into another problem with my Viewsonic secondary monitor related to recovering…
Read more

Database Meets Revision Control

Any developer who has worked with HIPAA compliancy knows that the law is murky at best and the fed doesn’t publish a programmers’ guide to make your life any easier.  However, one of the cardinal rules is the requirement to keep track of who sees HIPAA data, who modifies it and when this was done. …
Read more
All articles loaded
No more articles to load
Scroll to Top