Lightning Admin sounds good, but can it be used with databases other
than postgreSQL? It's always nice, when investing time learning a tool,
if it can be used elsewhere.
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
I really like TOAD for building Oracle queries. Is there a TOAD-like,
FOSS query builder for PostgreSQL?
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
Date and Pascal hate nulls. One even goes so far as to say that if you
permit NULLs in a database, then the results from *every* query is
suspect. So they turn perform backflips suggesting ways to avoid nulls.
None, so far, seem appealing.
To me, nulls are quite useful in the Real World. For
'Scuse my broken english and ungrammatical gibberish in my last
missive. That's what I get for posting before my first cup of coffee
for the day.
I'm serious about nulls though, and am wondering if Date and Pascal,
perhaps, are the gibberish ones on this particular issue. The
insistence on no
Can Druid reverse engineer an Access 97 MDB file, say, through an OBDC
connection? I would like to replicate the schema from an Access 97
database, then be able to forward engineer to PostgreSQL and other
databases.
If Druid can't reverse engineer, can another open source tool do the
job?
Thanks
Lots of great conversation here. Thanks to all for participating.
David, you wrote:
Be aware that Pascal, along with Date and Darwen, are...how do I put
this gently...cranks. They've been getting more strident and
irrational as the decades go by.
I can't speak to that statement directly.
Bjørn T Johansen wrote:
Yes, that is annoying But you can remove the legend by right clicking on
the name of
the ER and choosing Properties.. Under Legend, you can change Location to
None;
that will remove it...
Thanks Bjorn. I'll give that a try. Hopefully that will be turned off
by
I have used Case Studio 2 (fine, weak on documentation generation), and
PowerDesigner by Sybase (truly excellent! but $$$)
John
Thanks John.
I've been playing with Druid and it seems to be able to do what I need
it to do. It wasn't immediately intuitive to use, but the functionality
is there.
I'm reading, and enjoying immensely, Fabial Pascal's book Practical
Issues in Database Management.
Though I've just gotten started with the book, he seems to be saying
that modern RDBMSs aren't as faithful to relational theory as they
ought to be, and that this has many *practical* consequences,
If one decides to use a composite key, beyond how many attributes
should one seriously consider creating a surrogate key instead? 4? 5?
Less? I have seen a composite key composed of 5 attributes and thought
- why? What's the value over a surrogate key?
I guess choosing a candidate key (presuming
In the book Practical Issues in Database Management, Fabian Pascal
notes three reasons for choosing one PK over another - familiarity,
stability, and simplicity.
He notes further that those influenced by OO db design tend to use
simple, surrogate keys for all PKs in all databases they design;
Bjørn T Johansen wrote:
Have you tried Druid (http://druid.sourceforge.net/index.html) ?
It does anything a good ERD designer do and it's free...
Thanks Bjorn. I have downloaded it but not tested it yet. I will test
it in the next few days. DIA doesn't seem like a good choice.
Did somebody say
What about OpenOffice Draw 2.0? Can this do ER / UML diagrams that one
can then use to forward engineer DDL statements?
How does DIA compare to Draw, and wouldn't it be better to roll DIA
into OpenOffice? I love OpenOffice and use it as an MS Word / MS Excel
replacement. Works great, since it can
tedia2sql for DIA seems pretty strange, in that it seems to require you
to use UML diagrams, rather than ER Diagrams, to forward engineer a
database - e.g. output DDL statements.
Am I misreading what tedia2sql does, or is does one have to use
repurpose UML diagrams to get DDL statements created?
Thanks for all the great suggestions.
Dana
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
Anyone here used both DIA and schema export extensions for it as well
as the Eclipse ERD plug-in for creating and exporting schemas - I mean
outputting DDL statements in PostgreSQL? Or Druid?
Which do you like best and why?
Thanks.
---(end of
Thanks Thomas. That's too bad about DB Designer. I didn't realize it
had been abandoned.
What do y'all think of DIA?
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Anyone know if DIA will generate CREATE TABLE statements from an ER
diagram?
I'd like to have a program where I can create my db design, then be
able to instantiate the design in PostgreSQL as well as MySQL.
I'll pay for a good commercial tool if it costs less than USD $100.
Thanks.
Thanks. What about DIA - http://www.gnome.org/projects/dia/
...or DB Designer - http://fabforce.net/dbdesigner4/ (this one claims
to be feature-equivalent, or in the sphere of, products like Oracle's
Designer, ERWin, and Rational Rose.
---(end of
What open source tool do people here like for creating ER diagrams?
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
20 matches
Mail list logo