News for hackers. Stuff that matters.
Re:Hosting SQLite databases on GitHub Pages or any static fi... by nl on Sunday May 02, 2021 @07:55PM (#27020190)
This might be true.

But this approach lets you actually work out what the optimal size is:

  select sum(length(country_code) + length(long_name)) from wdi_country;
gives: 6307

Or on average:

  select sum(length(country_code) + length(long_name))/count(*) from wdi_country;
gives: 23

(Note that it doesn't seem possible to use aggregation functions with a limit clause)

There are no comments on this comment yet.