Postgres and Tools Intro?

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

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

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

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.

--- 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

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

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