Changes

Jump to navigation Jump to search
Line 242: Line 242:  
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
Line 248: Line 248:  
* 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]?
Line 273: Line 272:     
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>.

Navigation menu