<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">
Hi Douglas,
<div class=""><br class="">
</div>
<div class="">I’m afraid that in a brief discussion this morning, no-one had an obvious solution to your problem.</div>
<div class=""><br class="">
</div>
<div class="">For OMERO.figure, I’m storing figures as json written to an OMERO file, which allows for</div>
<div class="">complex data structures to be stored, but doesn’t provide fast access or queryability,</div>
<div class="">so I’m not sure that’s much better than what you’re currently doing.</div>
<div class="">I guess it does allow you to store types (Number vv String) instead of all strings.</div>
<div class=""><br class="">
</div>
<div class="">Another option might be OMERO.tables, which are good for querying data.</div>
<div class="">Not sure how good they are for updating.</div>
<div class=""><a href="https://www.openmicroscopy.org/site/support/omero5.2/developers/Python.html#omero-tables" class="">https://www.openmicroscopy.org/site/support/omero5.2/developers/Python.html#omero-tables</a></div>
<div class=""><br class="">
</div>
<div class="">Sorry we can’t be of more help.</div>
<div class=""><br class="">
</div>
<div class=""> Cheers,</div>
<div class=""><br class="">
</div>
<div class=""> Will.</div>
<div class=""><br class="">
</div>
<div class=""><br class="">
</div>
<div class=""><br class="">
<div>
<blockquote type="cite" class="">
<div class="">On 19 Oct 2016, at 21:41, Douglas Russell <<a href="mailto:douglas_russell@hms.harvard.edu" class="">douglas_russell@hms.harvard.edu</a>> wrote:</div>
<br class="Apple-interchange-newline">
<div class="">
<div dir="ltr" class="">Hey,
<div class=""><br class="">
</div>
<div class="">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.</div>
<div class=""><br class="">
</div>
<div class="">This is what I want to store:</div>
<div class="">
<ul class="">
<li class="">Form
<ul class="">
<li class="">ID - Globally unique name</li><li class="">Owner - UID of creator</li><li class="">Groups - list of GIDs the form is available to</li><li class="">Types - Object types for which this form is valid (e.g. Dataset)</li></ul>
</li><li class="">FormVersion
<ul class="">
<li class="">Version - Version</li><li class="">Timestamp - Creation time+date</li><li class="">Schema - The JSON string encoded form schema</li><li class="">UISchema - The JSON string encoded form UI schema</li></ul>
</li><li class="">FormData
<ul class="">
<li class="">formID - The form used to enter this data</li><li class="">formVersion - The form version used to enter this data</li><li class="">data - The actual JSON string encoded data</li><li class="">objectType - The object type for which this data was entered (e.g. Dataset)</li><li class="">objectId = The object ID for which this data was entered</li><li class="">Timestamp - Creation time+date</li><li class="">User - UID of user who submitted form</li></ul>
</li></ul>
<div class="">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.</div>
<div class=""><br class="">
</div>
<div class="">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.</div>
<div class=""><br class="">
</div>
<div class="">Any ideas would be most welcome.</div>
<div class=""><br class="">
</div>
</div>
<div class="">Cheers,</div>
<div class=""><br class="">
</div>
<div class="">Douglas</div>
<div class=""><br class="">
</div>
<div class=""><br class="">
</div>
</div>
_______________________________________________<br class="">
ome-devel mailing list<br class="">
<a href="mailto:ome-devel@lists.openmicroscopy.org.uk" class="">ome-devel@lists.openmicroscopy.org.uk</a><br class="">
http://lists.openmicroscopy.org.uk/mailman/listinfo/ome-devel<br class="">
</div>
</blockquote>
</div>
<br class="">
</div>
<br>
<span style="font-size:10pt;">The University of Dundee is a registered Scottish Charity, No: SC015096</span>
</body>
</html>