I personally haven't experienced any SD card corruption, even though I am running a Maria-DB instance, Home-Assistant instance and a Pi-Hole instance on a Pi Zero with a 32 gig SD Card ( 23 days uptime as of writing )
It typically kicks in after a few months depending on the stuff you're running and type of SD Card. SD Cards aren't really designed for the type of read/write patterns a 24/7 Raspberry Pi server would entail.
I've had 2 sd-cards go corrupt (read-only, any writes were lost). Had a mariadb instance running on it as well. It will hold for for some time, but eventually, the card will give up.
The advice is to buy a quality SD card and backup data that shouldn't be lost to a more reliable location. S3 bucket, a local NAS or something like that. The general idea with Pi's and IoT devices is to act more as input point for data or programmable controllers rather than reliable networked storage or server space.
Since the Pi4 can boot from USB now (might still be in beta, not sure if it's fully released), I would get a USB3 to M.2 adapter, buy a decent M.2 drive, and use that. It'll take up more space than the SD card, obviously, but not that much more.
Honestly throw the thing in a bin and use an old mini pc instead. Lenovo thinkcentre tiny. You can pick them up on eBay for about the same as a fully equipped pi.
Pi is 100% not suitable for 100% duty work. It’s just a toy.
I run a cosy Gitea hosting service over at https://hostedgitea.com/ for those who want their own private Gitea box without the hassle of deploying or maintaining it. Basically I handle all that for you myself. Just starting out but happy to get feedback!