search

USDA / USDA-APIs

Do you have feedback, ideas, or questions for USDA APIs? Use this repository's Issue Tracker to join the discussion.
www.usda.gov/developer
109 stars 16 forks source link

Provide Food Composition Databases as SQLITE downloads in the new FoodData Central #63

Open zeluspudding opened 5 years ago

zeluspudding commented 5 years ago

Hi there. I noticed that the current download format of the soon to be migrated nutrition composition databases at https://ndb.nal.usda.gov/ndb/search/list?home=true are available only as Microsoft Access or ASCII (CSV) files.

CSV is certainly a workable solution for anyone who can't get Access working (me) but may I suggest that future downloads at FoodData Central be available in non-proprietary database formats - perhaps as an sqlite file? SQLite has the advantage of being totally free to use and easy to setup compared to MS Access. Thanks in advance

littlebunch commented 5 years ago

I’ve advocated for a JSON rendition of the data as it would provide people with better flexibility for loading into a datastore whether RDBMS, NoSQL or whatever.

On Mar 8, 2019, at 1:10 PM, Andrew Agostini notifications@github.com wrote:

Hi there. I noticed that the current download format of the soon to be migrated nutrition composition databases at https://ndb.nal.usda.gov/ndb/search/list?home=true https://ndb.nal.usda.gov/ndb/search/list?home=true are available only as Microsoft Access or ASCII (CSV) files.

CSV is certainly a workable solution for anyone who can't get Access working (me) but may I suggest that future downloads at FoodData Central be available in non-proprietary database formats - perhaps as an sqlite file? SQLite has the advantage of being totally free to use and easy to setup compared to MS Access. Thanks in advance

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/USDA/USDA-APIs/issues/63, or mute the thread https://github.com/notifications/unsubscribe-auth/ABHe9epsk7Yp4u18cciD18QrjHxViLMyks5vUqehgaJpZM4bl3Dr.