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