Database Schema Viewer: What do you like to see added?

For meanwhile more than 25 years I am writing computer programs. More than a decade I spent with programs accessing databases, virtually always relational ones. I soon learned that this is rather hard work. Not only that you need to know about the theory behind RDBMS iself, but also you need to know the technical APIs (like ODBC, ADO, RDO, JDBC, JDO, JPA, CMP, ...), the structure of the database itself ("Schema": table names, keys, data types, etc.) and it's management system (like Oracle, Microsoft, Sybase, etc.). And certainly there are lots of tools. I've seen come-and-go so much different tools, all of them blown with lots of never used features. Each different to use and to install. What I always missed, as a coder, was some "small" solution. I just wanted to look up the tables, the names of the columns, the data types. I don't needed a graphical map ("ER diagram"). Just something that I can quickly start to peek into the schema. But almost all of the tools I had, where just too heavyweight. They needed endless to start, or had been buggy, or you needed much too much mouse clicks to get to your information. My dream was to have something like a type or cat command, which just prints some information, without further stuff around it. So I checked the web and noticed that there was not so much in that direction, actually. So I sta...

Date: February, 28 2010
Url: http://www.java.net/blog/mkarg/archive/2010/02/27/database-schema-viewer-what-do-you-see-added

Others News