Changes

Jump to navigation Jump to search
→‎CSV daily export: adding about importing CSV to SQLite
Line 47: Line 47:  
</code>
 
</code>
   −
==== Import CSV in PostGRE SQL ====
+
==== Import CSV in PostgreSQL ====
 
See this article: https://blog-postgresql.verite.pro/2018/12/21/import-openfoodfacts.html (in french, but should be understandable with Google Translator).
 
See this article: https://blog-postgresql.verite.pro/2018/12/21/import-openfoodfacts.html (in french, but should be understandable with Google Translator).
 +
 +
==== Import CSV to SQLite ====
 +
 +
The repository [https://github.com/fairdirect/foodrescue-content foodrescue-content] contains Ruby scripts that import Open Food Facts CSV data into a [https://www.sqlite.org/index.html SQLite] database with full table normalization. Only a few fields are imported so far, but this an be extended easily. Data imported so far includes:
 +
 +
* barcode number
 +
* product name
 +
* product categories
 +
* product countries
 +
* full categories hierarchy imported from the <code>categories.txt</code> taxonomy ([https://github.com/openfoodfacts/openfoodfacts-server/tree/master/taxonomies see])
    
==== Python ====
 
==== Python ====
25

edits

Navigation menu