Every story and comment from the Hacker News API, in a layout borrowed from 2001.
A comment on Hosting SQLite databases on GitHub Pages or any static file hoster. Parent comment
But this approach lets you actually work out what the optimal size is:
select sum(length(country_code) + length(long_name)) from wdi_country;
Or on average:
select sum(length(country_code) + length(long_name))/count(*) from wdi_country;
(Note that it doesn't seem possible to use aggregation functions with a limit clause)
There are no comments on this comment yet.
But this approach lets you actually work out what the optimal size is:
gives: 6307Or on average:
gives: 23(Note that it doesn't seem possible to use aggregation functions with a limit clause)