topbanner_forum
  *

avatar image

Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
  • Tuesday March 19, 2024, 6:56 am
  • Proudly celebrating 15+ years online.
  • Donate now to become a lifetime supporting member of the site and get a non-expiring license key for all of our programs.
  • donate

Author Topic: SqlSpec  (Read 6845 times)

jezemine

  • Participant
  • Joined in 2009
  • *
  • default avatar
  • Posts: 5
    • View Profile
    • Donate to Member
SqlSpec
« on: November 04, 2010, 10:40 AM »
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
« Last Edit: November 05, 2010, 01:26 AM by jezemine »

mouser

  • First Author
  • Administrator
  • Joined in 2005
  • *****
  • Posts: 40,896
    • View Profile
    • Mouser's Software Zone on DonationCoder.com
    • Read more about this member.
    • Donate to Member
Re: SqlSpec
« Reply #1 on: November 04, 2010, 10:51 AM »
Welcome to the site Jesse, that looks pretty cool i must say.

f0dder

  • Charter Honorary Member
  • Joined in 2005
  • ***
  • Posts: 9,153
  • [Well, THAT escalated quickly!]
    • View Profile
    • f0dder's place
    • Read more about this member.
    • Donate to Member
Re: SqlSpec
« Reply #2 on: November 04, 2010, 01:06 PM »
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 :)
- carpe noctem

jezemine

  • Participant
  • Joined in 2009
  • *
  • default avatar
  • Posts: 5
    • View Profile
    • Donate to Member
Re: SqlSpec
« Reply #3 on: November 04, 2010, 01:09 PM »
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.
« Last Edit: November 04, 2010, 01:15 PM by jezemine »

f0dder

  • Charter Honorary Member
  • Joined in 2005
  • ***
  • Posts: 9,153
  • [Well, THAT escalated quickly!]
    • View Profile
    • f0dder's place
    • Read more about this member.
    • Donate to Member
Re: SqlSpec
« Reply #4 on: November 04, 2010, 01:19 PM »
Hm, FireBug "Inspect Element" tells me that the pie chart under "Largest procedures by code length" is SVG :)
- carpe noctem

jezemine

  • Participant
  • Joined in 2009
  • *
  • default avatar
  • Posts: 5
    • View Profile
    • Donate to Member
Re: SqlSpec
« Reply #5 on: November 04, 2010, 01:32 PM »
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

  • Charter Honorary Member
  • Joined in 2005
  • ***
  • Posts: 9,153
  • [Well, THAT escalated quickly!]
    • View Profile
    • f0dder's place
    • Read more about this member.
    • Donate to Member
Re: SqlSpec
« Reply #6 on: November 04, 2010, 01:46 PM »
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 :)
- carpe noctem

jezemine

  • Participant
  • Joined in 2009
  • *
  • default avatar
  • Posts: 5
    • View Profile
    • Donate to Member
Re: SqlSpec
« Reply #7 on: November 11, 2010, 01:09 AM »
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

  • Charter Honorary Member
  • Joined in 2005
  • ***
  • Posts: 9,153
  • [Well, THAT escalated quickly!]
    • View Profile
    • f0dder's place
    • Read more about this member.
    • Donate to Member
Re: SqlSpec
« Reply #8 on: November 11, 2010, 03:16 AM »
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
Much better! :)
- carpe noctem