I think we need a database and SQL seems the obvious choice. On inspection of the data, I think the implementation schema looks like this.<\/p>\n\n\n
![\"\"](\"https:\/\/davelevy.info\/wiki\/wp-content\/uploads\/2023\/04\/polpostcode-schema.png\")
<\/a>The ONS data uses a constituency code as a surrogate key. The database would probably be easier to implement using this as the foreign key, but the solution would be more compact if the name was used as the foreign key. (Does this mean that constituency name needs to be fixed length, I mean I think not.) postcode.constituencyname is the foreign key to constituency table.<\/p>\n\n\n\n
An alternative to an SQL database might by a javascript or python daemon.<\/p>\n\n\n\n
Which Database?<\/h3>\n\n\n\n
I need to choose a database and hosting provider. \u00a0I could host my own at dfl.ddns.net, but, I ran a google query, free database service<\/a> and the answers focused on free software not a free service, but I found, 14 best free database hosting\/<\/a> by Laura Bernheim at hostingadvice.com, which while offering some free services reminds me I have the capacity to build the database within my ionos<\/a> account. And there’s this, 6 databases for Raspberry Pi<\/a>. and this which recommends a more traditional five<\/a> i.e. I have heard of all of them.<\/p>\n\n\n\n Yeah, not sure! The best answer would seem to be javascript<\/a>, but there maybe other solutions<\/a>, python or PHP, maybe even RDF & SPARQL although that would take a lot of skill that I don’t currently posses.<\/p>\n","protected":false},"excerpt":{"rendered":" How to get an MP name from a post code? I fancy doing this, Obviously \u201cthey work for you\u201d have this? Could I write a script or copy their code? I had a look and on first review their database is obfuscated. Can I build my own and how and where to host it? I…<\/p>\n","protected":false},"author":1,"featured_media":7745,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","_share_on_mastodon":"0"},"categories":[140,3],"tags":[141,1914,1035,911,1421,130,849,1861],"class_list":["post-7742","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-politics","category-technology","tag-politics-2","tag-postcode","tag-sql","tag-technology","tag-web-hosting","tag-web-services","tag-webdesign","tag-websites"],"share_on_mastodon":{"url":"","error":""},"jetpack_featured_media_url":"https:\/\/davelevy.info\/wiki\/wp-content\/uploads\/2023\/04\/web-domain-service-website-development-seo-1571969-pxhere.com_.jpg","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/posts\/7742","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/comments?post=7742"}],"version-history":[{"count":4,"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/posts\/7742\/revisions"}],"predecessor-version":[{"id":7758,"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/posts\/7742\/revisions\/7758"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/media\/7745"}],"wp:attachment":[{"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/media?parent=7742"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/categories?post=7742"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/tags?post=7742"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}Queries on the net<\/h3>\n\n\n\n