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 ====