I tried to use the ExportToDatabase module and have gotten an ‘Identifier to long’ error. I’m using MySQL 5.0.26 it appears that Identifiers for column names have a 64 character limit. This is the first Identifier that caused a problem:
turns out this one is 65 characters. Any comments?
Which database server are you all using? Is there any documentation on your databasing strategy?
After deleting lines that were too long I was able to create a database. From a first pass examination of the tables created after the SBS example it appears that a new column is made for every new measurement. That means table from different types of analysis will have different numbers of columns. That’s a bit strange. Granted this will keep all measurements related to a single object on one row, but as more channels/colors are taken of one field the number of columns is going to keep getting bigger. Was there a reason for doing it this way?
Has anyone considered putting the outline for each object in the database?
One final question is this a list of all the possible measurements in CP?