<h1 id="2024-08-14">2024-08-14<a aria-hidden="true" class="anchor-heading icon-link" href="#2024-08-14"></a></h1>
<h1 id="this-is-edouards-dbgi-daily-open-notebook">This is Edouard's DBGI daily open-notebook.<a aria-hidden="true" class="anchor-heading icon-link" href="#this-is-edouards-dbgi-daily-open-notebook"></a></h1>
<p>Today is 2024.08.14</p>
<h1 id="extract-schema-from-a-postgresql-database">Extract schema from a postgresql database<a aria-hidden="true" class="anchor-heading icon-link" href="#extract-schema-from-a-postgresql-database"></a></h1>
<p>pg_dump -h <ip> -p <port> -d <db> -U &#x3C;pg_username> -s -F p -E UTF-8 -f &#x3C;filename.sql></db></port></ip></p>
<h1 id="to-discuss-with-pma-about-directus-db">To discuss with PMA about directus DB<a aria-hidden="true" class="anchor-heading icon-link" href="#to-discuss-with-pma-about-directus-db"></a></h1>
<ul class="contains-task-list">
<li class="task-list-item"><input type="checkbox" checked disabled> link batches table to ms_data and others</li>
<li class="task-list-item"><input type="checkbox" checked disabled> finite positions true false</li>
<li class="task-list-item"><input type="checkbox" checked disabled> table instruments models en plus</li>
<li class="task-list-item"><input type="checkbox" disabled> Pour plus tard: table users</li>
<li class="task-list-item"><input type="checkbox" checked disabled> EMI_Projects to projects (generalize)</li>
</ul>

Extract schema from a postgresql database

This is Edouard's DBGI daily open-notebook.

2024-08-14


# 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