I’ve had the occasion to move the domain for Sheffield Environment Weeks from a local IT company’s control to Ionos and I wanted to record what happened for future reference.
Takeaways at the bottom:
The state of the site The site had the following major issues:
No mobile support Required outdated PHP 5 - no upgrade path Broken in many and various ways. (Analytics, sending emails, spam) SSL configured but wrongly, causing browsers to tell mobile users the site was unsafe, and this was starting to show on desktop browsers too.
This post is about trying to limit SQL queries, by the use of a method
called “caching”. I’m going to talk about different methods ways of thinking about caching.
I’ve been working for a client, and the e-commerce solution I built along with Mandy for them has a multi-currency feature. They wanted to have the customer shown the most suitable currency when they arrive on the site, and so we had to come up with a way to do that.
The first thing was to find out which country they were in, and the answer we fell to first was a lookup service by IpLocate.
I spent a lot of my career up to April 2023 working in e-commerce, but I was always focused on specific goals, and specific customers. Mainly Online4baby, but also David Village Lighting, and a couple of others. I worked for these guys for so long and they had such unique needs that they ended up with their own bespoke systems.
I’ve often wondered what the off the shelf systems can do, and look like.