pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedEditor for pgsql
10+ messages / 6 participants
[nested] [flat]
* Editor for pgsql
@ 2002-07-22 12:36 Elielson Fontanezi <ElielsonF@prodam.sp.gov.br>
0 siblings, 2 replies; 10+ messages in thread
From: Elielson Fontanezi @ 2002-07-22 12:36 UTC (permalink / raw)
To: pgsql-sql; pgsql-general <pgsql-general@postgresql.org>
Hello Folks!
Maybe every DBA knows that there is a good shareware to editing
Oracle PL/SQL programs
named PL/SQL Developer.
I'd like to know if someone knows something near to this software
for Postgres pgSQL.
Thanks!
Elielson,
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Editor for pgsql
@ 2002-07-22 16:27 Josh Berkus <josh@agliodbs.com>
parent: Elielson Fontanezi <ElielsonF@prodam.sp.gov.br>
1 sibling, 1 reply; 10+ messages in thread
From: Josh Berkus @ 2002-07-22 16:27 UTC (permalink / raw)
To: Elielson Fontanezi <ElielsonF@prodam.sp.gov.br>; pgsql-sql
Elielson,
> Maybe every DBA knows that there is a good shareware to editing
> Oracle PL/SQL programs
> named PL/SQL Developer.
> I'd like to know if someone knows something near to this software
> for Postgres pgSQL.
No such program, currently.
PGAccess, slated for re-release with a overhaul and new version in
September, will have somewhat enhanced Function Editing ability.
However, nothing on the scale of PL/SQL Developer.
Me, I use Kate, an MDI text editor from the KDE crew, and CVS for
version control. Thanks, KDE guys! But, after 3 years of Postgres,
I'm pretty fluent in PL/pgSQL. I even double-quote without thinking
about it.
You might want to send an e-mail to ActiveState suggesting that they
could take on SQL script dialects (SQL, T-SQL, PL/SQL, PL/pgSQL and
4GL) as a new ActiveState IDE. Make sure they know you're willing to
pay for development software.
-Josh Berkus
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Editor for pgsql
@ 2002-07-22 20:09 James Orr <james@lrgmail.com>
parent: Josh Berkus <josh@agliodbs.com>
0 siblings, 2 replies; 10+ messages in thread
From: James Orr @ 2002-07-22 20:09 UTC (permalink / raw)
To: Josh Berkus <josh@agliodbs.com>; pgsql-sql
On Monday 22 July 2002 12:27 pm, Josh Berkus wrote:
> Me, I use Kate, an MDI text editor from the KDE crew, and CVS for
> version control. Thanks, KDE guys! But, after 3 years of Postgres,
> I'm pretty fluent in PL/pgSQL. I even double-quote without thinking
> about it.
How do you use CVS on your database? I recently started doing this, and i'm
wondering how other people handle it.
Basically I create a sql folder with three sub-folders tables, views and
functions. I have a file for each table in tables, each view in views and for
each trigger and/or function in functions.
For the actual editing? I'm a vi fan myself :). If i'm using the graphical
vim I can even do CVS operations with a custom menu.
- James
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Editor for pgsql
@ 2002-07-22 20:53 Josh Berkus <josh@agliodbs.com>
parent: James Orr <james@lrgmail.com>
1 sibling, 0 replies; 10+ messages in thread
From: Josh Berkus @ 2002-07-22 20:53 UTC (permalink / raw)
To: James Orr <james@lrgmail.com>; pgsql-sql
James,
> How do you use CVS on your database? I recently started doing this, and i'm
> wondering how other people handle it.
>
> Basically I create a sql folder with three sub-folders tables, views and
> functions. I have a file for each table in tables, each view in views and
for
> each trigger and/or function in functions.
Similar. I bundle my development scripts into related areas with a tabledef
and a couple of views or functions in each script, but otherwise I do the
same as you.
As for VIM, as an ex-Win32 developer with an art degree, I never mastered the
syntax of VI (or Emacs, for that matter). They're certainly powerful tools,
but I can never set aside the 2 weeks of downtime required to get up to speed
in either text editor.
So Kate and Joe are my friends. <grin>
--
-Josh Berkus
Aglio Database Solutions
San Francisco
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Editor for pgsql
@ 2002-07-22 23:07 Marc Spitzer <marc@oscar.eng.cv.net>
parent: James Orr <james@lrgmail.com>
1 sibling, 0 replies; 10+ messages in thread
From: Marc Spitzer @ 2002-07-22 23:07 UTC (permalink / raw)
To: pgsql-sql
On Mon, Jul 22, 2002 at 04:09:21PM -0400, James Orr wrote:
> On Monday 22 July 2002 12:27 pm, Josh Berkus wrote:
>
> > Me, I use Kate, an MDI text editor from the KDE crew, and CVS for
> > version control. Thanks, KDE guys! But, after 3 years of Postgres,
> > I'm pretty fluent in PL/pgSQL. I even double-quote without thinking
> > about it.
>
> How do you use CVS on your database? I recently started doing this, and i'm
> wondering how other people handle it.
>
> Basically I create a sql folder with three sub-folders tables, views
> and functions. I have a file for each table in tables, each view in
> views and for each trigger and/or function in functions.
>
> For the actual editing? I'm a vi fan myself :). If i'm using the graphical
> vim I can even do CVS operations with a custom menu.
>
> - James
James,
That sounds very ugly, I will usually have 1-4 files per db. Either
everything goes into 1 file, drops at the front then creates. Or
2 files, 1 for ddl( create/drop table) and another for plpgsql procedures
and triggers. Sometimes I will split each of those into a create and drop
file. But that is about as complex as I want it to get.
marc
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: [SQL] Editor for pgsql
@ 2002-07-22 23:32 Roberto Mello <rmello@cc.usu.edu>
parent: Elielson Fontanezi <ElielsonF@prodam.sp.gov.br>
1 sibling, 1 reply; 10+ messages in thread
From: Roberto Mello @ 2002-07-22 23:32 UTC (permalink / raw)
To: Elielson Fontanezi <ElielsonF@prodam.sp.gov.br>; +Cc: pgsql-sql; pgsql-general <pgsql-general@postgresql.org>
On Mon, Jul 22, 2002 at 09:36:54AM -0300, Elielson Fontanezi wrote:
> Hello Folks!
>
>
> Maybe every DBA knows that there is a good shareware to editing
> Oracle PL/SQL programs
> named PL/SQL Developer.
> I'd like to know if someone knows something near to this software
> for Postgres pgSQL.
Tora (tora.sf.net) has PL/SQL editing and supports PostgreSQL. Since
Pl/pgSQL is very similar to PL/SQL, you can use Tora for PL/pgSQL editing
very nicely.
Tora is an overall very nice database administration tool. I use it with
my Oracle and PostgreSQL installations all the time.
-Roberto
--
+----| http://fslc.usu.edu/ USU Free Software & GNU/Linux Club |------+
Roberto Mello - Computer Science, USU - http://www.brasileiro.net/
http://www.sdl.usu.edu/ - Space Dynamics Lab, Developer
Microsoft has been doing a really bad job on their OS - Linus Torvalds
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Editor for pgsql
@ 2002-07-23 00:41 Josh Berkus <josh@agliodbs.com>
parent: Roberto Mello <rmello@cc.usu.edu>
0 siblings, 1 reply; 10+ messages in thread
From: Josh Berkus @ 2002-07-23 00:41 UTC (permalink / raw)
To: Roberto Mello <rmello@cc.usu.edu>; Elielson Fontanezi <ElielsonF@prodam.sp.gov.br>; +Cc: pgsql-sql
Roberto,
> Tora (tora.sf.net) has PL/SQL editing and supports PostgreSQL. Since
> Pl/pgSQL is very similar to PL/SQL, you can use Tora for PL/pgSQL editing
> very nicely.
>
> Tora is an overall very nice database administration tool. I use it with
> my Oracle and PostgreSQL installations all the time.
I tried to install Tora, but the build blew up since I don't have Oracle
installed. Any tips?
--
-Josh Berkus
Aglio Database Solutions
San Francisco
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Editor for pgsql
@ 2002-07-23 05:45 Roberto Mello <rmello@cc.usu.edu>
parent: Josh Berkus <josh@agliodbs.com>
0 siblings, 1 reply; 10+ messages in thread
From: Roberto Mello @ 2002-07-23 05:45 UTC (permalink / raw)
To: Josh Berkus <josh@agliodbs.com>; +Cc: Elielson Fontanezi <ElielsonF@prodam.sp.gov.br>; pgsql-sql
On Mon, Jul 22, 2002 at 05:41:39PM -0700, Josh Berkus wrote:
>
> I tried to install Tora, but the build blew up since I don't have Oracle
> installed. Any tips?
I just use the Debian packages (/me hugs Debian).
AFAIK, all you have to do is compile with the appropriate flags so it
doesn't try to build Oracle support (you need a full Oracle installation),
and also MySQL support.
You also need to have the PostgreSQL loadable Qt 3 module installed before
compiling, plus Qt 3 headers and such.
You could try downloading the binary Debian packages from
packages.debian.org ("unstable" distribution) and unpacking them (Debian
packages are just "ar" packages with extra headers).
-Roberto
--
+----| http://fslc.usu.edu/ USU Free Software & GNU/Linux Club |------+
Roberto Mello - Computer Science, USU - http://www.brasileiro.net/
http://www.sdl.usu.edu/ - Space Dynamics Lab, Developer
Cannot open CATFOOD.CAN - Eat logitech mouse instead (Y/n)?
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Editor for pgsql
@ 2002-07-23 14:13 Andreas Joseph Krogh <andreak@officenet.no>
parent: Roberto Mello <rmello@cc.usu.edu>
0 siblings, 1 reply; 10+ messages in thread
From: Andreas Joseph Krogh @ 2002-07-23 14:13 UTC (permalink / raw)
To: pgsql-sql
On Tuesday 23 July 2002 07:45, Roberto Mello wrote:
> On Mon, Jul 22, 2002 at 05:41:39PM -0700, Josh Berkus wrote:
> > I tried to install Tora, but the build blew up since I don't have Oracle
> > installed. Any tips?
>
> I just use the Debian packages (/me hugs Debian).
>
> AFAIK, all you have to do is compile with the appropriate flags so it
> doesn't try to build Oracle support (you need a full Oracle installation),
> and also MySQL support.
>
> You also need to have the PostgreSQL loadable Qt 3 module installed before
> compiling, plus Qt 3 headers and such.
>
> You could try downloading the binary Debian packages from
> packages.debian.org ("unstable" distribution) and unpacking them (Debian
> packages are just "ar" packages with extra headers).
I just compiled the latest version(tora-1.3.6.1) right now(on Mandrake-8.1
with KDE-3.0.2 ant qt-3.0.4) with the following options to configure:
./configure --without-oracle --without-kde
make
su -c "make install"
This compiles and installes just fine to /usr/local/bin with PostgreSQL
support.
--
Andreas Joseph Krogh (Senior Software Developer) <andreak@officenet.no>
- There are 10 kinds of people in the world, those that can do binary
arithmetic and those that can't.
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Editor for pgsql
@ 2002-07-23 15:37 Josh Berkus <josh@agliodbs.com>
parent: Andreas Joseph Krogh <andreak@officenet.no>
0 siblings, 0 replies; 10+ messages in thread
From: Josh Berkus @ 2002-07-23 15:37 UTC (permalink / raw)
To: Andreas Joseph Krogh <andreak@officenet.no>; pgsql-sql
Folks,
> This compiles and installes just fine to /usr/local/bin with
> PostgreSQL
> support.
Thanks, I'll try it.
-Josh Berkus
^ permalink raw reply [nested|flat] 10+ messages in thread
end of thread, other threads:[~2002-07-23 15:37 UTC | newest]
Thread overview: 10+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-07-22 12:36 Editor for pgsql Elielson Fontanezi <ElielsonF@prodam.sp.gov.br>
2002-07-22 16:27 ` Josh Berkus <josh@agliodbs.com>
2002-07-22 20:09 ` James Orr <james@lrgmail.com>
2002-07-22 20:53 ` Josh Berkus <josh@agliodbs.com>
2002-07-22 23:07 ` Marc Spitzer <marc@oscar.eng.cv.net>
2002-07-22 23:32 ` Roberto Mello <rmello@cc.usu.edu>
2002-07-23 00:41 ` Josh Berkus <josh@agliodbs.com>
2002-07-23 05:45 ` Roberto Mello <rmello@cc.usu.edu>
2002-07-23 14:13 ` Andreas Joseph Krogh <andreak@officenet.no>
2002-07-23 15:37 ` Josh Berkus <josh@agliodbs.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox