Live data from Hacker News

The implementation of the UK Covid-19 dashboard

techcommunity.microsoft.com

21–30 of 118 posts

Re: The implementation of the UK Covid-19 dashboard

#21

Quoted post unavailable.

Yes. This was never pure ONS data. It was always processed/massaged/tampered with.

Although horrifyingly it did allow you to gauge the Westminster mindset and understand what Draconian measures they were planning to introduce sightly ahead of time because the data would have to reflect this when lord Boris got up on the podium...

Re: The implementation of the UK Covid-19 dashboard

#22

> Government project > awarded to Microsoft Hey Europe, want to stop being several decades behind in IT compared to US/China? One simple trick: Ban FAANG from public procurement in Europe! It‘s a no-brainer really. Buy locally, ideally giving small companies and startups a chance. You will have to do it anyway very soon if you want your privacy laws to be taken seriously. There might be a couple of months of friction…

I really can't agree with this more. My university gives >$2e6/year to Microsoft alone. I'd much rather it gave >$2e6/year to providing jobs for locally employed people, rather than buying someone another yacht.

Re: The implementation of the UK Covid-19 dashboard

#23

> Government project > awarded to Microsoft Hey Europe, want to stop being several decades behind in IT compared to US/China? One simple trick: Ban FAANG from public procurement in Europe! It‘s a no-brainer really. Buy locally, ideally giving small companies and startups a chance. You will have to do it anyway very soon if you want your privacy laws to be taken seriously. There might be a couple of months of friction…

For instance in Finland Azure/AWS/GCP are seen as a superior alternative against anything local/European and we’ve started to move our govermental and healthcare infra into these cloud providers.

Re: The implementation of the UK Covid-19 dashboard

#24

I do wonder if the power of a distributed database is really needed here; it gets ~1 update a day, so there's no need to have clever consistency stuff. Most of the queries relate to either today's data (you open the map and zoom in to see how doomed your area is today), or the graphs showing a standard set of history (e.g. cases over the last year). You'd think you could extract that data to be static and not require…

I had the same thoughts and then it was confirmed how insane this setup is part way through:

“At the time of writing, the Citus distributed database cluster adopted by the team on Azure is HA-enabled for high availability and has 12 worker nodes with a combined total of 192 vCores, ~1.5 TB of memory, and 24 TB of storage. (The Citus coordinator node has 64 vCores, 256 GB of memory, and 1 TB of storage.)”

That’s beyond overkill for something that as you say could be generated statically a couple of times a day.

Re: The implementation of the UK Covid-19 dashboard

#25

I do wonder if the power of a distributed database is really needed here; it gets ~1 update a day, so there's no need to have clever consistency stuff. Most of the queries relate to either today's data (you open the map and zoom in to see how doomed your area is today), or the graphs showing a standard set of history (e.g. cases over the last year). You'd think you could extract that data to be static and not require…

I came here to say exactly this. Is there a reason why they didn’t do it? I couldn’t figure it out from the article.

Re: The implementation of the UK Covid-19 dashboard

#26

> Government project > awarded to Microsoft Hey Europe, want to stop being several decades behind in IT compared to US/China? One simple trick: Ban FAANG from public procurement in Europe! It‘s a no-brainer really. Buy locally, ideally giving small companies and startups a chance. You will have to do it anyway very soon if you want your privacy laws to be taken seriously. There might be a couple of months of friction…

> Microsoft

> Ban FAANG

I know exactly what you mean, but is that what we're doing now? Including Microsoft in FAANG but not changing the acronym?

Re: The implementation of the UK Covid-19 dashboard

#27

I like the UI design in figure 1. There’s no crap in the way of the data but i don’t feel overwhelmed either. My eyes can scan across sections and it feels natural, theres no firehose effect. I like the thought that’s gone into showing the % vaccinated in the top right. I like the dashed underlines telling me that some explainatory text is available. I think the page looks inoffensive but is clearly focussed on being…

In general the gov.uk website is stellar. Lots of good info, and plenty of thought has gone into making everything clear, accessible and pleasing to the eye. Things generally work in a way that they really don't on most public org websites. The team behind it blog a fair bit about how they've made these things happen. https://insidegovuk.blog.gov.uk The only downside is that they often send you to sites run by other,…

They had an early win getting a effective and consistent UI accross government sites, but digitising the underlying processes is a work in progress. Once you click that beautiful and accessible green submit button, it's not impossible a printer in Swansea whirs to life to print your answers out into the original paper form.

Re: The implementation of the UK Covid-19 dashboard

#28

I do wonder if the power of a distributed database is really needed here; it gets ~1 update a day, so there's no need to have clever consistency stuff. Most of the queries relate to either today's data (you open the map and zoom in to see how doomed your area is today), or the graphs showing a standard set of history (e.g. cases over the last year). You'd think you could extract that data to be static and not require…

My guess is that this is sales pitch. It will be rolled out to business customers to say "look at our shiny bells and whistles", and contracts will be signed.

Re: The implementation of the UK Covid-19 dashboard

#29

I do wonder if the power of a distributed database is really needed here; it gets ~1 update a day, so there's no need to have clever consistency stuff. Most of the queries relate to either today's data (you open the map and zoom in to see how doomed your area is today), or the graphs showing a standard set of history (e.g. cases over the last year). You'd think you could extract that data to be static and not require…

I had the same thoughts and then it was confirmed how insane this setup is part way through: “At the time of writing, the Citus distributed database cluster adopted by the team on Azure is HA-enabled for high availability and has 12 worker nodes with a combined total of 192 vCores, ~1.5 TB of memory, and 24 TB of storage. (The Citus coordinator node has 64 vCores, 256 GB of memory, and 1 TB of storage.)” That’s beyon…

My suspicion is that since this has to do with COVID, there is no real limit on what the cost should really be.

As for using the setup for other things, that seems less likely given this expensive setup.

Post reply on HN