<h1 id="2022-11-04">2022-11-04<a aria-hidden="true" class="anchor-heading icon-link" href="#2022-11-04"></a></h1>
<h1 id="this-is-maëlles-dbgi-daily-open-notebook">This is Maëlle's DBGI daily open-notebook.<a aria-hidden="true" class="anchor-heading icon-link" href="#this-is-maëlles-dbgi-daily-open-notebook"></a></h1>
<p>Today is 2022.11.04</p>
<h3 id="todo-change-update_dbpy-to-compare-tables">TODO: change 'update_db.py' to compare tables<a aria-hidden="true" class="anchor-heading icon-link" href="#todo-change-update_dbpy-to-compare-tables"></a></h3>
<p>Possible ways:</p>
<ul>
<li>Truncate
<ul>
<li>Problem => Foreign key constraint</li>
</ul>
</li>
<li>OUTER JOIN + Update Set
<ul>
<li>Problem => have to specify each column</li>
</ul>
</li>
</ul>
<p>⚠️ If some changes are made through directus => Will be rechanged with inat value in the next update</p>

This is Maëlle's DBGI daily open-notebook.

TODO: change 'update_db.py' to compare tables

2022-11-04


# Overview

The Digital Botanical Gardens Initiative (DBGI, www.dbgi.org) ambitions to explore innovative solutions for the collection, management and sharing of digital information acquired on living botanical collections. A particular focus will be placed on the large scale characterization of the chemodiversity of living plants collections through mass spectrometric approaches. The acquired data will be structured, organized and connected with relevant metadata through [semantic web](https://en.wikipedia.org/wiki/Semantic_Web) technology. The gathered knowledge will then inform ecosystem functioning research and orient [biodiversity conservation](https://en.wikipedia.org/wiki/Conservation_biology) projects. The DBGI initially aims to take advantage of the readily available living collections of Swiss botanical gardens to establish robust and scalable biodiversity digitisation workflows. The ultimate goal is to apply these approaches in the field and at the global scale in wildlife ecosystems. 

# Main goals

The DBGI main goals are briefly summarized below :

![](/assets/images/2022-06-18-17-13-23.png){max-width: 400px, display: block, margin: 0 auto}

# An Open Science project


## Working with the workshop doors open

![](/assets/images/2022-06-18-17-47-56.png){max-width: 400px}

A way of working briefly described by Andy Matuschak here https://notes.andymatuschak.org/z21cgR9K3UcQ5a7yPsj2RUim3oM2TzdBByZu. 


## Open Notebook Science

If we apply this "working with the workshop doors open" idea to a scientific research endeavor we understand it as respecting the core concepts of Open Science. These is more precisely the principle of Open Notebook Science https://en.wikipedia.org/wiki/Open-notebook_science

For the projects of the DBGI we will follow such an Open Notebook Science approach in order to share early ideas and results but also the less shiny parts of the research projects. 

You can follow the DBGI related Open Notebooks here [[open-notebook]].

Expect to find strange ideas, badly formulated text and poorly written code. However if you have time and interest you should be able to participate at each step of the process. Hopefully this will lead to enhanced collaboration and participation. Maybe yes, maybe not. Let's make it a methodological experiment !

Each pages of this website are written in markdown and hosted on Github. You can edit them by clicking on the "Click here to edit this page on Github !" link at the bottom of the page. See down there 👇

If you are willing to participate the the DBGI Dendron notes have a look at the [[welcome]] section to get you started !


## What's new ?!

This web site might not necessarily seem to be change since the last time you came to visit.

If something moved recently you should be able to track this over there https://github.com/digital-botanical-gardens-initiative/dendron-dbgi/commits/main