By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,541 Members | 1,525 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,541 IT Pros & Developers. It's quick & easy.

Internet based database

P: n/a
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
rc******@netlink.com.au
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Nov 12 '05 #2

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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 12 '05 #3

P: n/a
> 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

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

Nov 12 '05 #4

P: n/a
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.

rc******@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
rc******@netlink.com.au
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.