[INFRA-136] Choose standard project database Created: 24/Jun/17  Updated: 19/Jun/20  Resolved: 24/Jun/17

Status: Open
Project: Software Development Infrastructure
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Task Priority: Normal
Reporter: cloomis Assignee: cloomis
Resolution: Unresolved Votes: 0
Labels: FPS, MCS, opDB
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified


 Description   

For the sake of project administration, can we settle on a single database implementation? MySQL? PostgreSQL? MariaDB?

So far ICS is using postgres via psycopg2, mostly for the archiver. But I don't think we have strong opinions.
FPS also uses Postgresql

Do any observing/targeting/pipeline groups care yet?

 Comments   
Comment by rhl [ 24/Jun/17 ]

I believe that NAOJ has a strong attachment to postgres, and that's what Yasuda-san uses at IPMU.

Comment by shimono [ 24/Jun/17 ]

I havn't heard on standard of database at Subaru (I suppose they are|were operating Oracle also?), but postgresql is the current selection for ICS. (MySQL or Maria is also fine for me, although.)

Actually I thought Princeton has a strong attachment to postgres, and that's why I asked FPS to use postgres.

Comment by rhl [ 24/Jun/17 ]

You should have asked Princeton.

We have no biases; LSST is currently using mariadb. The postgres preference comes from NAOJ – who there told you that they used Oracle?

Comment by shimono [ 25/Jun/17 ]

Oracle (is|was - not sure for now) used for guide star database - I might have document but could be under Mitsubishi...

Comment by shimono [ 27/Jun/17 ]

Ok. Let me set our baseline as PostgreSQL over the entire project and do as follows:

  • Check whether Subaru (or/and Mitaka?) have any desire/interest
  • Check Kiyoto and MPA for this point
  • Define our baseline and have some statement at pfspipe website.
Comment by naoyuki.tamura [ 27/Jun/17 ]

I think we should ask Chi-hung and other ASIAA colleagues about this for discussions? Should they technically be able to monitor this ticket? If not, I think they should be explicitly nominated as watchers.

Comment by shimono [ 27/Jun/17 ]

Actually I thought postgres was defined as project standard, and pointed ASIAA to follow already - last year.... so I assume no issue if we don't change it.

Comment by naoyuki.tamura [ 27/Jun/17 ]

OK then - Good to make sure of it, thanks.

Comment by shimono [ 27/Jun/17 ]

also we may need to fix INFRA-96 not to make confusion, before going forward??

Generated at Sat Feb 10 16:49:47 JST 2024 using Jira 8.3.4#803005-sha1:1f96e09b3c60279a408a2ae47be3c745f571388b.