england

I use SQLite for sharing structured open data - it's a better alternative to zipped csv datasets, for example. See the football.db [1] as some example SQLite datasets e.g. the English Premier League in england.db and so on. [1]: https://github.com/openfootball/england/releases PS: The big elephant for SQLite data packages is Simon Willison's Datasette [2]. [2]: https://datasette.io

The football data looks easy for a human to read but a pain in the arse for a program to consume. Personally I think it's terrible, and the fact that they have had to develop a custom 'sportsdb' tool to manage it rather than using something generic like 'jq' is telling. https://github.com/openfootball/england/blob/master/2019-20/... To properly parse this file you need to write a parser that cut fixed-width fields (wait, are the team names padded to fixed-width or is the '-', which doubles as part of the result, a delimiter?), trim strings, knows that "Aug/24" is August 24th, deals with wrapping of the months over the two years, is sensitive to indentation, and understands that "Matchday [0-9]+" and the [] bracketed dates are section delimiters. And what about that first line beginning with '=', comments? Where is the formal grammar for t