Category: Database

Here I am collecting learning points from the Data Models and Query Languages chapter of the Designing Data-Intensive Applications book. The main arguments in favor of the document data model are schema flexibility, better performance due to locality, and that for some applications it is closer to the data structures used by the application. The […]

Problem Statement As we insert, update, and delete data, the SQLite databases file of sqliteDB-1.db and sqliteDB-2.db will grow in size and become fragmented.Deletes will cause empty space that is not returned to the operating system.whereas, inserts and updates will cause data to be scattered within the database file. This might lead to Increased Database […]