https://calmcode.io/datasette/introduction.html is a nice introduction to https://datasette.io/

select name, thing from person, thing, person_thing pt where person.id = pt.person_id and thing.id = pt.thing_id;

For this example, there are three text CSV files to start with:

person.csv
id,name
1,Matt
2,Tracey
3,Pascal
4,Poppy

thing.csv
id,thing
1,computers
2,knitting
3,dogging

person_thing.csv
id,person_id,thing_id
1,1,1
2,2,2
3,3,3
4,4,3

Put these in a SQLite database like so:

  1. csvs-to-sqlite person.csv thing.csv person_thing.csv eg.db
  2. datasette eg.db
Tags:

Published