Show HN: One Billion Checkboxes

by andersmurphy on 5/13/2025, 9:32:55 AM with 15 comments

  • by blancotech on 5/13/2025, 1:15:08 PM

    [x] did it just for fun

    [x] instantly usable

    [x] no sales pitch

    These are the posts that keep us on HN

  • by trizoza on 5/13/2025, 9:40:27 AM

    Great implementation! I played it on mobile and I scrolled so far and deep that (hopefully) no one will ever overwrite my pixels! Muhahaaaa

  • by devnull3 on 5/13/2025, 4:15:38 PM

    If I have to guess the tuning and optimizations:

    SQLITE:

    1. Smaller page size (to be specific: max(disk_sector_size, 512))

    2. Integer primary keys

    3. WAL mode

    4. Increase page cache size. This is assuming that most people will click in the top-left 100x100 checkboxes.

    Other optimzation:

    1. In mem cache of bitmap of 1B bits, which is about 120MB, which is a shared state for all incoming connections.

  • by nz3000 on 5/13/2025, 1:42:40 PM

    Those are some really nice looking checkboxes!

  • by andriusbartulis on 5/13/2025, 9:45:20 AM

    Awesome demo! I want a minimap though.