This project takes Fineli, the Finnish Food Composition Database, and converts it into SQL format.
Currently it creates a sqlite3 database and a sql dump that can be imported into PostgreSQL.
Sample queries are included in queries.sql.
Included database version:
- Fineli Release 18.0
- Fineli Release 16.0
Much work could be put into processing the data and turning this into a more proper relational database structure with naming conventions that make more sense. Contributions to improve the database format are welcome.