Thread: Postgres and Tools Intro?

Postgres and Tools Intro?

From
Randy Yates
Date:
This has probably been asked before so please be gracious. I
have looked on the postgres site and didn't find anything
"satisfying."

Is there *good* overview of postgres and associated utilities?
--
%  Randy Yates                  % "Remember the good old 1980's, when
%% Fuquay-Varina, NC            %  things were so uncomplicated?"
%%% 919-577-9882                % 'Ticket To The Moon'
%%%% <yates@ieee.org>           % *Time*, Electric Light Orchestra
http://home.earthlink.net/~yatescr

Re: Postgres and Tools Intro?

From
Richard Huxton
Date:
Randy Yates wrote:
> This has probably been asked before so please be gracious. I
> have looked on the postgres site and didn't find anything
> "satisfying."
>
> Is there *good* overview of postgres and associated utilities?

Hmm - not for the family as a whole. Part of the problem is that there
are quite a few add-on tools. The postgresql.org docs cover the database
quite well - between the reference manuals and the FAQ it gives a good
picture.

What particular aspects are you interested in? I'm sure we can find
people who can help.

--
   Richard Huxton
   Archonet Ltd

Re: Postgres and Tools Intro?

From
Randy Yates
Date:
Richard Huxton <dev@archonet.com> writes:

> Randy Yates wrote:
>> This has probably been asked before so please be gracious. I
>> have looked on the postgres site and didn't find anything
>> "satisfying."
>> Is there *good* overview of postgres and associated utilities?
>
> Hmm - not for the family as a whole. Part of the problem is that there
> are quite a few add-on tools. The postgresql.org docs cover the
> database quite well - between the reference manuals and the FAQ it
> gives a good picture.
>
> What particular aspects are you interested in? I'm sure we can find
> people who can help.

PS: Is there a tool for converting MS Access forms and reports into
HTML/postgres?
--
%  Randy Yates                  % "Rollin' and riding and slippin' and
%% Fuquay-Varina, NC            %  sliding, it's magic."
%%% 919-577-9882                %
%%%% <yates@ieee.org>           % 'Living' Thing', *A New World Record*, ELO
http://home.earthlink.net/~yatescr


Re: Postgres and Tools Intro?

From
Randy Yates
Date:
Hi Richard,

Thanks for writing. Basically I'd like to know what the core
applications/tools are and what some of the other more exotic tools
are. For example, pgadmin looks like it's gone through a bazillion
versions. Which is the latest/greatest?  What exactly does it do?

If I want to connect to postgres securely from a remote location
over the net, what are my options? Is that part of the postgres
ODBC driver, or is another layer required for the security part?

Why should or shouldn't I use ODBC for connecting remotely?

More in the exotic territory, are there tools for translating database
schemas (I would like to move my MS Access database into postgres)?
Is there a tool for converting a postgres query or table into an
MS Access .mdb file? This would be very useful, the scenario being
that the "big" database resides in postgres on a remote server with
a browser interface, but users can download "snippets" of data (or maybe
even the whole tamale) in Access format to their local machines.

Got any suggestions?

--Randy

Richard Huxton <dev@archonet.com> writes:

> Randy Yates wrote:
>> This has probably been asked before so please be gracious. I
>> have looked on the postgres site and didn't find anything
>> "satisfying."
>> Is there *good* overview of postgres and associated utilities?
>
> Hmm - not for the family as a whole. Part of the problem is that there
> are quite a few add-on tools. The postgresql.org docs cover the
> database quite well - between the reference manuals and the FAQ it
> gives a good picture.
>
> What particular aspects are you interested in? I'm sure we can find
> people who can help.
>
> --
>    Richard Huxton
>    Archonet Ltd
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
>

--
%  Randy Yates                  % "Maybe one day I'll feel her cold embrace,
%% Fuquay-Varina, NC            %                    and kiss her interface,
%%% 919-577-9882                %            til then, I'll leave her alone."
%%%% <yates@ieee.org>           %        'Yours Truly, 2095', *Time*, ELO
http://home.earthlink.net/~yatescr


Re: Postgres and Tools Intro?

From
"Scott Marlowe"
Date:
On Fri, 2004-08-06 at 06:03, Randy Yates wrote:
> Richard Huxton <dev@archonet.com> writes:
>
> > Randy Yates wrote:
> >> This has probably been asked before so please be gracious. I
> >> have looked on the postgres site and didn't find anything
> >> "satisfying."
> >> Is there *good* overview of postgres and associated utilities?
> >
> > Hmm - not for the family as a whole. Part of the problem is that there
> > are quite a few add-on tools. The postgresql.org docs cover the
> > database quite well - between the reference manuals and the FAQ it
> > gives a good picture.
> >
> > What particular aspects are you interested in? I'm sure we can find
> > people who can help.
>
> PS: Is there a tool for converting MS Access forms and reports into
> HTML/postgres?

The only working one I've run across recently is my brain.  :-)
Seriously, PHP/PostgreSQL tend to be a bit too loosely coupled to have
such a complete "kitchen sync" type application yet.

There are many classes for perl, php, or any other web app language
found on Linux/BSD to do things like db access, form creation and
validation, etc...  You just have to pick the pieces you like best.

I've always made them by hand, and there are some nice examples out
there on the web of doing it a bit more low level.


Re: Postgres and Tools Intro?

From
Jeff Eckermann
Date:
--- Randy Yates <yates@ieee.org> wrote:

> Hi Richard,
>
> Thanks for writing. Basically I'd like to know what
> the core
> applications/tools are and what some of the other
> more exotic tools
> are. For example, pgadmin looks like it's gone
> through a bazillion
> versions. Which is the latest/greatest?  What
> exactly does it do?

PgAdminIII is the latest.  It is a graphical
interface, especially useful for database
administration and development.  Many people use it
and are happy.

>
> If I want to connect to postgres securely from a
> remote location
> over the net, what are my options? Is that part of
> the postgres
> ODBC driver, or is another layer required for the
> security part?

You can use SSL with ODBC, but it requires a bit of
fiddling about.  Search the archives for information
about that.

>
> Why should or shouldn't I use ODBC for connecting
> remotely?

ODBC is working fine for lots of people right now.
The other mature interfaces include libpq (C) and JDBC
(Java).  There are others which reportedly work well.
It all depends on your choice of development platform.

>
> More in the exotic territory, are there tools for
> translating database
> schemas (I would like to move my MS Access database
> into postgres)?

PgAdminII (the previous version) had a plugin
"Database Migration Wizard".  I have kept my PgAdminII
installation just because of this.  I am very happy
with the results I have had translating MS Access
databases to PostgreSQL by using that Wizard.

> Is there a tool for converting a postgres query or
> table into an
> MS Access .mdb file? This would be very useful, the
> scenario being
> that the "big" database resides in postgres on a
> remote server with
> a browser interface, but users can download
> "snippets" of data (or maybe
> even the whole tamale) in Access format to their
> local machines.

No such tool exists that I know of.  You could do it
in code from an existing .mdb file, e.g. something
that runs when the file is opened.

>
> Got any suggestions?
>
> --Randy
>
> Richard Huxton <dev@archonet.com> writes:
>
> > Randy Yates wrote:
> >> This has probably been asked before so please be
> gracious. I
> >> have looked on the postgres site and didn't find
> anything
> >> "satisfying."
> >> Is there *good* overview of postgres and
> associated utilities?
> >
> > Hmm - not for the family as a whole. Part of the
> problem is that there
> > are quite a few add-on tools. The postgresql.org
> docs cover the
> > database quite well - between the reference
> manuals and the FAQ it
> > gives a good picture.
> >
> > What particular aspects are you interested in? I'm
> sure we can find
> > people who can help.
> >
> > --
> >    Richard Huxton
> >    Archonet Ltd
> >
> > ---------------------------(end of
> broadcast)---------------------------
> > TIP 1: subscribe and unsubscribe commands go to
> majordomo@postgresql.org
> >
> >
>
> --
> %  Randy Yates                  % "Maybe one day
> I'll feel her cold embrace,
> %% Fuquay-Varina, NC            %
> and kiss her interface,
> %%% 919-577-9882                %            til
> then, I'll leave her alone."
> %%%% <yates@ieee.org>           %        'Yours
> Truly, 2095', *Time*, ELO
> http://home.earthlink.net/~yatescr
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>                http://archives.postgresql.org
>




_______________________________
Do you Yahoo!?
Express yourself with Y! Messenger! Free. Download now.
http://messenger.yahoo.com

Re: Postgres and Tools Intro?

From
Gaetano Mendola
Date:
Jeff Eckermann wrote:
> PgAdminII (the previous version) had a plugin
> "Database Migration Wizard".  I have kept my PgAdminII
> installation just because of this.  I am very happy
> with the results I have had translating MS Access
> databases to PostgreSQL by using that Wizard.

And also is usefull the function that redirect the output
of a query in an excell sheet.




Regards
Gaetano Mendola



Re: Postgres and Tools Intro?

From
Randy Yates
Date:
Hi Jeff,

THANKS for the pointers - much appreciated!

--Randy

Jeff Eckermann <jeff_eckermann@yahoo.com> writes:

> --- Randy Yates <yates@ieee.org> wrote:
>
>> Hi Richard,
>>
>> Thanks for writing. Basically I'd like to know what
>> the core
>> applications/tools are and what some of the other
>> more exotic tools
>> are. For example, pgadmin looks like it's gone
>> through a bazillion
>> versions. Which is the latest/greatest?  What
>> exactly does it do?
>
> PgAdminIII is the latest.  It is a graphical
> interface, especially useful for database
> administration and development.  Many people use it
> and are happy.
>
>>
>> If I want to connect to postgres securely from a
>> remote location
>> over the net, what are my options? Is that part of
>> the postgres
>> ODBC driver, or is another layer required for the
>> security part?
>
> You can use SSL with ODBC, but it requires a bit of
> fiddling about.  Search the archives for information
> about that.
>
>>
>> Why should or shouldn't I use ODBC for connecting
>> remotely?
>
> ODBC is working fine for lots of people right now.
> The other mature interfaces include libpq (C) and JDBC
> (Java).  There are others which reportedly work well.
> It all depends on your choice of development platform.
>
>>
>> More in the exotic territory, are there tools for
>> translating database
>> schemas (I would like to move my MS Access database
>> into postgres)?
>
> PgAdminII (the previous version) had a plugin
> "Database Migration Wizard".  I have kept my PgAdminII
> installation just because of this.  I am very happy
> with the results I have had translating MS Access
> databases to PostgreSQL by using that Wizard.
>
>> Is there a tool for converting a postgres query or
>> table into an
>> MS Access .mdb file? This would be very useful, the
>> scenario being
>> that the "big" database resides in postgres on a
>> remote server with
>> a browser interface, but users can download
>> "snippets" of data (or maybe
>> even the whole tamale) in Access format to their
>> local machines.
>
> No such tool exists that I know of.  You could do it
> in code from an existing .mdb file, e.g. something
> that runs when the file is opened.
>
>>
>> Got any suggestions?
>>
>> --Randy
>>
>> Richard Huxton <dev@archonet.com> writes:
>>
>> > Randy Yates wrote:
>> >> This has probably been asked before so please be
>> gracious. I
>> >> have looked on the postgres site and didn't find
>> anything
>> >> "satisfying."
>> >> Is there *good* overview of postgres and
>> associated utilities?
>> >
>> > Hmm - not for the family as a whole. Part of the
>> problem is that there
>> > are quite a few add-on tools. The postgresql.org
>> docs cover the
>> > database quite well - between the reference
>> manuals and the FAQ it
>> > gives a good picture.
>> >
>> > What particular aspects are you interested in? I'm
>> sure we can find
>> > people who can help.
>> >
>> > --
>> >    Richard Huxton
>> >    Archonet Ltd
>> >
>> > ---------------------------(end of
>> broadcast)---------------------------
>> > TIP 1: subscribe and unsubscribe commands go to
>> majordomo@postgresql.org
>> >
>> >
>>
>> --
>> %  Randy Yates                  % "Maybe one day
>> I'll feel her cold embrace,
>> %% Fuquay-Varina, NC            %
>> and kiss her interface,
>> %%% 919-577-9882                %            til
>> then, I'll leave her alone."
>> %%%% <yates@ieee.org>           %        'Yours
>> Truly, 2095', *Time*, ELO
>> http://home.earthlink.net/~yatescr
>>
>>
>> ---------------------------(end of
>> broadcast)---------------------------
>> TIP 6: Have you searched our list archives?
>>
>>                http://archives.postgresql.org
>>
>
>
>
>
> _______________________________
> Do you Yahoo!?
> Express yourself with Y! Messenger! Free. Download now.
> http://messenger.yahoo.com
>

--
%  Randy Yates                  % "Rollin' and riding and slippin' and
%% Fuquay-Varina, NC            %  sliding, it's magic."
%%% 919-577-9882                %
%%%% <yates@ieee.org>           % 'Living' Thing', *A New World Record*, ELO
http://home.earthlink.net/~yatescr