dbTalk Databases Forums  

[NOVICE] Linux DB designer tools

mailing.database.pgsql-novice mailing.database.pgsql-novice


Discuss [NOVICE] Linux DB designer tools in the mailing.database.pgsql-novice forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Zouari Fourat
 
Posts: n/a

Default [NOVICE] Linux DB designer tools - 11-23-2005 , 11:52 AM






Hello,
Am seeking for a reliable PGSQL DB Designer wich will be :
1.GPL
2.Good gui
3.Work under linux
4.export model to sql code
5.optionally do reverse engeneering by importing a model from the sql code

Something like DBDesigner4 for MySQL
What's your suggestions ?

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Reply With Quote
  #2  
Old   
Andreas Kretschmer
 
Posts: n/a

Default Re: [NOVICE] Linux DB designer tools - 11-23-2005 , 12:14 PM






Zouari Fourat <fourat (AT) gmail (DOT) com> schrieb:

Quote:
Hello,
Am seeking for a reliable PGSQL DB Designer wich will be :
1.GPL
2.Good gui
3.Work under linux
4.export model to sql code
5.optionally do reverse engeneering by importing a model from the sql code
Paper, pencil and brain ;-)


Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings


Reply With Quote
  #3  
Old   
Roland Giesler
 
Posts: n/a

Default Re: [NOVICE] Linux DB designer tools - 11-23-2005 , 01:12 PM



Zouari Fourat wrote:
Quote:
Hello,
Am seeking for a reliable PGSQL DB Designer wich will be :
1.GPL
2.Good gui
3.Work under linux
4.export model to sql code
5.optionally do reverse engeneering by importing a model from the sql
code
Try Druid. It runs on Java, so the if you use Sun JRE it's not GPL, but the
rest is. At least Druid is. And it works great.
http://druid.sourceforge.net/

I tried many others, but now use a combination of PGAdminIII and Druid.
Druid is growing still, but very functional and has some powerful generating
tools.

Roland



---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq


Reply With Quote
  #4  
Old   
Andrej Ricnik-Bay
 
Posts: n/a

Default Re: [NOVICE] Linux DB designer tools - 11-23-2005 , 02:41 PM



Quote:
Hello,
Am seeking for a reliable PGSQL DB Designer wich will be :
1.GPL
2.Good gui
3.Work under linux
4.export model to sql code
5.optionally do reverse engeneering by importing a model from the sql code

Something like DBDesigner4 for MySQL
What's your suggestions ?
You could also have a look at dia, with
http://sourceforge.net/project/showf...package_id=3D=
94349&release_id=3D371714
or
http://www.nocternity.net/index.php/...es?langage=3DC
you can then create a DB from a UML schema.


Cheers,
Andrej

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly


Reply With Quote
  #5  
Old   
Sebastian Scarano
 
Posts: n/a

Default Re: [NOVICE] Linux DB designer tools - 11-23-2005 , 07:35 PM



Hey, count me on with that question too.

Basicaly what I'm looking for is a produt eith the same functionality
as Microsoft Enterprise manager.

So far now, what I've found that comes close to what I'm looking for
is Aqua Data Studio 4.5 (http://www.aquafold.com/index.html)

It's not GPL (not even opensource) but it's free for educational
institutions and personal use (OK, I know it's not the same thing...)

The only thing missing is the ability to change the order of the
columns of a table...

So I'd be glad to hear about some GPL tool that can do the job.

Saludos

Sas

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

Reply With Quote
  #6  
Old   
dawizz
 
Posts: n/a

Default Re: [NOVICE] Linux DB designer tools - 11-24-2005 , 12:46 AM



Hi,

When I was looking for such a tool I found kpogre, it has a
tree view for browsing through youre server, and 10 SQL tabs
for editing. A nice thing is thta youre commands, lets say to drop a function,
will be shown in a SQl window before execution.

See:

http://kpogre.sourceforge.net/

..

On Thursday 24 November 2005 02:34, Sebastian Scarano wrote:
Quote:
Hey, count me on with that question too.

Basicaly what I'm looking for is a produt eith the same functionality
as Microsoft Enterprise manager.

So far now, what I've found that comes close to what I'm looking for
is Aqua Data Studio 4.5 (http://www.aquafold.com/index.html)

It's not GPL (not even opensource) but it's free for educational
institutions and personal use (OK, I know it's not the same thing...)

The only thing missing is the ability to change the order of the
columns of a table...

So I'd be glad to hear about some GPL tool that can do the job.

Saludos

Sas

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.