As an individual plan user, I decided to use Anvil platform as my development environment and use my own VPS for production. This is mainly for performance and latency issues I had faced so far.
For my planned usage, the biggest hurdle is “data tables” -up to now at least.
I find data tables quite helpful, especially for small amount of data and lookup tables. You can quickly create/modify them and I think Anvil designer tools are integrated & optimized to use its own data tables rather than external databases.
The problem is, when switching to my own VPS (pulling the app and data schema), I can’t find an easy way to transfer the data or make changes on it. Exporting csv and importing through Pandas is very problematic from my side: datetime columns, boolean columns, “NaN” errors etc.
My question is: what is the best way to manage the data tables on self-hosted Anvil? If there is no easy way, do you suggest me to give up with data tables and use my own MySQL or PostgreSQL maybe? In that case, does using PostgreSQL have any advantage over MySQL or even SQLite (for small and portable data) regarding Anvil design environment?