Joys of Reconciliation
by on with No Comments

I’ve mainly spent time working on identifying the specific differences in the formats of data we’ve used for the last two years.There are some differences between Iceland 2014 data and Nicaragua 2015 data,and even more significant differences between Iceland 2013 data and the rest of what we’ve collected.To be able to start putting together the pieces of what we have and effectively cleaning them up,we need to locate and tag everything we can find,which is what I’ve been upto.

I now have a master table of sorts of Iceland 2014 data and Nicaragua 2015 data,so I know what/where we need to add/modify so as to have a consistent pattern in our data.

I’ve been working on what additional functionalities we want our data model to accommodate before we go back,and how to fit in the pieces of whatever we do have into the data model we decide is best this year.

 

Database design tools
by on with No Comments

I spent this past week learning about what options exist as far as small scale database diagram tools exist.
I found a lot of tools that are standalone desktop applications,but once I decided that we needed a design tool that was a browser based application,the search was narrowed down quite a bit.I think being able to collaboratively look at the current designs lends itself to the kind of work we’re trying to do,so this is the final list of what I’ve narrowed the search down to:

  1. https://dbdiffo.com/
  2. http://www.vertabelo.com/
  3. https://diagrams.seaquail.net/

I’m partial to using Vertabelo at this point,having played around with it for a while.I really like the interface and it’s pretty intuitive.It’s also free as long as the project is small,and we definitely come under what Vertabelo identifies as such.

I

1 2