Difference between revisions of "Mirabelle"
Jump to navigation
Jump to search
(First version (to be continued)) |
(+ category:quality) |
||
Line 32: | Line 32: | ||
# The classic REGEXP extension for SQLite allows to select products which are matching an expression. | # The classic REGEXP extension for SQLite allows to select products which are matching an expression. | ||
# The second one, from [https://github.com/nalgeon/sqlean sqlean], might be a bit slower allows more features: it can extract string. Check [https://github.com/nalgeon/sqlean/blob/main/docs/regexp.md its documentation]. | # The second one, from [https://github.com/nalgeon/sqlean sqlean], might be a bit slower allows more features: it can extract string. Check [https://github.com/nalgeon/sqlean/blob/main/docs/regexp.md its documentation]. | ||
+ | [[Category:Quality]] |
Latest revision as of 15:51, 21 August 2023
Mirabelle is a tool to manipulate the data either with forms and facets, either with the SQL language: https://mirabelle.openfoodfacts.org
The data in Mirabelle is based on the last daily CSV export (it does not contain all the fields of the database, but still contains more than 130).
Mirabelle is a kind of playground. It's just a more convenient way to manipulate the data. Please don't base your own apps on it, as it is not meant to have the same level of availability as the Open Food Facts regular website.
All the database published with Mirabelle are read-only.
Features
- By default, every view has its own URL: you can easily share your requests or views.
- Facet navigation (close to Open Food Facts).
- Advanced filtering system.
- Thanks to the SQL language, very rich queries are possible.
- REGEXP are possible in queries (see below).
- CSV or JSON exports. It's easy to create exports by countries.
- Allow copy and paste from Mirabelle to dozens of other tools (Mediawiki, Github, TSV, etc.).
- Charts (see the
Show charting options
button).
Databases
- products: all the data from Open Food Facts (imported from today's CSV).
- previous: all the data from yesterday's CSV.
- [to be completed]
Documentation
REGEXPs
Regexps are possible thanks to two extensions.:
- The classic REGEXP extension for SQLite allows to select products which are matching an expression.
- The second one, from sqlean, might be a bit slower allows more features: it can extract string. Check its documentation.