I plan to host the application on Amazon Web Services (AWS). I had some experience in setting up a WebDev application on AWS a few years ago and I thought the servers and all the other utilities and services offered by AWS were fantastic. Also a basic server was free for a year – so if that’s still the case I’ll do that again. Would be interested to hear from others as to which hosting providers they use. I’ll definitely write a post when I get around to setting up the server and installing the application.
The reason I mention this now is that I want to keep the costs down. So choosing a database like MS SQL is definitely not happening. MySQL and PostgreSQL are both free and I’m sure are excellent choices. I haven’t tried using MySQL but have done some work with PostgreSQL a few years ago and had some guidance from Pete Halsted. It worked fine, however, it seemed you had to do a bit more setup and follow some rules to make it work – it all seemed a bit fiddly. Certainly compared to Hyperfile. There are two versions of Hyperfile – Classic and SQL C/S. Classic I guess is similar to Topspeed (for the Clarion guys) – some sort of ISAM database. I used Topspeed for many years and it was excellent. However…..running big databases and large numbers of users over sub-optimal networks was a headache as the database files would regularly “corrupt” requiring database fixes and downtime. This problem largely goes away if you have a database engine that handles the data access and returns data to clients. This is what Hyperfile SQL C/S gives you. Given the distributed nature of the client (browser) and server, and the fact that the data access in handled by server code I suspect using Classic would work just fine. However, it seems no hassle at all to use the C/S version – so that’s what I’m doing. As I get to use it more I’ll write a post about how I’m finding it for managing the data (outside of the application).