• Open Food Facts

    From shinobi@21:1/153 to All on Wednesday, May 16, 2018 19:08:22
    Hello All,

    I recently found an interesting database. It's called Open Food Facts. It's located at https://world.openfoodfacts.org.

    So far I imported the database into my Mongo DB instance. And exported to csv some of the data (name, nutrition facts). And then imported into sqlite database. The question is. Would be anyone interested in the sqlite database
    I prepared? So far I created a simple page that queries the sqlite database. It's not really something special. But it could serve to query the basic nutrition facts regarding food.

    I didn't yet find any better way to query by code than use mobile bar code scanner and then copy it into the web-page form. And there is still plenty
    work on it. I'm quite glad about this kind of open data.

    Best regards

    Shinobi

    --- Mystic BBS v1.12 A38 2018/01/01 (Linux/64)
    * Origin: INFOLINKA BBS (21:1/153)
  • From dream master@21:1/163 to shinobi on Wednesday, May 16, 2018 13:38:18
    On 05/16/18, shinobi said the following...
    Hello All,
    I recently found an interesting database. It's called Open Food Facts. It's located at https://world.openfoodfacts.org.
    So far I imported the database into my Mongo DB instance. And exported
    to csv some of the data (name, nutrition facts). And then imported into sqlite database. The question is. Would be anyone interested in the

    what does this have to do with mystic bbs?

    |08 .|05ú|13ù|15Dr|07e|08am Ma|07st|15er|13ù|05ú|08.
    |08 øù|05ú|13ùø |13øù|05ú|08ùø
    |11 DoRE|03!|11ACiDiC|03!|11Demonic |08[|15dreamland|09.|15darktech|09.|15org|08]

    --- Mystic BBS v1.12 A39 2018/04/21 (Windows/64)
    * Origin: |08--[|15!|07dreamland BBS dreamland.darktech.org (21:1/163)
  • From shinobi@21:1/153 to dream master on Thursday, May 17, 2018 04:31:16
    what does this have to do with mystic bbs?

    Sorry, wrong forum. Had to be posted to the General. My fault. However I
    think about preparing BBS module to enable searching for food nutritions from Mystic. That's kind of trouble because I guess I'd be in flames by hatching
    70 MB file of food facts.

    Best regards

    Shinobi

    --- Mystic BBS v1.12 A38 2018/01/01 (Linux/64)
    * Origin: INFOLINKA BBS (21:1/153)
  • From Al@21:4/106 to shinobi on Thursday, May 17, 2018 00:27:57
    Re: Re: Open Food Facts
    By: shinobi to dream master on Thu May 17 2018 04:31 am

    Sorry, wrong forum. Had to be posted to the General. My fault. However I think about preparing BBS module to enable searching for food nutritions from Mystic. That's kind of trouble because I guess I'd be in flames by hatching 70 MB file of food facts.

    I don't think 70 MB is very big today. Back in the dial-up days it was, but not so much today.

    It does sound intereting though, my lady friend might just look something like that up. I might too.. if I had time.. :)

    Ttyl :-),
    Al


    ... Software means never having to say you're finished.
    --- SBBSecho 3.04-Linux
    * Origin: The Rusty MailBox - Penticton, BC Canada (21:4/106)
  • From shinobi@21:1/153 to Al on Thursday, May 17, 2018 08:18:32
    I don't think 70 MB is very big today. Back in the dial-up days it was, but not so much today.

    Well... what I explored. It's not that bad. Zipped file has 12MB. So far I'll be thinking about creating a simple app for Mystic. It could attract some
    women to the BBSing. Maybe. :-)

    It does sound intereting though, my lady friend might just look
    something like that up. I might too.. if I had time.. :)

    Well... it's just I'm thinking about application where on would log his food intake during the day. And it could be summed up then for a day, week, etc.
    :-) Kind of fitness app for BBS.

    Best regards

    Shinobi

    --- Mystic BBS v1.12 A38 2018/01/01 (Linux/64)
    * Origin: INFOLINKA BBS (21:1/153)
  • From dream master@21:1/163 to shinobi on Thursday, May 17, 2018 02:00:10
    On 05/17/18, shinobi said the following...
    what does this have to do with mystic bbs?
    Sorry, wrong forum. Had to be posted to the General. My fault. However I think about preparing BBS module to enable searching for food nutritions from Mystic. That's kind of trouble because I guess I'd be in flames by hatching 70 MB file of food facts.

    and making people hungry lol

    |08 .|05ú|13ù|15Dr|07e|08am Ma|07st|15er|13ù|05ú|08.
    |08 øù|05ú|13ùø |13øù|05ú|08ùø
    |11 DoRE|03!|11ACiDiC|03!|11Demonic |08[|15dreamland|09.|15darktech|09.|15org|08]

    --- Mystic BBS v1.12 A39 2018/04/21 (Windows/64)
    * Origin: |08--[|15!|07dreamland BBS dreamland.darktech.org (21:1/163)
  • From shinobi@21:1/153 to dream master on Thursday, May 17, 2018 19:03:58
    Sorry, wrong forum. Had to be posted to the General. My fault. Howeve think about preparing BBS module to enable searching for food nutriti from Mystic. That's kind of trouble because I guess I'd be in flames hatching 70 MB file of food facts.

    So far I found out... that my import was totally wrong. So far there is mess
    in the columns. That basically means there is like 50 metrics. And from my
    own experience several is enough.ã

    --- Mystic BBS v1.12 A38 2018/01/01 (Linux/64)
    * Origin: INFOLINKA BBS (21:1/153)
  • From shinobi@21:1/153 to Al on Thursday, May 17, 2018 20:44:28
    It does sound intereting though, my lady friend might just look
    something like that up. I might too.. if I had time.. :)

    So far this is how does it look like now:

    https://postimg.cc/image/4gd7lomw7/
    https://postimg.cc/image/uyvuulo8n/
    https://postimg.cc/image/ilj0nrbfr/

    Weekend is closer. Every Day

    --- Mystic BBS v1.12 A38 2018/01/01 (Linux/64)
    * Origin: INFOLINKA BBS (21:1/153)
  • From dream master@21:1/163 to shinobi on Friday, May 18, 2018 00:39:42
    On 05/17/18, shinobi said the following...
    So far I found out... that my import was totally wrong. So far there is mess in the columns. That basically means there is like 50 metrics. And from my own experience several is enough.ã

    replied to the wrong person ;p

    |08 .|05ú|13ù|15Dr|07e|08am Ma|07st|15er|13ù|05ú|08.
    |08 øù|05ú|13ùø |13øù|05ú|08ùø
    |11 DoRE|03!|11ACiDiC|03!|11Demonic |08[|15dreamland|09.|15darktech|09.|15org|08]

    --- Mystic BBS v1.12 A39 2018/04/21 (Windows/64)
    * Origin: |08--[|15!|07dreamland BBS dreamland.darktech.org (21:1/163)