Simon Willison simonw

Details of the DigitalOcean App Platform Python environment

I created an app on the DigitalOcean App Platform with a requirements.txt and a Procfile - causing it to detect a Python application and build the app with their Python buildpack.

Here are some details of the resulting environment, from running commands using the DigitalOcean web terminal.

$ uname -a
Linux digital-ocean-app-9c6bd5794-kt9h8 4.4.0 #1 SMP Sun Jan 10 15:06:54 PST 2016 x86_64 x86_64 x86_64 GNU/Linux

$ cat /etc/issue

Publishing a private Datasette instance to Heroku using datasette-auth-passwords

Using this new plugin: https://github.com/simonw/datasette-auth-passwords

Create your database as usual, then create a metadata.json file that looks like this:

{
    "allow": {
        "id": "root"
 }

Machine learning models installed on macOS is part of Vision.framework

I found these while poking around at the list of open files for photoanalysisd in Activity Monitor.

% ls -lahS /System/Library/Frameworks/Vision.framework/Versions/A/Resources
total 465616
-rw-r--r--    1 root  wheel    40M Dec 13 16:32 landmarks_v2.bin
-rw-r--r--    1 root  wheel    31M Dec 13 16:32 scenenet_sc2.4_sa1.4_ae1.4_r9_opt_int8.espresso.weights
-rw-r--r--    1 root  wheel    29M Dec 13 16:32 scenenet_sc2.4_sa1.4_ae1.6_r13.4_opt_int8_asymetric.espresso.weights

	# Fetch latest configuration:
	/5 * * * cd /home/ubuntu/dogsheep-config && python3 git_pull_and_run_scripts.py . && sudo python3 ensure_symlinks.py files-to-symlink

	# Goodreads
	46 * * * * cd /home/ubuntu && /home/ubuntu/datasette-venv/bin/goodreads-to-sqlite books goodreads.db -a auth.json

	# Twitter
	1,11,21,31,41,51 * * * * /home/ubuntu/datasette-venv/bin/twitter-to-sqlite user-timeline /home/ubuntu/twitter.db -a /home/ubuntu/auth.json --since
	2,7,12,17,22,27,32,37,42,47,52,57 * * * * run-one /home/ubuntu/datasette-venv/bin/twitter-to-sqlite home-timeline /home/ubuntu/timeline.db -a /home/ubuntu/auth.json --since
	4,14,24,34,44,54 * * * * run-one /home/ubuntu/datasette-venv/bin/twitter-to-sqlite mentions-timeline /home/ubuntu/twitter.db -a /home/ubuntu/auth.json --since

	sqlite-utils insert /tmp/loans.db foia_150k_plus --csv '150k plus/foia_150k_plus.csv'
	sqlite-utils insert /tmp/loans.db foia_up_to_150k_AL --csv 'Alabama/foia_up_to_150k_AL.csv'
	sqlite-utils insert /tmp/loans.db foia_up_to_150k_AK --csv 'Alaska/foia_up_to_150k_AK.csv'
	sqlite-utils insert /tmp/loans.db foia_up_to_150k_AS --csv 'American Samoa/foia_up_to_150k_AS.csv'
	sqlite-utils insert /tmp/loans.db foia_up_to_150k_AZ --csv 'Arizona/foia_up_to_150k_AZ.csv'
	sqlite-utils insert /tmp/loans.db foia_up_to_150k_AR --csv 'Arkansas/foia_up_to_150k_AR.csv'
	sqlite-utils insert /tmp/loans.db foia_up_to_150k_CA --csv 'California/foia_up_to_150k_CA.csv'
	sqlite-utils insert /tmp/loans.db foia_up_to_150k_CO --csv 'Colorado/foia_up_to_150k_CO.csv'
	sqlite-utils insert /tmp/loans.db foia_up_to_150k_CT --csv 'Connecticut/foia_up_to_150k_CT.csv'
	sqlite-utils insert /tmp/loans.db foia_up_to_150k_DE --csv 'Delaware/foia_up_to_150k_DE.csv'