Hacker News Reader

lungureanuon Ask HN: What Are You Working On? (June 2025)

I'm working at BundleJoy: a Shopify app for creating boxes (bundles) with a better CX and some nice features (quantity rules, packaging options, collect customer input, etc).

AppStore: https://apps.shopify.com/bundlejoy

lungureanuon Anko SQLite, a library to simplify working with SQLite on Android

I find it difficult to get full offline-mode + sync working correctly. Don't know if you have duplicates in the remote db but I think your approach has a problem: the app send the data (from scratchpad table) to server, the server saves it in DB but the connection drops on device (ex bad connection, user turn off WIFI/3G while syncing) so the app will never get a 200 response. In this case your new data was saved on server but it remains on scratchpad table. On next sync the data will be uploaded as being new: this will cause duplicates.