Difference between revisions of "Mirabelle"

From Open Food Facts wiki
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.:

  1. The classic REGEXP extension for SQLite allows to select products which are matching an expression.
  2. The second one, from sqlean, might be a bit slower allows more features: it can extract string. Check its documentation.