Re: data modeling question

2002-10-31 Thread olinux
I think the best solution would be TABLE ITEMS [ item_id | parent_id | item_name ] data 1, 0, foo 2, 0, bar 3, 2, baz 4, 2, quux 5, 1, fee 6, 1, fi So above baz and quux are subcats of bar and fee/fi are subcats of foo This structure allows for unlimited levels of sub-categories to be added. G

Re: Data modeling tool

2001-03-16 Thread chicks
On Wed, 14 Feb 2001, Dario Brignardello wrote: > Hey! That's exactly what I'm working in... is your dia's parser GPLed > ?? :-) It could help me a lot... Thanks in advance :-) I told folks at our local perl mongers ( http://norfolk.pm.org ) that I was working on packaging up what I had to send to

Re: Data modeling tool

2001-02-14 Thread chicks
On Wed, 14 Feb 2001, Dave Rolsky wrote: > One feature I've been considering for Alzabo is to be able to somehow > process dia's XML and generate a schema from it. > > Alzabo will (sometime soon, I hope) be able to read/write DBML, an XML > language Barrie Slaymaker is working on (with some input

Re: Data modeling tool

2001-02-14 Thread Dave Rolsky
On Mon, 12 Feb 2001 [EMAIL PROTECTED] wrote: > Moving back and forth is a manual process, which is a bit frustrating. > Since dia stores everything in XML, I'm considering what it would take to > make some sort of syncronization. > > I've been planning on looking into Alzabo too, which was alread

RE: Data modeling tool [Long Rant and then some information]

2001-02-12 Thread Cal Evans
evans.com p.s. my gripe about size limited demos still stands. -Original Message- From: Cal Evans [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 11, 2001 9:36 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Data modeling tool Mark, I like CASE but I wish they would add MySQL R

Re: Data modeling tool

2001-02-12 Thread chicks
On Sat, 10 Feb 2001, Cal Evans <[EMAIL PROTECTED]> wrote: > As much as I love creating models by hand, my databases are growing to > the point where I need a tool to help me "see" them. Does anyone know > of a tool like ERWin or ER/Studio that supports MySQL? I do my diagrams in UML with dia. A

RE: Data modeling tool

2001-02-11 Thread John Dean
w.calevans.com > > >-Original Message- >From: Mark Chalkley [mailto:[EMAIL PROTECTED]] >Sent: Saturday, February 10, 2001 6:12 PM >To: [EMAIL PROTECTED] >Subject: Re: Data modeling tool > > >I haven't tried ERWin, but CASE Studio (www.casestudio.com) is

RE: Data modeling tool

2001-02-11 Thread Mark Chalkley
I agree that a time-limited, but otherwise fully functional demo is better, especially in the case (pardon the pun) of database modelling. It would certainly be worth sending them a message telling them so. You never know - they might agree with you. Mark Chalkley -

RE: Data modeling tool

2001-02-11 Thread Cal Evans
models, I just can't save them. (Better than the other two but still not what I want) Cal http://www.calevans.com -Original Message- From: Michael Lépine [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 10, 2001 10:12 PM To: Cal Evans; [EMAIL PROTECTED] Subject: RE: Data modeling

RE: Data modeling tool

2001-02-11 Thread Cal Evans
:) I'd love to publish a full comparison of the tools but these size limited demo's bite. Cal http://www.calevans.com -Original Message- From: Mark Chalkley [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 10, 2001 6:12 PM To: [EMAIL PROTECTED] Subject: Re: Data

RE: Data modeling tool

2001-02-10 Thread Michael Lépine
I asked a similar question recently and as a result of my searching, I found a moderately priced, $99 (I think), data modeling tool from XTG (download here): http://www.xtgsystems.com/download.php3 I downloaded it and set up a few tables (only 4 are allowed with eval), then generated the sequel

Re: Data modeling tool

2001-02-10 Thread Dave Rolsky
On Sat, 10 Feb 2001, Cal Evans wrote: > As much as I love creating models by hand, my databases are growing to the > point where I need a tool to help me "see" them. Does anyone know of a tool > like ERWin or ER/Studio that supports MySQL? I have a project called Alzabo (alzabo.sourceforge.net)

Re: Data modeling tool

2001-02-10 Thread Mark Chalkley
I haven't tried ERWin, but CASE Studio (www.casestudio.com) is extremely good, offers a trial download, and does support MySQL. Mark Chalkleyi - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: Data modeling tool

2001-02-10 Thread Jon Rosenberg
I wish, ERWin is wonderful! - Original Message - From: "Cal Evans" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, February 10, 2001 6:41 PM Subject: Data modeling tool > As much as I love creating models by hand, my databases are growing to the > point where I need a tool

Re: Data Modeling

2001-02-02 Thread tlr7425
will you all be doing anything for OS X? At 8:01 AM + 2/2/01, John Dean wrote: >Hi >Hopefully, we plan to include Dezign for Databases in our new GUI >client, but this is not yet embedded in stone. > >At 23:54 01/02/2001 -0500, Michael Lépine wrote: >>I've tried searching the archives, but I

Re: Data Modeling

2001-02-01 Thread John Dean
Hi Hopefully, we plan to include Dezign for Databases in our new GUI client, but this is not yet embedded in stone. At 23:54 01/02/2001 -0500, Michael Lépine wrote: >I've tried searching the archives, but I haven't seen a direct question >about an open source tool or freely available application

Re: Data Modeling

2001-02-01 Thread Danny
For UNIX users (eg BSD, linux) there is something called dia which allows you to draw ERDs But, I assume you are looking something more like a RAD tool rather than a simple program that allows you to draw UML, ERD's etc. However, if you are intersted in dia and using Linux you can find the rpm