Urgent.News

What's breaking now, across thousands of outlets.

More in Tech

Loading a 72 MB JSON list on a TV box without running out of memory

I make a media player for Android TV boxes, phones and Windows. People sign in with the playlist their provider gives them, and the app downloads three lists from the provider's server: live channels…

  • JSON list of 72 MB downloaded and parsed on Android TV box causes memory issues
  • Stream JSON list instead of downloading as whole to prevent memory crashes
  • Save rows in fixed blocks with single prepared INSERT statement for better memory management

More from Saturday 14 November →