Archive for the ‘Uncategorized’ Category

Why herd immunity to COVID-19 is reached much earlier than thought


Climate Etc.

By Nic Lewis


A study published in March by the COVID-19 Response Team from Imperial College (Ferguson20[1]) appears to have been largely responsible for driving government actions in the UK and, to a fair extent, in the US and some other countries. Until that report came out, the strategy of the UK government, at least, seems to have been to rely on the build up of ‘herd immunity’ to slow the growth of the epidemic and eventually cause it to peter out.

View original post 3,027 more words

Why is change discovery important for open data?


Lost Boy

Change discovery is the process of identifying changes to a resource. For example, that a document has been updated. Or, in the case of a dataset, whether some part of the data has been amended, e.g. to add data, fill in missing values, or correct existing data. If we can identify that changes have been made to a dataset, then we can update our locally cached copies, re-run analyses or generate new, enriched versions of the original.

Any developer who is building more than a disposable prototype will be looking for information about the ongoing stability and change frequency of a dataset. Typical questions might be:

  • How often will a dataset get routinely updated and republished?
  • What types of data updates are anticipated? E.g. are only new records added, or might data be amended and removed?
  • How will the dataset, or parts of it be version controlled?
  • How will changes…

View original post 880 more words

Comments on COVID-19



I am, like you, restless and having trouble coping with the tragedy going on. It’s especially hard to think through the logical details of issues that only two weeks ago seemed urgently important. So instead, like you, I find myself with an internal dialogue of how the publicized statistics are consistently biased or wrong. At the risk of simply supporting your own internal thoughts, here are a few of mine:

  1. We still aren’t testing people, even in New York, which is the most tested population in the current mostly highly infected country according to the crap data we have.
  2. What that means to me is that we can ballpark how many actual cases we have if we know what the condition is for actually getting tested. In New York, it’s something close to “needs hospitalization.” Considering that only about the worst 10% of cases in countries that do widespread testing…

View original post 447 more words

Roanoke Island Series


via Roanoke Island Series

Virginia Dyslexia Advisors in Every District


Decoding Dyslexia VA

DDVA SB1516 Dyslexia Advisor 2019


Does your Virginia public school district have a Dyslexia Advisor?

Help us encourage every district to hire a Dyslexia Advisor during the month of October 2019 in celebration of October being Dyslexia Awareness Month!

Check the link to confirm for your district!

(Districts self report names and contact information for their dyslexia advisors. If a name is missing, it does not mean that they don’t have an advisor.  Use the tabs on the bottom of the spreadsheet to find your region and district.)

IF YES, send an email to them in October to say thanks for taking on this role in your district. Make a connection and see how you can help them support your student and their peers.

If NO, send an email to your school board representatives and ask them if they have hired a dyslexia advisor for your district. SB1516 went into effect on July…

View original post 35 more words

Introspection, Growth and Passion


via Introspection, Growth and Passion

Introspection, Growth and Passion



Having a moment of introspection this morning, thinking back over the years of how my work has changed – sometimes in pretty dramatic ways. It seems like forever ago that I was fresh out of school and working my first real programming job at a domain host. I worked hard until I was ultimately let go from the role due to some interpersonal issues. Fortunately, the market was good and I found a new role with a natural gas provider relatively quickly. I did a lot of growing there, not only in my skills but just in my understanding of how business gets done. It was while I was there that I got married and soon had to figure out how to juggle work and kids, finally getting it down about the time the second one came around.

All the while, I was still working on my passion – programming…

View original post 1,512 more words

Retrieve all table names of SQL Server DB with PHP on WAMP


via Retrieve all table names of SQL Server DB with PHP on WAMP

Retrieve all table names of SQL Server DB with PHP on WAMP



WAMP stands for Windows – Apache – MySQL – PHP but for me, today, I need to say WASP which is Windows – Apache – SQL Server – PHP. Yes its bit painful and for second day, working hard on finishing my part of our project for Microsoft Imagine Cup. Our server guy, Prabath M Peiris have done the backend in MS SQL Server and I needed to connect the DB with PHP as we could not find a free ASP host.


WAMP does not come with SQL Server connectivity drivers so we have to download it from and extract it in the “ext” folder of WAMP PHP. In my PC that is (C:wampbinphpphp5.4.3ext) then we need to add the extensions to PHP.ini file. I advise you to read the readme.html file comes with SQL Server drivers we have downloaded. Since I am using PHP 5.4, I used


View original post 472 more words

Output MySQL in JSON Format


Open Source DBA's Blog

I was recently asked if there is anyway to select non-JSON data from a MySQL database and output that data in JSON format. There are two very easy ways to to this.

JSON Array

If you need a JSON array, it is very easy to use the JSON_ARRAY() function. Simply select the columns you want as the argument to JSON_ARRAY()

SQL> select
json_array(continent,Population, Code)
from country
limit 5;
| json_array(continent,Population, Code) |
| ["North America", 103000, "ABW"] |
| ["Asia", 22720000, "AFG"] |
| ["Africa", 12878000, "AGO"] |
| ["North America", 8000, "AIA"] |
| ["Europe", 3401200, "ALB"] |
5 rows in set (0.0006 sec)


However to get a JSON object you need to do a little more work. JSON objects require pairs – key/value pairs — so you need to pass a key, even a fictitious one for each value you desire. In the example…

View original post 105 more words