979
edits
Changes
Jump to navigation
Jump to search
Line 242:
Line 242: − + Line 248:
Line 248: − Line 273:
Line 272: + + + +
→CSV export via SQL (beta): + tips
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.
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: http://mirabelle.openfoodfacts.org/
The tool, called ''Mirabelle'', can be found here: http://mirabelle.openfoodfacts.org/
The whole CSV export can be found here: http://mirabelle.openfoodfacts.org/products/all
The whole CSV export can be found here: http://mirabelle.openfoodfacts.org/products/all
* The tool supports simple queries with a form, and also facet navigation.
* The tool supports simple queries with a form, and also facet navigation.
* For those who know SQL language, it allows rich and complex queries.
* 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]?
What's different with [https://world.openfoodfacts.org/cgi/search.pl Open Food Facts advanced search]?
Maybe you have to wait several seconds. It will download a product.csv file.
Maybe you have to wait several seconds. It will download a product.csv file.
==== Tips ====
* Several fields -- such as <code>countries_en</code>, <code>categories_en</code>, etc. -- contain multiple values. To query a particular value you have to use the operator <code>like</code> and use percents like this: <code>like %italy%</code>.