Reusing Open Food Facts Data: Difference between revisions

Reusing Open Food Facts Data (view source)

898 bytes added , 28 September 2022

+ mirabelle: csv export via SQL

951

edits

@@ Line 232: / Line 232: @@
 </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.