Find peak cases

This entry is part 4 of 4 in the series Exploring data with SQL

Back in the Database Programming section of this series, we created the view named us_counties_new, showing the daily new case load. Recall that we first computed the seven-day running average of the total case loads in the us_counties_avg7 view, then used those numbers for the daily case loads. Having the daily case loads available lets … Read more

Getting started with the data

This entry is part 2 of 4 in the series Exploring data with SQL

The Times’s data is here. https://raw.githubusercontent.com/nytimes/covid-19-data/master/us-counties.csv If you’re using a browser, open the context menu (right-click) on that link and use the Save Link As … operation to put it into a file on your system. We’ll use it later to load the database. Use your database interface program to log in to your database … Read more

Choropleths: color-coded maps showing data by state or other geography

A Choropleth is a colored map, typically showing information gathered by some kind of census. A well-known example is the New York Times’s COVID-19 map. Let’s say you have some data that’s coded by geographic area. For example, you might have a table showing the number of COVID cases per 100,000 people county by county in … Read more

getDisplayMedia vs. getUserMedia

I’ve been messing around with the browser API navigator.mediaDevices.getDisplayMedia(). The question I hoped to answer: can I capture the content in some computer display surface and push it through the same sorts of process that I use with .getUserMedia()? I tested on Google Chrome 84. Answer: yes. It has some quirks. It doesn’t need, and … Read more

New Microsoft Edge rolls out to everybody this month

About time! the new Chromium-based Edge browser will show up on Windows 10 machines in this month’s update. For the cancelled Internet Explorer and Legacy Edge project people, I would have more sympathy if their work products hadn’t baffled software developers for a quarter-century. IE and old Edge were in the uncanny valley of compatibility. … Read more

Rig Windows 10 to make work easier

There are some quick and easy things you can do to make Windows 10 easier to use. X Window System display server Download and install the free and open-source vcsxrv package from SourceForge. Then, configure your ssh to forward X11 packets. Then, when you ssh to a Linux or FreeBSD box, you’ll be able to … Read more

Web Service APIs in dotnet C# made easy with ApiController: Part 1

This entry is part 1 of 3 in the series .NET Web Services

Setting up your web service Dotnet’s stuff for developing web applications includes an inheritable class called ApiController. This makes it easy to develop REST-style web services, either for standalone API servers or in the context of larger servers. To start using ApiController, however, requires navigating lots of Microsoft documentation; as of early 2020 that documentation … Read more

Web Services in C#: Status, Parameters, Cookies

This entry is part 2 of 3 in the series .NET Web Services

Status Codes Real Web services have to be able to pass back a status code. Maybe it’s a plain 200 success code, or a 404 not found code. Whatever. We have to be able to control it. Here’s how. We’ll use the NegotiatedContentResult template class in the signature for the Get method. We have to … Read more