Slashdot Mirror

← Back to Stories (view on slashdot.org)

ERD Apps a Missing OSS Niche?

Posted by Cliff on from the drawing-lines-and-boxes dept.

Pennyless Developer asks: "So the time comes when one must design a brand spankin' new database schema. You want to use an Entity-Relationship diagramming tool with hopefully some automatic schema generation tools, but do not have much money to purchase anything like Rational Rose. Like a true geek well versed in OSS, you head off to scan sourceforge, freshmeat, and google. But alas, it appears no such applications exist in the OSS world, at least none beyond the planning stage. The question I pose is this: What useful, OSS/Free/Cheap ERD applications have you found and used? Or do developers do all their ERD work under an evaluation period of commercial software?"

25 comments

  1. Join the trolls! by Anonymous Coward · · Score: -1, Offtopic

    Details:

    IRC Server - trollaxor.com
    Port - 6667
    Channel - #trolls

    You need an IRC client to chat on an IRC server.

    1. Re:Join the trolls! by Anonymous Coward · · Score: -1, Flamebait

      It's channel #slashdot, you fucking dumb piece of shit motherfucking shitface bot cunt bastard fucker. Thank you.

    2. Re:Join the trolls! by Anonymous Coward · · Score: 0

      We are already among the trolls.

      thx c u

  2. Wot? by MMMMMMMMMMMMMMMMMMMM · · Score: -1

    Wot you say? Don't cram so much buzz words in the title, it's unintelligible.

  3. You all suck -- Slashdot NAZIS!!! by Linus+Turdballs · · Score: -1

    Heil! CmdrTaco!
    Heil! Michael!
    Heil! Jamie!
    Heil! CowBoiKneel!!
    Heil! Heil!!!

    Heil, heil! Right in Der Taco's face!

    --

    -- Linus Torvalds

  4. Data Architect from TheKompany by Anonymous Coward · · Score: 1, Informative

    If i am understanding your question. This may be something you could use. I do not know if there is a GTK equivalent or if that even matters.

    http://www.thekompany.com/products/dataarchitect /

  5. A Tribute To The Greats (USian pie) by pwpbot · · Score: -1

    Originally by USian Pie Widened by pwpbotA long long time ago I can still remember How the trollers used to make me smile And I knew if I had to boast That I could try to get first post And maybe Id be happy for a while But moderators made me shiver With every minus theyd deliver DoS scripts couldnt stop it They scored them all Offtopic I know that its cheap crack they smoke And metamoderations broke At first I thought it was a joke The day that trolltalk died Chorus Bye bye MEEPTy OOG and Grits guy Drove the Cruiser like some loser who starts posts with a sigh Those Steve Woston posts that we all knew were a lie Wonder what became of girls petrified What became of girls petrified Did you write a bunch of Perl And did it make you want to hurl Feces at the Wall Can you believe these lameass polls Do you post big stretchedout assholes Can you make the goatsecx link not show Well I know you think that Siggy sucked Will the real Bruce Perens please stand up The bots dont have a clue Man I dig those trolls from Shoe I was a rabid Free Speech advocate With a Red Hat Tshirt and a Free Beer gut Bought my Sony laptop working Pizza Hut The day that trolltalk died Chorus Its been two years since the IPO And LNUX sinks to alltime lows But thats not how it used to be When Spiral showed how it was done Trolling as Jon Erikson Who worked for NPO Technologies Oh and while they tried to filter posts Somebody rooted Slashdots host Crack Slashdot Thats absurd Better go change your password While JonKatz wrote a Hellmouth book By using posts he simply took And we flamed him till he was cooked The day that trolltalk died And we were singin Chorus 10 grams Inchfan Didnt log out Goddamn The mods will find the sid real soon man You cant hide if you arent AC Your bud George here tried BSD A dead Streetlawyers tips were free And WIPO helped letsriot turn Nazi 70 made his percents up While 80md warned liberals suck The moon does not exist Its just a liberal myth Oh and as Taco tried to take a nap We forced him to invoke bitchslaps Do you recall the flood of crap The day that trolltalk died We started singin Chorus Oh and then we were wearing out All your base And started posting monospace The better for our penis birds So come on be a zealot be a dick You dont think Anne Maries a chick Because lyings all we do about HURD So go and push for BSD And say GPL isnt free Slow down cowboy The limit Is one post every minute Now tell the right wing facist slime Infringing on Your Rights Online That they cant censor all the time The day that trolltalk died Chorus I met a troll they called The Rev And asked him if CD BREAK HEAD He said Thats old Get over it And with all the courage I could muster Imagine what a Beowulf cluster But it wasnt worth the trouble to submit The karma caps are just plain jive And everyones moved to K5 The steelcage has grown rusted And Geekizoid is busted The three sites I dont see for weeks Segfault kernel Compugeek Code is not art This aint Freshmeat The day that trolltalk died Chorus

  6. OSS Rational Rose equivalent by sl956 · · Score: 5, Informative
    If you want an OSS cross-platform replacement of Rational Rose, you should try argoUML :
    • 100% java
    • BSD licence
    • only a few UML v1.3 features not (yet) supported
    • import/export from/to Rational Rose using XMI are not (yet) totally working but a third party tool exists to do the translation (can't recall the name)
    • SVG output (!)
    • you can add all the plugins you want/need on top of the core app (MOF metamodel and GEF graphical framework)
    • commercial support provided by Gentleware (if you've got a PHB to convince)
    All in all a very cool app if you need something like Rational Rose.
    BUT I'm not aware of any support of Entity/Relationship diagramming or sql generation in either of those apps.
    1. Re:OSS Rational Rose equivalent by Hektor_Troy · · Score: 2

      I haven't looked into the project yet (I'm still at work, and am just inbetween recompiling).

      Can ArgoUML create code from sequence diagrams? Partial code?

      I haven't found ANY UML tool that can do that, and it's a real pain in the ass to have to reimplement everything you just did in the diagram in code ...

      --
      We do not live in the 21st century. We live in the 20 second century.
  7. Software Engineering?? by Anonymous Coward · · Score: -1, Troll

    First off, this whole topic runs up against the long tradition of code hacking. People don't design 'Open source' software, they wait until a commercial program is developed and then make an Open Source copy of it.

    In particular, there's no room in Open Source for 'software engineers.' A true geek sits down in front of his emacs and hacks. Data structures are reverse engineered from other projects or they evolve in email exchanges and mailing lists.

    1. Re:Software Engineering?? by Anonymous Coward · · Score: 0

      Oh bollocks, trolly troll. Name one OSS ripoff that didn't take things already stolen from another.

  8. Check out Dezign for Databases by sheraz · · Score: 3, Informative

    A year ago I hit this wall. I gave up on the OSS end and decided to (gasp) buy a package - Dezign for Databases by a company called Datanamic. $150 for the full version - you can use all kinds of DBs - Postgres,Mysql,Oracle,DB2,etc,etc. I will also do Access conversion stuff, but I have never played with that. There is talk that they will release a Linux version. As of now it is only Win32, but it is work every penny. It has saved me tons of time.

  9. DBVisualizer or Visual Thought by Will+Sargent · · Score: 1, Offtopic

    A shameless plug for Visual Thought. It won't do ERD automatically, but it's great for the stuff you'd use a whiteboard for usually.

    If you want to look at the structure of an existing database, try DBVisualizer

  10. You need a different database by Anonymous Coward · · Score: -1, Offtopic

    I know I'll get modded down for this, but here goes. Switch to SQL Server. It has the tools you request already.

  11. dia2sql by FreakBoy · · Score: 2, Informative

    I just saw a new package in debian called dia2sql. You may want to check that out...

  12. Tools? Bah.... by ericnewton · · Score: 1

    I like to write my ER diagrams in something executable, like python scripts, which will create my schema automagically.

    If you gotta have pictures, you might want to check out Dia, whose file format is XML. It has ER diagram components for you to connect. When you are done drawing, write a quick program to translate the XML description into SQL.

    1. Re:Tools? Bah.... by V.+Mole · · Score: 2

      ..write a quick program to translate the XML description into SQL.

      No, don't write one, get dia2sql

  13. Rational Rose? Blech , no thanks by boltar · · Score: -1

    Rose produce software thats even more bloated and
    slow than M$. Anyone who's used their middleware
    C++ database libraries will know how they can
    reduce even a top end server to a crawl , their
    license fees are extortionate and their user training
    and support is a joke. I wouldn't touch their
    stuff with a 10 foot pole these days.

  14. Great tool but not for ERD by Felipe+Hoffa · · Score: 1

    ArgoUML is a great tool, but it isn't designed for ER databases. As it name says its for UML, and UML doesn't include an specification for ERD.

    You can try faking a class diagram to look as an ERD using some stereotypes, but those stereotypes are not implemented yet in ArgoUML yet (Rational Rose has them).

    Anyway, ArgoUML is a great product and I'm a proud user of it.

    Fh

  15. MagicDraw UML by NeuroMorphus · · Score: 1

    Check out MagicDraw UML(http://www.linux.org/apps/AppId_6831.html)

    But 2 thumbs up for the previous python post that suggest writing python scripts.

    --

    python >>>
    reduce(lambda x,y:x+y,map(lambda x:chr(ord(x)^42),tuple('zS^BED\nX_FOY\x0b')))
  16. Why? by PersonalizedSpam · · Score: 1

    Drop the UML .... drop the "automated schema changes" and use normal, old fashioned oo --> database methodoligies. This whole fixation on UML and autotmated schema creation is just absurd, when its so easy to work with the database itself in sQL ... and won't hamper your design. The managers at my old company loved UML and schema propogation ... and were awarded with bloated, hard to understand code. (Thank God they had no say over my use of the database). My 2 cents ....

    1. Re:Why? by sidecut · · Score: 1
      In my opinion, good automated tools work well for large projects that are hard to code and maintain by hand.

      I agree with you that one may have problems understanding and maintaining the detailed code resulting from code builders/generators/etc., but that can result from two things:

      1) Generated code is inherently trickier to read than hand-written code. The good code generators amply comment so that you know the difference between what's been generated and what you've coded.

      2) Such tools are intended for a higher layer than the code layer (to coin a phrase). An analogy (that stretches the point a little) may help explain what I'm saying: it's similar to reading the assembler output from a good compiler and complaining that it's hard to understand the programmer's intent. Correct! The assembler is not meant to be read; the higher-level source code is the real code.

      Such design tools work well if they incorporated good "round-trip engineering," which means you can switch back and forth between the generated code (SQL) and the "source" code (the diagram).

      (I hate to say it, but VC++ does a pretty good job of this when writing COM objects. You point and shoot and it creates skeleton code and interface code based upon your declarations, but you may still tweak the hell out of the resulting code. This is because they did a good job of putting markers in the comments.)

      If the product being considered has good round-trip engineering or can otherwise track well the code it's generated, I believe you've got the best of both worlds.

      Reading the other posts, in my opinion the XML-based package (Dia) rocks (at least on paper -- I've never used it). From the resultant XML a series of good code generators can be written.

      Subject for a future Ask Slashdot: what's a good convention for such round-trip comments?

  17. A GNU Clone of Uniface by Anonymous Coward · · Score: 0

    from Compuware would be interesting:

    Uniface

  18. Dia by autechre · · Score: 2


    http://freshmeat.net/projects/dia/

    I was taking a class where we were shown Visio, but I used Dia instead for my final project report. Not that this should influence your decision, but I did get an A in the class :)

    --
    WMBC freeform/independent online radio.
  19. ERW by vigna · · Score: 1

    Maybe you could find useful the stuff we developed for our internal usage: http://erw.dsi.unimi.it .

    There is presently no graphical tool for editing diagrams--you must describe your schema using XML (we are working on graphical tool, but it is still, at best, immature).