Обсуждение: 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? 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?
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.

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.

Russell
rcrosser@netlink.com.au

Russell Crosser wrote:
> 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? 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?

Either of these approaches will work.  Your application can run on your
home machine and access the Pg database on the server through TCP/IP.
You can limit TCP/IP access to your IP address to improve security.

Running everything on the server and using a web interface is probably
more common as it allows you to easily access it from any web-enabled
computer and you can let other users input data as well, if you want.

If you are basically doing an address book, I'm sure there are plenty
free ones available.  Some good places to look:

freshmeat.net, sourceforge.net, hostscripts.com

and here's one, for example:

http://www.extropia.com/applications.html

> 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@netlink.com.au
>
>
> ---------------------------(end of broadcast)--------------------------- TIP 3: if
> posting/reading through Usenet, please send an appropriate
>      subscribe-nomail command to majordomo@postgresql.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/

> 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).
Two options, mainly:

Write the code for accessing the database in, say, PHP. Call
that from Apache running on your server. People would be using
a browser to connect to your database.

Write a specific client for your users. That client would
access PostgreSQL on your server directly, sending queries via
TCP/IP. We do this with GnuMed.

More options:

Let people have shell accounts on your server so they log in
and run a client on your server.

Write a specific client that talks to a middleware/ application
server on your machine. That app server in turn talks to your
database locally.

It really depends on what your needs are.

> Can I write an application which runs on my home computer, but sees its
> database file on a directory at the server?
No. In a real database you don't see (much less care about)
the actual data files. But you see the data - via SQL
commands.

But then, of course, you can write some application that sees
its "database" files in some directory on your server. You'd
want to be using Samba or NFS or something to mount that
directory on your client machine.

Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

There are probably a lot of scripts which can do what you want using
PostgreSQL or MySQL and PHP. Check www.hotscripts.com for some of
these.



rcrosser@netlink.com.au ("Russell Crosser") wrote in message news:<00c901c3a1db$1f1eae40$cbe13ecb@RC>...
> 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? 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?
> 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.
>
> 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.
>
> Russell
> rcrosser@netlink.com.au
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly