Summersault
Home About Us Services Portfolio Community Support
Database Driven Websites
community home
local community
partner community
online community
blog


Archives: Categories: Authors:

 

Summersault Blog

Archive for October, 2005

Validating Web forms with Perl

Posted by Mark Stosberg on October 25th, 2005

One of the most frequent uses of Perl in my job is to validate web-based forms. Here’s some explanation and sample code to how I do that efficiently and effectively.

Read the rest of this entry »


Reporting on disk space usage for PostgreSQL and MySQL databases

Posted by Mark Stosberg on October 25th, 2005

I was recently tasked with finding out how much each disk space each of our PostgreSQL and MySQL databases was taking up.

The job was considerably easier for PostgreSQL, which ships with tools in contrib/dbsize to do just this. After following the simple instructions there, all that was necessary for easy reporting was to create a simple view. Here’s the one I used:
Read the rest of this entry »


Flock: Building a Better Bookmark

Posted by Mark Stosberg on October 23rd, 2005

Today I downloaded and tried the view preview release of Flock, a new web browser based on Firefox.

I went into the experience cynical, having used many browsers in my experience as a professional website developer. What else could they possibly add that I would really want?

I found one feature in Flock that by itself makes it worth considering the browser.

Flock has built a better bookmark.

Read the rest of this entry »


Reduce remote (ab)use of your website images

Posted by Chris Hardie on October 18th, 2005

It’s a pretty common problem: you have an image on your website that’s attractive or useful to someone else - a logo, a photo, a cool piece of art. They build a web page hosted somewhere out there that makes a reference to your image. Now every time a user visits that person’s site, the user’s web browser loads up the image from your site, using up your bandwidth and, in many cases, displaying it for purposes you hadn’t really intended - sometimes called “hotlinking”. The other day I found someone who was using a 6MB image from my personal site as a background image for theirs - and they were apparently pretty popular, so it created a lot of large requests on our webserver. Recently one of our hosting clients and longtime friend of Summersault, Justin Simoni, was having this happen so much that he was regularly exceeding his bandwidth quota and incurring all sorts of hassle. So, we tackled the problem head-on, and even though there are lots of references around the net on how to limit this problem, none quite seemed to document the particular method we used. I’ll do that here in case anyone else finds it useful.
Read the rest of this entry »


The opinions expressed by individuals posting in the Summersault Blog are not necessarily those of Summersault, LLC. While we try to insure the quality and accuracy of the information presented here, we make no guarantees about its suitability for any particular purpose.