[ome-devel] OMERO.forms

[William Moore (Staff)]

Hi Douglas,

I’m afraid that in a brief discussion this morning, no-one had an obvious solution to your problem.

For OMERO.figure, I’m storing figures as json written to an OMERO file, which allows for
complex data structures to be stored, but doesn’t provide fast access or queryability,
so I’m not sure that’s much better than what you’re currently doing.
I guess it does allow you to store types (Number vv String) instead of all strings.

Another option might be OMERO.tables, which are good for querying data.
Not sure how good they are for updating.
https://www.openmicroscopy.org/site/support/omero5.2/developers/Python.html#omero-tables

Sorry we can’t be of more help.

 Cheers,

   Will.



On 19 Oct 2016, at 21:41, Douglas Russell <douglas_russell at hms.harvard.edu<mailto:douglas_russell at hms.harvard.edu>> wrote:

Hey,

I'm working on OMERO.forms and it's getting to the point where the approach for data storage I have taken (Using map annotations) is beginning to look too messy for comfort. I'm wondering if you have any suggestions for what the best way of doing this might be without adding a difficult to install/maintain component (i.e. a database) to OMERO.forms.

This is what I want to store:

  *   Form
     *   ID - Globally unique name
     *   Owner - UID of creator
     *   Groups - list of GIDs the form is available to
     *   Types - Object types for which this form is valid (e.g. Dataset)
  *   FormVersion
     *   Version - Version
     *   Timestamp - Creation time+date
     *   Schema - The JSON string encoded form schema
     *   UISchema - The JSON string encoded form UI schema
  *   FormData
     *   formID - The form used to enter this data
     *   formVersion - The form version used to enter this data
     *   data - The actual JSON string encoded data
     *   objectType - The object type for which this data was entered (e.g. Dataset)
     *   objectId = The object ID for which this data was entered
     *   Timestamp - Creation time+date
     *   User - UID of user who submitted form

This is a pretty trivial problem if I could use a relational database and I would get transactions and data integrity. Right now I am trying to shoehorn this into Map Annotations attached to a special privileged user who the OMERO.forms web plugin sudos as, but it is getting increasingly difficult to do this in a sane way. Updates especially are horrible.

As this is a web extension, I also wanted to keep the install/update procedure as simple as possible. Adding the use of a local database as a prerequisite did not seem reasonable.

Any ideas would be most welcome.

Cheers,

Douglas


_______________________________________________
ome-devel mailing list
ome-devel at lists.openmicroscopy.org.uk<mailto:ome-devel at lists.openmicroscopy.org.uk>
http://lists.openmicroscopy.org.uk/mailman/listinfo/ome-devel


The University of Dundee is a registered Scottish Charity, No: SC015096
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openmicroscopy.org.uk/pipermail/ome-devel/attachments/20161020/86000434/attachment.html>