Deploy a demo

[simonw]

I can derive it from my Firefox favicons database.

[simonw]

I started with my favicons database:

cp ~/Library/Application\ Support/Firefox/Profiles/.../favicons.sqlite favicons.db

I created a new table to re-order the table columns (I wanted the data column first, not last):

$ sqlite3 favicons.db
sqlite> create table favicons as select id, data, icon_url, fixed_icon_url_hash, width, root, color, expire_ms from moz_icons;

Then I deleted most of the rows:

sqlite> delete from favicons where id > 100;

And the other tables:

sqlite> drop table moz_icons;
sqlite> drop table moz_icons_to_pages;
sqlite> drop table moz_pages_w_icons;
sqlite> drop table sqlite_stat1;

Finally I ran vacuum to clean up the deleted tables:

sqlite> VACUUM;

Then I deployed the demo like so:

datasette publish now favicons.db \
  --branch=master \
  --install datasette-render-images \
  -n datasette-render-images-demo \
  --source=datasette-render-images \
  --source_url=https://github.com/simonw/datasette-render-images \
  --title="datasette-render-images demo"

[simonw]

Deployed demo: https://datasette-render-images-demo.datasette.io/favicons-6a27915/favicons