Italki teachers

Scrape all italki teachers for Chinese and start a datasette instance for searching.

Dependencies

$ pip install -r requirements.txt

Make sure you have jq installed:

$ brew install jq

Create the database

$ cat pages/* | jq '.data[] | (.teacher_info + .user_info)' | jq -s | sqlite-utils insert db.sqlite teachers -

Enable full text search

$ sqlite-utils enable-fts db.sqlite teachers intro nickname

Start server

$ datasette db.sqlite

Link to SQL query for searching

Click here

A few impressive teachers

• Liang, very fluent english