SchemaSpy

-

SchemaSpy is a very useful tool for database Administrators and Developers. The basic purpose of SchemaSpy is to auto-generate schema for any database. But it's evolved in a great tool that can give us so much valuable information about any database. The case in question is that of a complex database consisting of more than 30 tables with some tables having fields in excess of 50 and complex links.

I won't go into details of everything here but rather I'll outline major points. After successfully running SchemaSpy on a database you are presented with an output of number of HTML files in the designated folder on your PC. The index.html file is the starting point for this output. After opening it you can see following tabs.
 

And that's a lot of information that you get about the database.

The first tab - tables - lists all the tables, next one displays a relationship diagram, next lists Utility tables and details for them, the next one does constraints, after that it even shows anomalies that can affect the integrity of your data, then's one that lists all columns in your database and the last tab takes you to donate link.

Overall you can see that SchemaSpy is a powerful tool for DBA/Developers.

To use it, you need couple of things:
1. The JRE - since Schema Spy is written in Java.
2. GraphViz - Schema Spy uses graphviz to create the relationship diagram seen in second tab.

Comments

Post a Comment

Popular posts from this blog

Morning Quotes

-
Image
Source: www.brainyquote.com   I may be drunk, Miss, but in the morning I will be sober and you will still be ugly. Winston Churchill   Prayer is the key of the morning and the bolt of the evening. Mohandas Gandhi   I look upon death to be as necessary to our constitution as sleep. We shall rise refreshed in the morning. Benjamin Franklin  
Read more

QCalendarWidget CSS Stylesheeting

-
Recently I had to implement a calendar for a TouchScreen application. I resorted to css to modify the calendar widget's appearance so that it would be more accessible. Following is the code that enabled me to get a proper calendar. calendar->setStyleSheet("QMenu { font-size:20px; width: 300px; left: 20px; }"     "QToolButton {icon-size: 48px, 48px; font: 20px; height: 70px; width: 100px; }"     "QAbstractItemView {selection-background-color: rgb(255, 174, 0);}"     "QToolButton::menu-indicator{ width: 50px;}"     "QToolButton::menu-indicator:pressed,"     "QToolButton::menu-indicator:open{ top:10px; left: 10px;}"     "QTableView { font: 30px; }"     "QSpinBox { width: 100px; font: 20px;}"     "QSpinBox::up-button { width:40px;}"     "QSpinBox::down-button { width:40px;}");
Read more

Selecting new phone plan

-
I use a Reliance Jio SIM as my one and only cellphone number. I used to have another, but I found little use for that. So I discontinued that other SIM card. It was a Vodafone SIM and I had bought it thinking I would be using it when I visit my hometown. Turns out it's not usable there. So adios. Coming back to Jio, it was working so far so good for a while. And it was quite cheap. Then they increased the fares about 4-5 months ago. And it was costing ~Rs 7 per day. This was for unlimited Jio-Jio calling, ~300minutes free to other telcos, and 1.5GB daily cellular data. Now I got home internet, so I thought to cut costs on this. The current plan goes for INR555 for 84 days. This includes 1.4GB 4G cellular data per day, 300 min calling to other telcos, and jio-jio free. That's Rs 6.6 per day. Now I'm not even using 30minutes calling per day. And due to home internet my cellular usage has gone down. So I decided to go for some other cheaper plan. This one is INR1299 for 336 da...
Read more