shameless plug: I've been on working on an app for 1:1's plus tasks using AI for the past 2 (after many pivots). It is self hostable. https://www.atomiclife.app/. Will have github repo up soon and a formal Show HN.
Yep, one full copy of the DB on each app server. So yes, it's bad if your data is 100s of GB, but if you only have in the low 10s GB of data or less then it's fine. It all depends upon how many server you need to run your app, If you only have one or two server then even very large databases of 100s of GB could be just fine.
Interestingly, our SRE people specifically have a rule "never share the DB and the app on the same server", because apparently a high load on the DB can decrease the overall performance of the server. It also allows them to freely add new DB servers (sharding) without touching the app server
That makes sense with client/server databases and if you are trying to separately manage database resources from app resources. When you use SQLite you have basically decided that the database and the app is one integrated unit that you will manage as a whole.
chatGPT isn't perfect right. But it is good enough to get things done. For the occasional hiccups, this site can help clarify with the power of the community.
That is value proposition.
The secondary proposition to share really good prompts to get really good answers. For example how to get a properly formatted CV for an interview at Microsoft?
If it's really important to you then you can double check else forget. simple. Helps with the grey area and your confidence interval about the answer. All subjective.
chatGPT right now has a lot of "hallucinations" or convincing "false information" that OpenAI needs to fix. They can potential show & highlight wrong information with another model.
I don't know the right answer but I don't think it is too difficult, so I totally agree with you.