984
edits
Changes
Jump to navigation
Jump to search
Line 232:
Line 232: + + + + + + + + + + + + + + + + + +
Reusing Open Food Facts Data (view source)
Revision as of 20:56, 28 September 2022
, 20:56, 28 September 2022+ mirabelle: csv export via SQL
</pre>
</pre>
=== CSV export via SQL (alpha) ===
We are testing a new kind of tool to provide the data: every day an SQL database is fed by the regular daily CSV export, and published online thanks to Datasette tool.
The tool, called Mirabelle, can be found here: https://mirabelle.openfoodfacts.org/
The whole CSV export can be found here: https://mirabelle.openfoodfacts.org/all
* The tool supports simple queries with a form, and also facet navigation.
* For those who know SQL language, it allows rich and complex queries.
What's different with [https://world.openfoodfacts.org/cgi/search.pl Open Food Facts advanced search]?
* It's possible to export selections with more than 10,000 products (eg. big queries by countries).
* It's possible to build queries by date.
* It allows richer queries with OR, AND, NOT, REGEXP, etc.
* It is possible to restrict the number of fields displayed and exported.