simonw

{
  "install": "pip3 install --user -r requirements.txt",
  "start": "PYTHONUNBUFFERED=true python3 server.py",
  "watch": {
    "ignore": [
      "\\.pyc$"
    ],
    "install": {
      "include": [
        "^requirements\\.txt$"

simonw

import contextlib
import threading
import sqlite3


class Connection:
    def __init__(self, name, db_conn):
        self.name = name
        self.db_conn = db_conn
        self.available = True

simonw

# Use it like this:
#
# structlog.configure(
#     processors=[
#         structlog.processors.JSONRenderer(),
#         LogToSqlite("/tmp/logs.db")
#     ]
# )
# log = structlog.get_logger()
# log.msg("say-hello", whom="world", num=[random.randint(1,55)])

simonw

from datasette_auth_github import GitHubAuth
from starlette.applications import Starlette
from starlette.responses import HTMLResponse
import uvicorn

app = Starlette(debug=True)


@app.route("/")
async def homepage(request):

simonw

#!/usr/local/bin/jq -rf
tostream
| select(length > 1)
| (
  .[0] | map(
    if type == "number"
    then "[" + tostring + "]"
    else "." + .
    end
  ) | join("")

simonw

Installing MySQLdb mysqlclient with Homebrew and pip in OS X Mojave

First I used Homebrew to install the MySQL server along with mysql_config, needed to compile the Python extension:

brew install mysql

I had to then use this incantation to get pip install mysqlclient to work:

LIBRARY_PATH=$LIBRARY_PATH:/usr/local/opt/openssl/lib/ pip install mysqlclient

simonw

<?xml version="1.0" encoding="utf-8"?>
<kml xmlns="http://www.opengis.net/kml/2.2">
  <Document>
    <Placemark>
      <TimeStamp>
        <when>2015-12-18T19:12:32</when>
      </TimeStamp>
      <name>2015-12-18 19:12:32 Source: WhatsApp</name>
      <Point>
        <coordinates>-0.120970480144024,51.510383605957</coordinates>

simonw

simonw

# For a sample Starlette app
from starlette.applications import Starlette
from starlette.responses import JSONResponse
import sys
import sqlite3

application = Starlette()


@application.route("/")

simonw