Database documentation

It is so frustrating to guess database structure intention without any information about it. Liquibase has a great feature, which helps to prevent a lot of guessing. Liquibase can generate an html documentation of db. However the documentation is pretty sparse. But be not frustrated, there is a light over there at the end of the tunnel...

Graphviz - dot source for my graph

For those who wandered what is the input file for my graph... The input files for graphviz are called "dot" files. Here is the input "dot" file for my graph from the last post:

Graghviz in action

Graphviz - data visualization

I had a problem to follow a logic in someones programming and I had to deliver... I had to come up with a solution to push the brick forward. I started to look for a visualization tool for my problem. And to my surprise I found a graphviz - a tool for data visualization.

After some time I was able to come up with this:

Graphviz in action

LiquiBase - the way to handle a database

I am in a middle of rework of an old script. Whole structure of a solution was cumbersome a lot so I had to step in to correct the stuff. I knew that the script has some data in a MySQL database. It uses few tables in a large db with tens and tens of other tables.

Long time no ... write....

I see I didn't put a link over here for almost two years. Yeah, a lot changed since my last update... I'll start to cover it soon topic by topic.