Rudi,
> I'll be using smaller tables with appropriate join tables and PHP.
> Just for interests sake I'll be using Dia to plan the schema.
> I prefer to use the UML drawing tools instead of the ER ones.
I still use a simple flowcharting program to plan my databases. Never
saw the value in UML
On Tuesday 24 June 2003 03:15 pm, Rudi Starcevic wrote:
> I'll be using smaller tables with appropriate join tables and PHP.
> Just for interests sake I'll be using Dia to plan the schema.
> I prefer to use the UML drawing tools instead of the ER ones.
Off topic, but if you're using KDE you might
Josh, Jonathan ..
Thanks for your replies.
You mail was exactly what I was hoping for - your best practise opinion.
I do have a grasp of the theory involved with SQL but your input on
those 'other' constraints like time, language, longevity etc was just
what I was interested in.
I'll be using sm
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Monday 23 June 2003 22:19, Rudi Starcevic wrote:
> I"m not sure whether to have on larger table or 2 smaller one with a
> join table.
Theory says you are better off with the join tables. Practical reality agrees
with this. It takes a bit more work
Rudi,
> For this task, a searchable directory, which design would be better.
> In know the second is more flexible as new features can be added but I
> have very limited time and
> I think the one larger table design would be quicker to build.
Sounds like you already have a clear grasp of the sit
Hi,
Sorry - I make some typo's - here is the question again.
I have a Spread Sheet which I need to make a searchable directory out
of.
I'm in two minds on a couple things so I thought I'd ask.
I"m not sure whether to have on larger table or 2 smaller one with a
join table.
This is a trim
Hi,
I have a Spread Sheet which I need to make a searchable directory out of.
I'm in two minds on a couple things so I thought I'd ask.
I"m not sure whether to have on larger table or 2 smaller one with a
join table.
This is a trimmed down version of the data.
The directory is of Camping grounds/
Well, actually ERWin does work with PostgreSQL via ODBC. The version I
tried was I think the last release of the 3.x series, and I had enough
trouble with it to decide against using it. I am told the 4.x series
improved things, though if your already familiar with erwin you probably
could get by.
Title: RE: [GENERAL] [SQL] Database Design tool
I had gASQL working once but that was awhile ago. gASQL has now been renamed as Mergeant and is being developed in conjunction with the gnome-db libraries as far as I know. I don't think there has been a stable release of it yet, although
On Tue, 2002-11-05 at 15:00, Thomas Good wrote:
> Is there a page at PostgreSQL.org where all these links are listed?
> I've been saving each bit of mail that goes by on this thread...but
> a page on Pg would be very nice. ;-)
you mean like techdocs.postgresql.org ???
The page that is mentionn
> Thanks. This gives me a few more tools to look at. Boy, do we have an
> answer for the folks who complain "there are no GUI tools for Postgres".
While there are a number of GUI tools for PostgreSQL, there's still no real
database design tool like ErWin or so.
--
Kaare Rasmussen
Robert,
> There are actually two sections on the techdocs site now relating to
> this at http://techdocs.postgresql.org/oresources.php
> look under the sections ERD Tools and Database Design
>
> Not that I'm not looking forward to your article Josh ;-)
Thanks. This gives me a few more tools to
There are actually two sections on the techdocs site now relating to
this at http://techdocs.postgresql.org/oresources.php
look under the sections ERD Tools and Database Design
Not that I'm not looking forward to your article Josh ;-)
Robert Treat
On Tue, 2002-11-05 at 11:33, Josh Berkus wrote:
Thomas,
> > DBVisualizer is pretty good.
>
> Is there a page at PostgreSQL.org where all these links are listed?
> I've been saving each bit of mail that goes by on this thread...but
> a page on Pg would be very nice. ;-)
I was planning on writing an article; so far, I have a list of about 14
i
On Tue, 5 Nov 2002, Michael Ansley (UK) wrote:
> DBVisualizer is pretty good.
Is there a page at PostgreSQL.org where all these links are listed?
I've been saving each bit of mail that goes by on this thread...but
a page on Pg would be very nice. ;-)
Cheers,
Title: RE: [GENERAL] [SQL] Database Design tool
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
DBVisualizer is pretty good.
>> -Original Message-
>> From: Johannes Lochmann [mailto:[EMAIL PROTECTED]]
>> Sent: 30 October 2002 14:36
>> To: [EMAIL PROT
g]On Behalf Of Dan Hrabarchuk
> > Sent: Wednesday, October 30, 2002 7:31 AM
> > To: Johannes Lochmann
> > Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> > Subject: Re: [GENERAL] [SQL] Database Design tool
> >
> >
> > gASQL is a gnome-db client that looks like it ha
On Wed, 30 Oct 2002 14:35:23 + (UTC), [EMAIL PROTECTED]
(Johannes Lochmann) wrote:
>> Can anybody take me reference on Database design tool with PostgreSQL
>> support.
You can use PowerDesigner from Sybase. Windows only. A fully
functional trial version (45 days) is downloadable at www.sybas
Wei,
> Do you have any idea of what the software is called? I could only find
> the redhat database ISO for download.
Announced on PGSQL-ANNOUNCE a couple of weeks ago:
(if you're not subscribed to PGSQL-ANNOUNCE, you should be)
===
The Red Hat
Josh:
Do you have any idea of what the software is called? I could only find
the redhat database ISO for download.
Thanks
On Wed, 2002-10-30 at 18:43, Josh Berkus wrote:
> Wei,
>
> > My colleague installed a redhat database 2(which is based on postgresql)
> > onto his redhat 7.3 machine and it
Wei,
> My colleague installed a redhat database 2(which is based on postgresql)
> onto his redhat 7.3 machine and it came with a very nice java query
> analyzer tool. It is sort of like the query analyzer in MS SQL Server
> with the graphical output of the execution plan, quite intuitive.
>
> I w
My colleague installed a redhat database 2(which is based on postgresql)
onto his redhat 7.3 machine and it came with a very nice java query
analyzer tool. It is sort of like the query analyzer in MS SQL Server
with the graphical output of the execution plan, quite intuitive.
I wonder if I can fin
Dan,
I use Xpga Java Postgresql client and it is awesome.
It's at http://www.kazak.ws/xpg/
Kevin
On Wed, 2002-10-30 at 10:30, Dan Hrabarchuk wrote:
> gASQL is a gnome-db client that looks like it has a lot of promise. The
> only problem is I've never been able to get the application to run
gASQL is a gnome-db client that looks like it has a lot of promise. The
only problem is I've never been able to get the application to run
properly. I'm using RedHat 8.0 on my desktop. The last official version
does not install properly. If I grab a CVS copy, I go through dependency
hell. Has anyon
On Wed, 2002-10-30 at 07:45, Viacheslav N Tararin wrote:
Hi,
(which list should this go to? I guess it is OT on both...)
> Can anybody take me reference on Database design tool with PostgreSQL
> support.
Dia and dia2sql (or something similar...) Google knows more :-)
HTH
Johannes Lochmann
Uz.ytkownik Viacheslav N Tararin napisa?:
Hi.
Can anybody take me reference on Database design tool with PostgreSQL
support.
pgadmin.postgresql.org
Tomasz Myrta
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
> Can anybody take me reference on Database design tool with PostgreSQL
> support.
>
visit, http://sourceforge.net/projects/phppgadmin/
regards,
bhuvaneswaran
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives
Hi.
Can anybody take me reference on Database design tool with PostgreSQL
support.
thanks.
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: [SQL] Database Design Question
OK... Fair Enough... Good Points indeed y'all.
Well... What about the problem of users trying to Query the Database??
You know... like when using Crystal Reports or something?.
SELECT * from Histor
-
From: Gonzo Rock [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 27, 2001 2:03 PM
To: [EMAIL PROTECTED]
Subject: [SQL] Database Design Question
A Question for those of you who consider yourself crack Database Designers.
I am currently moving a large database(100+Tables) into pgSQL... with the
in
A Question for those of you who consider yourself crack Database Designers.
I am currently moving a large database(100+Tables) into pgSQL... with the intention of
deploying against 'any' SQL database in the future. The development side will be
rigorously using Standard SQL constructs with no un
> "Francisco Hernandez" <[EMAIL PROTECTED]>
>
> > anyone know of a good book or books on database modeling?
> > like for entity relationship diagrams and such..
>
>
> To get a good life, go with Chris Date's rather difficult two
> volume set.
>
What are the names of these two books? I just
"Francisco Hernandez" <[EMAIL PROTECTED]>
> anyone know of a good book or books on database modeling?
> like for entity relationship diagrams and such..
To get a good life, go with Chris Date's rather difficult two volume set.
-dlj.
anyone know of a good book or books on database modeling?
like for entity relationship diagrams and such..
thanks!
34 matches
Mail list logo
