126: The Web Kind of Happens to You

Database Management

Database management within applications often presents challenges, particularly when it comes to threading and caching. Marco Arment explains how moving database operations to the main thread simplifies processes and reduces potential deadlocks, despite initial concerns about UI performance 1. He shares, "Once you move things to the main thread, all the database stuff, then oh my God, it becomes so much simpler" 1. John Siracusa and Marco discuss the use of SQLite pragmas to optimize performance, with Marco noting his use of synchronous off and journal mode memory to mitigate risks 2.

   

Download Issues

Managing downloads in app development can be fraught with issues, particularly with storage and temp files. Marco highlights the problem of growing storage usage due to temp files created by the background download system in iOS, which are not deleted if a download is interrupted 3. He states, "The background download system is just incredibly unreliable for me" 3. John Siracusa and Marco also discuss the challenges of on-demand downloading APIs, which often lack the necessary hooks for a seamless user experience, especially in gaming contexts 4.