prof18 / RSS-Parser

A Kotlin Multiplatform library to parse a RSS Feed
Apache License 2.0
490 stars 126 forks source link

XML too big for SQLite #105

Closed skeie closed 1 year ago

skeie commented 1 year ago

Describe the bug

Seems like I found big RSS feed, bc its too big for SQLite it looks when caching is enabled, any idea on how to solve this without turning of the cache? It would be great if the library could handle it itself, if cache fails, it will try to parse the RSS feed instead of failing.

But you have more context than I have, what do you think?


E/SQLiteQuery: exception: Row too big to fit into CursorWindow requiredPos=0, totalRows=1; query: SELECT * FROM feeds 
            WHERE url_hash = ?
            AND charset = ?

android.database.sqlite.SQLiteBlobTooBigException: Row too big to fit into CursorWindow requiredPos=0, totalRows=1

The link of the RSS Feed https://mindpump.libsyn.com/rss

prof18 commented 1 year ago

Indeed, the caching should be done at "best effort" and the exception should be handled internally. I will look into this!

skeie commented 1 year ago

Amazing, thank you!