I am writing client server Xojo app that I intend to use with PostgreSQL. It only needs to accessed inside the company which is only one building. To keep this simple I don’t want to have to write and manage any middleware
The Machine it self may need tp reside on may need to be reachable from outside the company, but the DB server should not be.
What is there a simple way to do this? I am not net knowledgeable.
by default postgres server only allows the machine on which it is installed to access the databases.
for other machines, you have to edit the pg_hba_conf file
I’m not clear on the architecture here. Do you mean to say that you will have…
An office machine with PostgreSQL.
An office machine hosting a Xojo server app (which you are writing).
Machines hosting a Xojo client app (which you are writing), which may reside in the office or on the Internet, and which require access to the Xojo server app but not direct access to the PostgreSQL database?
An office machine hosting a Xojo server app (which you are writing).
[/quote]
No
The Xojo clients need direct access as I am not writing middleware. Because the clients are using direct access to the DB, my thought is allowing offsite access would be a big security hole…
Ideally it would be nice if a few people could have clients at home, but I don’t think that is a must have… but if there is an easy ways to set that up that would be great. We don’t have an IT department and I don’t know net/web stuff.
I am not doing a web app because I don’t have a licence, don’t know Web 2 (or web tech)…I did little bit with web 1 about 10 years ago but that was when the RB Web objective was to be more like desktop.