I’ve worked out that my project needs a remote database (on a VPS unix server) and I need to write one Xojo program to set it up and another for users (fewer than 10) to access it and make changes to the data from Windows PCs and from Macs.
My only experience of writing a database program has been with Real Basic, several years ago, on a single local machine, so I would appreciate any advice. I am not an expert.
Almost all of the data will be stored as plain text (Varchars) with some dates as well. There could be more than one person trying to access the data at any one time.
Will an SQLLite database sort this for me or will I need to go up to MySQL or something else? What will happen if two people try to access the same table at the same time? Do I need to assign different ports to different users?
My VPS gives me a fixed IP address but I have several domains at that address. I sometimes struggle to understand what the technical support people at my VPS are telling me so the aspect of setting up the remote database gives me some concern. I know that each domain I have is supposed to have a MYSQL facility but I’m not entirely clear what this means or how I should specify the remote host address in my Xojo program for the different domains.
I suspect I need to do more than just set a database fie address at the remote machine as I would for http or ftp access.
Thank you very much if you can help.
Steve