Stuff…

Was using CGI::Application::Sesion in a CGI::Application Perl application.  For some reason CGI::Application::Sesion kept on creating new sessions in the database when going to the site.  Really it should have only created and used one session for my client. The same code worked fine prior to upgrading from Ubuntu 8.04 to Ubuntu 10.04.1 LTS.  Some modules [...]

[Read more →]

Excellent blog post about getting rid of the Google Page Speed or YSlow “Serving Static Content from a Cookieless Domain” message: http://www.ravelrumba.com/blog/static-cookieless-domain/

[Read more →]

Google have released an Apache module to optimise content on the fly.  Going to try it out soon: http://code.google.com/speed/page-speed/docs/overview.html

[Read more →]

Wanted the ISO 3166 country codes in my database to use in an application.  Downloaded the semi colon seperated country codes file from:  http://www.iso.org/iso/country_codes/iso_3166_code_lists.htm Then created a database and a table to hold the data: create table country_codes ( id int not null auto_increment, code varchar(2) not null, country varchar(254) not null, primary key (id)); [...]

[Read more →]

I wanted a diagram of the tables I was dealing with in a database from a commercial software package.  The software stored the data in a MySQL database, so, should be pretty easy. I used perl module DBIx::Class for getting a the schema of the database. use DBIx::Class::Schema::Loader qw/ make_schema_at /; Allowed me to connect [...]

[Read more →]