OLS-2 Meeting Minutes: Project Lead + Mentor Notes
===

###### tags: `OLS-2` `Meeting` `project-leads`

:::info
- **Call time**: [+0 GMT and we meet on Zoom at this link below]
- **Project name**: BioLab Open Source Projects
- **Project lead(s)**: Boï Kone and Bakary N’Tji Diallo
- **Mentor(s)**: Delphine Larivière
- **Call joining link**: https://psu.zoom.us/my/dellariviere
:::

**Table of content**

[TOC]

## Week 0

- Please read the email sent by OLS organisers to you
- Create a [GitHub account](https://github.com/) if you don't have one already - you will need that to login to HackMD and edit this document
- Get started with HackMD using this short guide: https://hackmd.io/@openlifesci/OLS-HackMD-guide

**Preferred time and days provided by the project lead(s)**
- We have the following information from the project leads (you can make changes as needed so that your mentor can identify the most suitable time for your intro call with them):
- GMT, "I can be available sometimes from 01pm to 02h30 pm. Totally free from 10h30 pm to 12h am in time GMT"

### Homework before meeting your mentor

**Project Lead (mentee) will:**

1. Take a Self-Assessment [SURVEY](https://docs.google.com/document/d/1sGsXThZ4sPpI3n0v674r2rWPB1qeQ-j3kkjh2fe9f5s/edit?usp=sharing) and share the outcome with their mentors during the call.
- [Link to your notes from the survey outcome]
2. Based on the insights gained from the survey, set 1-2 personal open science goals for yourself in OLS (it doesn't have to be about your project).
- [Add your response here]
3. State how their mentors can best support them in OLS (providing accountability, connect them with right people, share useful resources, specific skill they can help them gain either directly or with the help of OLS experts)
- [This could be a copy of what you wrote in your application]

## Week 1

**Roll call**

-
-

**Icebreaker/Conversation starter**

-
-

### Agenda and Notes for Week-1

- Introductions - get to know each other
- [TAKE NOTES HERE]
- Mentees, tell your mentor about yourself
- [TAKE NOTES HERE]
- Set your overall goals for your project
- [TAKE NOTES HERE]
- Where do you want your project to be by the end of the program (in 15 weeks)? Possible areas to think about:
- Community: Contributors / Maintainers / Members
- Product (Launch / MVP / Feature)
- Resources / Sustainability (Governance / Funding / Gifts)
- [TAKE NOTES HERE]
- Mentees, discuss your notes from your homework

**Meeting logistics & Reminders**

- Does this time every 2 weeks work for everyone?
- Full cohort call next week (see Syllabus for details: https://openlifesci.org/ols-2)

**Assignments after this call**

- Draft a brief **vision statement** using your personal and project goals. You might address:
- The problem you’re trying to solve.
- How you think openness and open leadership will help solve it.
- How meeting your personal goals will help you and help solve the problem.
- How meeting your cultural goals for your community, organization, or project will help solve the problem.
- Add your vision statement to your repo by uploading it or copy and pasting it into your README document.
- Anything else?

*Follow this [chapter from the Open Leadership Training Series (OLTS)](https://mozilla.github.io/open-leadership-training-series/articles/introduction-to-open-leadership/stating-your-project-vision/) to create your vision statement.*

## Ressources

### Project vision

https://docs.google.com/document/d/10_l-c2zmLUPSYPYgc1aEBuPA6CoYZphFi4FMGsCf-o0/edit?usp=sharing

### Databases

[GMOD](http://gmod.org/wiki/Databases_and_GMOD#Database_Management_System) and [Chado](http://gmod.org/wiki/Chado) : Database Creation and Management

## Tasks

### Timeline

- Establish some time line and milestone to have a better view of the project

### Hosting for the system

- Find a server to host the database and website
- Ask University
- Find partners

### Data

- Identify data need for the database
- What data wil be stored in it
- How will the database be querried

## Week 5 Meeting

Short term plan :

- Identify the datatypes used in that field
- Focus on developping a prototype on a computer, while looking on hosting ressources for future scale up
- Try SQLite with databse in flat files, (Delphine will link ressources)
- https://www.sqlite.org/index.html
- https://www.tutorialspoint.com/sqlite/index.htm
- SQlite in python https://www.sqlitetutorial.net/sqlite-python/creating-database/
- Work with fake data and build a prototype of querying data
- Note : Start with the easy ones, and build up on it

---

##### **MySQL Workbench functionality covers some main topics:**
https://dev.mysql.com/doc/workbench/en/wb-intro.html

1. -**SQL Development**: Enable to create and manage connections to database servers, and configured the connection parameters,
2. -**Data Modeling (Design)**: Enable to create models of database schema graphically, reverse and forward engineer between a schema and a live database, and edit all aspects of the database using the comprehensive Table Editor.
3. -Server Administration
4. -Data Migration
5. -MySQL Enterprise Suppor

## Week 7 Meeting

### Minutes

We have a database schema
- Write the documentation to explain the schema
- Find an expert to help plug the database to a website
- find hosting solution
- find library for sql query, automatic data upload
- Look at pahtogene DB for ideas on technology and database models (http://patho.phenomebrowser.net/#/help)