Alan Coleman
Web Dev & Creative Blog
Welcome to my Web Dev & Creative Blog. I'm a web developer interested in technology, design and photography.
Category Archives: SQL
SQL Filtering against a time stamp
Every time I come to write an SQL query that uses the current time against a time stamp in a record, someone always seems to suggest a different way of solving the problem. That in itself isn’t an issue, there’s … Continue reading
Database caching of non dynamic content
We run a dynamic website that retrieves information from a relational database. There’s lots of content involved across loads of domains and in several languages, this makes the site fairly heavy. Performance is as important as ever and it’s only … Continue reading
Strored Procedures
I’ve been working on a project over the last week that involves fairly heavy use of Stored Procedures. It’s not a new technology and we’re not that new to it either, it’s just that during the development cycle the logic … Continue reading
jetaway.com
jetaway.com is a database driven site providing a travel agency style flight booking facility. It uses Active Server Pages to query and update a database. The design is based around a simple colour and logo scheme that is implemented using … Continue reading