TIL Explore fossil SQLite database with Datasette

Since Fossil is backed by an SQLite database, we can use tools like Datasette to explore and interact with the fossil data.

  • Input: SELECT user,comment FROM event
  • Output: A CSV of users and commit messages
brie,initial empty check-in
brie,๐Ÿฆ– Initial commit -- rawr
brie,๐Ÿงช Let us make some changes
brie,๐ŸŒˆ Add README
brie,๐ŸŒˆ Add test database
brie,๐Ÿ˜ป Add picture of Plop

How I did it

Use datasette serve ./whatever.fossil in order to get a Datasette instance. This instance provides an alternate way to explore the data that is available to fossil.

In the Datasette Web UI, click the name of the database and then you can enter queries in Custom SQL query.

โ„น๏ธ About this TIL snippet: Created 2023-03-11T18:00:37-05:00 · View the source