Thread: Tool for modeling

Hi guys,

Which tool do you recommend for modeling pg database? I'm using Aqua Data Studio, and it has a good and friendly UI and its ER it's quite well too, but it's paid and besides of design of it, it still has a lot of things to improve like, specially with E/R Diagram. I also had some problem with views with case it didnt accepted the syntax but when I executed it created the view anyway

I see also the squirrel, but when I didn't like it very much at first, but I'm intending to take a deeper look at it.

pgAdmin, I really like this one, but I just miss an E/R modeling tool in it. If it had something like that definitly I'd use 100% of time.

And you guys any tool to suggest? specially Open Source?

Luiz Eduardo Cantanhede Neri wrote on 25.05.2009 12:44:
> Hi guys,
>
> Which tool do you recommend for modeling pg database? I'm using Aqua
> Data Studio, and it has a good and friendly UI and its ER it's quite
> well too, but it's paid and besides of design of it, it still has a lot
> of things to improve like, specially with E/R Diagram. I also had some
> problem with views with case it didnt accepted the syntax but when I
> executed it created the view anyway
>
[...]
>
> And you guys any tool to suggest? specially Open Source?

Try out Power*Architect.

It is free and quite good although not (yet) complete though.

http://www.sqlpower.ca/page/architect

Thomas

Thomas Kellerer wrote:
> Luiz Eduardo Cantanhede Neri wrote on 25.05.2009 12:44:
>> Hi guys,
>>
>> Which tool do you recommend for modeling pg database? I'm using Aqua
>> Data Studio, and it has a good and friendly UI and its ER it's quite
>> well too, but it's paid and besides of design of it, it still has a
>> lot of things to improve like, specially with E/R Diagram. I also had
>> some problem with views with case it didnt accepted the syntax but
>> when I executed it created the view anyway
>>
> [...]
>>
>> And you guys any tool to suggest? specially Open Source?
>
> Try out Power*Architect.
>
> It is free and quite good although not (yet) complete though.
>
> http://www.sqlpower.ca/page/architect

As a developer who used to work with MySQL, I got used to DBDesigner. I
find it to be very intuitive, easy to use, and free.

However, it has two serious shortcomings:

1. It is not developed anymore. It is replaced with MySQL Workbench,
witch I personally don't like.
2. It works only with MySQL, so my team uses a Java tool which reads
DBDesigner files (old school XML) and generates DDL.

Regards,
Ognjen

So from what I realize from this topic is that we miss a professional tool to deal with ERD

Luiz Eduardo Cantanhede Neri wrote on 26.05.2009 16:26:
> So from what I realize from this topic is that we miss a professional
> tool to deal with ERD

As I said: try out Power*Architect.

It might have some shortcomings, but I can live with them (especially at that price)

Thomas

Thanks for the Power*Architect tip (there is even a version for the Mac).  The drag-and-drop reverse engineering feature is very nice.  The only problem was testing a new database connection -- if you get it wrong it hangs up, rather than giving you an error message -- but once you leap that hurdle it works just fine.

Regards,
Dennis Clark




--
Dennis M. Clark
OSS Analyst
http://www.nexb.com
http://www.EasyEclipse.org

Dennis Clark wrote on 27.05.2009 01:52:
> The only problem was testing a new database connection -- if you get it
> wrong it hangs up, rather than giving you an error message -- but once
> you leap that hurdle it works just fine.
Hmm. Must be a Mac problem, because it get a proper error message if something
is wrong in the connection setup.

But do post this to the Power*Architect forum. The guys there are very
responsive are are surely interested in problems like that.

Thomas

Hi Guys,

I have never done, not even sure how Database MetaData look like!
I am expected to compile a DatabaseMetaData. I have created a database
with 5 tables that is in 1NF so as to permit data to be queried and
manipulated.
Can anyone help?


--
Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice

Mohlomi Moloi wrote:
> I have never done, not even sure how Database MetaData look like!
> I am expected to compile a DatabaseMetaData. I have created a database
> with 5 tables that is in 1NF so as to permit data to be queried and
> manipulated.
> Can anyone help?

It is not clear form your message what are you trying to do. Are you
talking about Java interface java.sql.DatabaseMetaData? Do you need to
implement that interface?

You should write in more details if you expect help on the mailing list.

Read this first: http://catb.org/esr/faqs/smart-questions.html

Regards,
Ognjen

Hi Mohlomi,

It's maybe just me, but it is very hard to understand from your messages
what are you trying to do, and what is the problem. Try reading the
document I sent you, and try to be more specific with the description of
your problem.

Regards,
Ognjen



Mohlomi Moloi wrote:
> Hi Ognjen,
>
>
>
> I'll try and give detail, just that I have not seen or done one.
>
> However the interface is TELEForm (it use the capture ability of taking
> a set of images, organize them into documents, and then export the
> documents along with index). It exports to a posgreSQL database. So I'm
> just seeking a *Database* MetaData only.
>
>
>
> Warm regards,
>
>
>
> Mohlomi
>
>
>
>
>
> -----Original Message-----
> From: Ognjen Blagojevic [mailto:ognjen@etf.bg.ac.yu]
> Sent: 02 June 2009 12:06
> To: pgsql-novice@postgresql.org
> Subject: Re: [NOVICE] DatabaseMetaData
>
>
>
> Mohlomi Moloi wrote:
>
>>  I have never done, not even sure how Database MetaData look like!
>
>>  I am expected to compile a DatabaseMetaData. I have created a database
>
>>  with 5 tables that is in 1NF so as to permit data to be queried and
>
>>  manipulated.
>
>>  Can anyone help?
>
>
>
> It is not clear form your message what are you trying to do. Are you
>
> talking about Java interface java.sql.DatabaseMetaData? Do you need to
>
> implement that interface?
>
>
>
> You should write in more details if you expect help on the mailing list.
>
>
>
> Read this first: http://catb.org/esr/faqs/smart-questions.html
>
>
>
> Regards,
>
> Ognjen
>
>
>
> --
>
> Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
>
> To make changes to your subscription:
>
> http://www.postgresql.org/mailpref/pgsql-novice
>
>
>

Hi, I managed to compile my DatabaseMetaData!!! I now know about it...


-----Original Message-----
From: Ognjen Blagojevic [mailto:ognjen@etf.bg.ac.yu]
Sent: 02 June 2009 12:06
To: pgsql-novice@postgresql.org
Subject: Re: [NOVICE] DatabaseMetaData

Mohlomi Moloi wrote:
> I have never done, not even sure how Database MetaData look like!
> I am expected to compile a DatabaseMetaData. I have created a database

> with 5 tables that is in 1NF so as to permit data to be queried and
> manipulated.
> Can anyone help?

It is not clear form your message what are you trying to do. Are you
talking about Java interface java.sql.DatabaseMetaData? Do you need to
implement that interface?

You should write in more details if you expect help on the mailing list.

Read this first: http://catb.org/esr/faqs/smart-questions.html

Regards,
Ognjen

--
Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice