Re: Internet based database

> I maintain an internet site. The host is linux based and uses postgres on the server.
> I wish to install a smallish database (of names and addresses +) on the host, and allow it to
> be accessed over the internet (by a restricted number of people).
> I have the database working locally on a MS Access database, but would expect to transfer it to
> a postgresql database on the server.

> My question is: What is the method of operating such a database over the internet?

I assume you want to develop an application that works on the database
could be operated by a browser by multiple people.

Do I write
> an application to use at home which sends postgress queries to the server, or do I access the
> server-based postgres program using HTML or some other method?

when you say " I have the database working locally on a MS Access database" what do you
mean by "working" . do you already have an application or you are just able to
open and edit the database by using MS ACCESS.

> Can I write an application which runs on my home computer, but sees its database file on a
> directory at the server? I will probably be using Delphi 7 or a public domain postgres
> application.

Please read about client / server architechure. PostgreSQL is client server based.
Its different from MS ACCESS opening a MDB file on a shared server . PostgreSQL will
allow multiple users to work on the same data simultaneously taking care of
concurrency issues. where as MS ACCESS will not.

>
> Any explanation would be appreciated, or possibly direct me to something I can read in the net.
> I have looked, but everything seems either too complicated or too simple.

We are here to help you , but lets be clear on the problem first :-)
and sorry for the typos.

>
> Russell
> rcrosser(at)netlink(dot)com(dot)au
>
>
> ---------------------------(end of broadcast)--------------------------- TIP 3: 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

-----------------------------------------
Over 1,00,000 exporters are waiting for your order! Click below to get
in touch with leading Indian exporters listed in the premier
trade directory Exporters Yellow Pages.
http://www.trade-india.com/dyn/gdh/eyp/