Food

57 readers

2 users here now

founded 6 months ago

MODERATORS

tfm

OpenFoodFacts raw DB access; app issues (slrpnk.net)

submitted 1 week ago by activistPnk@slrpnk.net to c/Food

1 comments fedilink hide all child comments

cross-posted from: https://slrpnk.net/post/27899239

I installed the app on AOS 5 in 2022. It shows the title screen then crashes. So I never used it. I recently had another look. They now impose AOS 6 or newer. So I went to Izzy’s archive and found the latest AOS 5 version (1405). Wow how fat we’ve gotten.. The APK (which is compressed) went from 12mb to 86mb. It gave some error when trying to side-load.

possible workaround

So I guess the app can’t serve me. And there is no desktop app AFAICT. I was glad to find the DB (mondoDB-based) is freely available. That beast is ~13gb compressed. Before I work on freeing up space, can anyone say whether it is practical to make direct SQL queries on it? Is it straight forward to port it to SQLite, or worthwhile to learn this new mondo DB platform?

top 1 comments

sorted by: hot top controversial new old

[–] tfm 1 points 1 week ago

MongoDB is a NoSQL database engine. So no, afaik you cannot do direct SQL queries on it. You'd need to migrate it to SQLite first.

Depending on your use case I'd probably simply continue using MongoDB for this dataset and reference it from your SQLite database. That way you can skip the migration progress every time you update the dataset. However, this could create a technical overhead and can get messy pretty quickly.

Have you considered using their API?