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.