Changes

Jump to navigation Jump to search
+ mirabelle: csv export via SQL
Line 232: Line 232:     
</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.

Navigation menu