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
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
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
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 broadcast)---
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 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 broadcast)--
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?
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 sa
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
> 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 ther
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 t
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; th
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. Indi
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
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
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 insta
'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 null
20 matches
Mail list logo
