IIRC, multiple writers in SQLite is supported, their writes will just be serialized. What you don't have is concurrent writes. But, given SQLite writes are so fast, in practices it's not really a big deal.
If you haven't used SQLite in a real project with heavy writes, I'd say you do it. SQLite is WAY more powerful than people tend to think of it.
SQLite is abolutely amazing as an app format! I couldn't list how many tools are available to read SQLite data, or how easy and friendly they are. Even its CLI does wonders when you're dealing with data with it. SQLite has been around for 20+ years and is one of the most heavily tested softwares in the world.
SQLite is very simple, yet very reliable and powerful. Using SQLite as file format might be the best decision an engineer can take when it comes to future-proofing preservation of data.
I wouldn’t say it’s so intuitive. We need more of these articles coming in — I learned nice things from this text, specially about the exact match over partial indexes, and to always QUERY EXPLAIN instead of assuming you’re right (my case haha).
What’s obvious for you might not be for someone else.
You can definitely live in Brazil with 1K USD/month.
And nowadays it's even better because the USD-BRL rate is about 5-something. For a comparison, 1K USD is about what I spend every month to live - and I definitely don't cook beyond just breakfasts and some snacks/sandwiches. So I lunch in restaurants every single day, I live in a quite comfortable apartment, etc. - I mean, I'm not "stretching myself to spend as minimum as possible". In fact, 1K USD is about 4x the BR minimum wage, and about 2-3x the "common" income of people.
I live in Fortaleza, a very sunny city which is close to some incredibly beautiful beaches. Search for "jericoacoara" on Google and you'll know what I'm talking about (Jeri tends to be a bit expensive tho, due to heavy presence of tourists - but not much).
Fun fact: it's quite common to hear about gringos coming around and deciding to stay. You'll find some French and Italian restaurants in Jeri and/or Jijoca - and lots of gringos, of course.
What a BS.