SqlSpec

[jezemine]

Hi folks,

I am the author of a database documentation tool called SqlSpec, selling it myself as shareware.   If you work with databases it could be interesting to you.  You can use it to find out how a database is put together, or if you are a freelancer you can use it to document the databases you build and give that documentation to your clients.  Also, I donate free licenses to any charity, non-profit, or open source project.

You can try it out here: http://www.elsasoft.org

It supports every major DBMS on the market, and some you have probably never heard of!  

Here are all the platforms it supports:

Microsoft SQL Server 2000/2005/2008
Microsoft Analysis Server 2005/2008
Microsoft Report Server 2005/2008
Microsoft Integration Server 2005/2008
Microsoft Access 97 and above
Oracle 9i and above
MySQL 5.0 and above
PostgreSQL 8.0 and above
Teradata 13.0 and above
DB2 8.2 and above
Sybase ASE 12.0 and above
Sybase SQL Anywhere 10.0
Informix IDS 10.0 and above
VistaDB 3.0 and above
SQLite 3.7
ENEA Polyhedra 7.0 and above
Raima RDM Server 8.1

here are a couple screenshots:
http://elsasoft.org/images/screen1.png
http://elsasoft.org/images/screen3.png
http://elsasoft.org/...ges/add_comments.png


Thanks for reading!

Jesse

[mouser]

Welcome to the site Jesse, that looks pretty cool i must say.

[f0dder]

A couple of recommendations:

1) Edit your post and include a screenshot showcasing the application; a picture says more than a 1000 words.
2) fix the screenshots on your product page, the dithered gifs look really bad; the ones I got to were the ones at the end of the "samples" page - the ones linked from the "features" page are alright. I'd also suggest a single smallish thumbnail on the main page.
3) Consider using lightbox for the screenshots.

The produced documentation looks nice - cool that you're using SVG for the piecharts... not so cool that the colors look dithered

[jezemine]

thanks for the feedback!  I'll fix the screenshots.

actually I am not using SVG for the piecharts - those are just gifs.

using SVG and VML for the dependency graphs, as in this example (scroll down on that page to see the graph)

http://www.elsasoft....roductionProduct.htm

If you view it in FF/Opera etc, you'll see SVG, in IE you'll see VML.

[f0dder]

Hm, FireBug "Inspect Element" tells me that the pie chart under "Largest procedures by code length" is SVG

[jezemine]

maybe firebug has a bug? 

in the sample page above, the code that includes the images is like this:

        <img border="0" src="tablesizes.gif" usemap="#Largesttablesbysizeondisk" alt="Largest tables by size on disk" />
        <img border="0" src="tablerows.gif" usemap="#Largesttablesbyrowcount" alt="Largest tables by row count" />
        <img border="0" src="indexsizes.gif" usemap="#Largestindexesbysizeondisk" alt="Largest indexes by size on disk" />

They are using an imagemap though, perhaps FF is using SVG somehow under the covers to do imagemaps.

[f0dder]

Ah, my bad - I didn't see the gif image (which is dithered) because the "Inspect Element" shows the map rather than the underlying image.

I wonder why the gif is dithered, considering it's nowhere close to using the available 256 colors? Perhaps it's not dithering but a non-solid fill brush, but the net effect is that it looks dithered

[jezemine]

I fixed the pie charts so the colors look better, thanks for the suggestion!

here's a sample: http://elsasoft.org/....XE.HR/allTables.htm

[f0dder]

I fixed the pie charts so the colors look better, thanks for the suggestion!

here's a sample: http://elsasoft.org/....XE.HR/allTables.htm

-jezemine (November 11, 2010, 01:09 AM)

Much better!