simonw

How to run Python 3.7 on Ubuntu 16.04

This is based on Method 2 in https://websiteforstudents.com/installing-the-latest-python-3-7-on-ubuntu-16-04-18-04/

First, you need to install Python 3.7 (you will currently have Python 3.5.2):

sudo apt update
sudo apt install software-properties-common
sudo add-apt-repository ppa:deadsnakes/ppa

sudo apt update

simonw

Making a Datasette of Finnish coronavirus data

From here: https://github.com/HS-Datadesk/koronavirus-avoindata

Tools

You'll need jq, sqlite-utils and Datasette.

• jq installation instructions: https://stedolan.github.io/jq/download/
• pip install sqlite-utils datasette

simonw

simonw

datasette
sqlite-utils
sqlite-transform
csvs-to-sqlite
geojson-to-sqlite
socrata2sql
datasette-cluster-map
datasette-vega
datasette-json-html
datasette-jellyfish

simonw

# This file lives in /etc/systemd/system/datasette.service
[Unit]
Description=Datasette
After=network.target

[Service]
Type=simple
User=ubuntu
Environment=GITHUB_CLIENT_ID=...
Environment=GITHUB_CLIENT_SECRET=...

simonw

{
    "title": "This is the title"
}

simonw

    async def data(
        self,
        request,
        database, # Name of the database
        hash,     # Hash component of the database URL (usually ignored)
        table,    # Name of the table
        default_labels=False, # HTML views default to expanding all foreign key labels
        _next=None,
        _size=None,

simonw

simonw

class Safe extends String {}

function safe(s) {
  if (!(s instanceof Safe)) {
    return new Safe(s);
  } else {
    return s;
  }
}

simonw

with recursive thread as (
    select id, in_reply_to_status_id, 0 as depth
        from tweets
        where in_reply_to_status_id is null
    union
        select tweets.id, tweets.in_reply_to_status_id, 1 + thread.depth as depth
        from thread join tweets on tweets.in_reply_to_status_id = thread.id)
select * from thread order by depth desc