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.

News is bad for you, but there’s a way to take control and change that