Modern mobile applications often require the ability to store, process, and deliver data to users even in the absence of a network connection. In such scenarios, SQLite stands out as one of the most widely adopted technologies for local database solutions. SQLite is a zero-configuration, serverless, file-based, lightweight relational database that is integrated into the Android operating system as a standard library. The primary objective of this paper is to systematically demonstrate the process of creating a database using SQLite within the Android Studio environment, implementing CRUD (Create, Read, Update, Delete) operations, and addressing practical challenges that arise during the development process. The research object is defined as the architecture of local data management in Android applications, while the research subject focuses on methodologies for establishing an efficient and secure data flow using SQLite.