Browsed by
Tag: IOException

Android & SQLite – 1MB limit, IOException and general woes.

Android & SQLite – 1MB limit, IOException and general woes.

This long weekend I worked on an app: Scrabble For Anagrams. The UI took about 8 hours. The engine to generate and perform rapid lookups of character permutations took about 8 hours. After 2 days of hard work I believed the app was working great and was nearly ready to go on the market. The dictionary was converted into a SQLite DB outside of the android application and was included as an asset.

However, my original dictionary (found online) contained only 10K words and I pretty rapidly found some word combinations that were valid but weren’t in the dictionary – clearly unacceptable. No problem! I found a freely available 400K word dictionary, generated the new DB and placed it in the asset folder. Build, run and bam! IOException.

Dump, Split and Rebuild the DB