I don’t reccommend frappecloud if you want to learn and play with ERPNext. It’s got too many limitations (e.g. extending ERPNext using custom apps is not possible)
Yes I agree. Most free tier has less than 1 G in memory and 1 CPU. Frappe / ERPNext needs more power.
I used to work with virtual machines on my laptop with ERPNext, but I definitely WILL NOT do this again. This setup really slowed down my pace.
Cloud based servers allowed me to do things faster. I am able to save snapshots, take down, or spin-up new servers, do backups and restore backups very fast. So, development time is fast. Very fast.
If you need to do debugging, the nice thing about Visual Studio Code is that it automatically does port forwarding so that the cloud based code is treated like its on local host.
Then, when you need to deploy, it is easy to do letscencrypt (certbot) on the cloud.
So now, I do all my code work on the cloud.
GCP is a good place to start. I also started here.