The Journal App Making Journal: Day 44

Local Data Persistence with SQLite Database

Nicole Liu
2 min readAug 13, 2020

Continue to journal on three questions everyday in this Journal App Making Journal.

1. What have I learned about app design and development today?

Continue to acquire app design and programming skills through the iOS App Development course on Udemy by Angela Yu and the London App Brewery.

Learned about local data persistence with a SQLite data model today.

Screenshot by Author (from iOS App Development course by London App Brewery)
Screen Recording by Author

The day before yesterday, we started learning about storing / persisting app data between sessions.

We first used UserDefaults as a simple storage medium. Then we upgraded to using the Codable protocol, where created and stored data in the Dictionary type, or key-value pairs.

Today, we are presented with the full range of toys available for data management in the iOS platform. (See picture on left.)

Beyond the simple options of UserDefaults and Codable protocol, for proper relational database management, the simple toy is an SQLite database we created today using a local data model file.

In progress video data, a new item added in the app appears in a local SQL database file. And interactions with the data now can enjoy the functionalities of a relational database.

For the more industrial strength machinery, the options are Swift’s object-oriented Core Data framework, which is not itself a database but a system that manages databases, or third party database services, such as Realm. Can not wait.

2. What have I learned about other journal users today?

To be continued.

3. What have I learned about journaling products / technologies today?

To be continued.

About The Journaling App Making Journal.

Connect with me.

Follow updates from this journal.

Read the last update. … Read the next update.

--

--

Nicole Liu

Dance . Learning . Technology . Design . Entrepreneurship