Coming from a relational database background, I look at schema design for document-oriented NoSQL databases such as MongoDB, alongside how implementations handle updates to variable-size documents on disk, covering techniques like memory caching, journaling, delta writes, and periodic compaction. My practical conclusion is to design schemas around how the app accesses data and leave the low-level storage details to the database...
I muse on a potential future project, a simple accounting app, and whether Google’s Firebase/Firestore could serve as its backend. After watching some CodeWithChris videos on the topic, I conclude that a local SQLite database with iCloud syncing is probably the more realistic approach, though a cloud database would partly address the syncing complications...
