If you want assurances about the quality of software you're using, pay for a support contract. You can't expect assurances like that on something you got for free.

Your view of software seems to be very limited.

There is plenty of good software out there, that is only useful in limited.

I wrote code for small drone. If you don't know what you are doing you can easily burn down your house, with one of those (lipo are no joke).

SQLlight is great software, but if you try using it in wrong situation, you are going to have a problem.

In my experience for most of the software, the only answer is: it depends on what you are doing.

And sometimes even not so good software is best solution for a problem.

If you aren't competent to evaluate whether software is production ready, choose another profession.

I upvoted this comment because it is correct and valuable advice.

Having had a professional career as programmer now for about a decade and a half, it's my considered opinion that about nine out of ten people getting paid to write software today really shouldn't be [paid to write software]. In other words, 90% of programmers or "software engineers" (what a sick joke that title is!) should be fired; the quality of software would improve dramatically.

Software is not inherently good nor bad. It either solves a problem you have or it doesn't. Linux, for instance, is not a great fix for my specific uses on the desktop. That doesn't make Linux bad. It's just not the right solution for my particular set of problems.

Why are you assuming this is their profession?