All UK Addresses in SQL
Its something that is always annoying, having to try to do address look-ups, there are loads of third-party services that offer this, but they all charge per lookup or block of look-ups.
We packaged up our complete UK Address list (All of England, Scotland, Wales and Northern Ireland) into a wonderful MySQL Script that runs to create a single Addresses table containing all of the 30,689,521 addresses and Postcodes.
Its a 348Mb zip file, that then expands out into a .sql file that is 3.61Gb in size.