# EM/ISPyB meeting 2021-02-05

### present work done to date

* New role advertised for the Synchweb developer, 21st of February shortlisting. Likely decision by end of March. 12 applicants so far.
* Database schema - we have a pretty good idea what the version 1 of our changeset is. We plan to implement that instead of iterating the design first. We can then review in 4-5 months time.
* James so far was 100% busy on shipping, which will continue for a few weeks. He should be able to pick up Relion work in the February/March timeframe.
* Synchweb pages do not cover DB schema V1 features

### plan the next steps

* Version 1 of the schema should be deployed in the next week or two.
* Unclear if that includes the stored procedures to go along with it.
* We will need stored procedures to insert information (the ISPyB API workaround for missing stored procedures is read-only)
* MG et al to implement the ISPyB API calls to write to the database, add new functions to the ISPyB Zocalo service
* Deployment plan brings us into Shutdown 2 (12.03.2021)
* Once we have information in the database James could look at displaying the information in the database in a trivial way

**Action points:**
* [ ] NS to send DB schema V1 to MG, DC & YC
* [ ] KL to deploy the new schema by 19.02.2021
* [ ] NS to find out whether stored procedures are included in that (and if not, get a date)
* [ ] ISPyB API updated by 26.02.2021 by data analysis
* [ ] ISPyB Zocalo service updated by 12.03.2021 by data analysis
* [ ] Review DB schema V1 to identify priorities for V2; arrange a meeting first week of March

### AOB / next meeting