The Eddie’s electronics website example uses an sqlite database, which is easy to deploy on a web server since it’s only one file. But, I’m wondering, if I want to deploy a postgres database, that seems a lot more complicated since it uses hundreds of files, and I don’t even know which ones I need or don’t need. I guess I could write a program that would create the postgres database and tables on the web server. But I’m wondering if there is a better way of deploying the database to the webserver.
You would have to install Postgres itself on your server. Then you can connect to it and create databases and tables as needed.
Hosted services, such as Xojo Cloud, typically already have Postgres installed. In the case of Xojo Cloud, you just click one button to enable it for use.