Обсуждение: next steps

Hello,

I have set up a postgres installation on a freeBSD box and am now
ready to take the next steps.

Where can I find some Webpages with postgres applications or
sample.
How do I create a "user front end"/data input mask/menu system?
Can anyone point me to a webside to learn more about postgres
(tutorial)?

Learning lessons?

TIA
C.


--
Carsten Huettl - <http://www.ahorn-Net.de>
pgp-key on request

Carsten Huettl wrote:

> Hello,
>
> I have set up a postgres installation on a freeBSD box and am now
> ready to take the next steps.
>
> Where can I find some Webpages with postgres applications or
> sample.
> How do I create a "user front end"/data input mask/menu system?
> Can anyone point me to a webside to learn more about postgres
> (tutorial)?

We made a framework to build easily a web front end for a
postgres database. The framework is completely written in
Perl. It takes some 10  minutes for each table to define
the attribute and how they should be displayed in the browser.
Easy addition of all constraints (parent / child tables) to enforce referential
integrity and automatical lookups in parent is supported.

The framework is complete and documented(a real tutorial is missing).
If you are interested in that framework contact me.  We are
planning to license the framework under GPL. The framework
should be available on our website in the end of november and
hopefully in the CPAN archive.

Greetings Herbie

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Herbert Liechti                            E-Mail: Herbert.Liechti@thinx.ch
ThinX networked business services               Stahlrain 10, CH-5200 Brugg
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Carsten Huettl wrote:

Hello,

I have set up a postgres installation on a freeBSD box and am now
ready to take the next steps.

Where can I find some Webpages with postgres applications or
sample.
How do I create a "user front end"/data input mask/menu system?
Can anyone point me to a webside to learn more about postgres
(tutorial)?

Learning lessons?

TIA
C.
 

--
Carsten Huettl - <http://www.ahorn-Net.de>
pgp-key on request

************

First of all, read the manuals that should have been installed when you compiled the source. You should be able to find them in /usr/local/pgsql/doc, and they consist of

• PostgreSQL general text, the most up to date
• PostgreSQL Administrator's Guide
• PostgreSQL User's Guide
• PostgreSQL Programmer's Guide
• PostgreSQL Tutorial

If you want to write applications, I haven't the faintest idea what would be the best way to start.
Yesterday, I wrote a data input application in Tcl/Tk. It took me less than a day, but I am also still learning Tcl/Tk. I am now wresling with a browser window on the same data, which proves to be a whole lot thougher.
What I am about to say here, I don't like myself very much, but I think the fastest way to get started writing applications is using your BSD box as a server, run some MS OS, and use Delphi and ODBC to create your user applications. I don't know about much RAD tools for Un*x/Linux/FreeBSD, but what I have seen in Linux Journal is rather expensive. pgAccess 0.98 is nice to create and view tables, but there are still many things which need to be implemented.

Regards,

Jurgen Defurne
Flanders
Belgium

Hi all!

I create a new user: XXX, and give him superuser rights. When the user
execute:    "SELECT * FROM pg_shadow" on local machine, works ok. If
try to execute this select in a JAVA aplication on another machine,
doesn't works. Other selects works ok in JAVA application:
    "SELECT * FROM pg_database",
    "SELECT * FROM pg_opclass"
What can I do?

Thanks,
radu s.