use DBI;
$dbh = connect(.........);
$dbh->prepare('INSERT INTO weathercache (latitude, longitude, weather, cached) VALUES (?, ?, ?, NOW())')->execute(50.530998, -4.949000, '');