The Journal App Making Journal: Day 46

Relational database management in Xcode

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 managing relational databases in Xcode today.

The more I learn coding, the more I don’t understand when guys complain that women are too sensitive or temperamental. Because code is sensitive and temperamental =)

Today, learned for the first time how to build a “relationship” between “entities” in a SQLite database file.

Started as a very exciting event. It ended up however taking an extraordinary half an hour, through unfruitful searches and trial and error, for me to realise, in order to “rename” the “relationship” into something official, the new name must begin with a lower case letter, and not an upper case one. Or it will fail. I mean … give me a break.

I now realise this is perhaps part of the camel case naming convention for variableNames as opposed to ClassNames. Nonetheless, going into the new database environment, it was not immediately apparent a convention had suddenly become a mandatory requirement.

Once the “relationship” got going though, it worked like a song. The features added today are,

• Adding second entity / a todo category table in the data model;
• Linking the todo-items table with the todo-categories table in a one-to-many relationship using the graphical representation tool in Xcode;
• Linking the two UITableViews together in a performSegue method to allow the grouping feature of todo list items;
• Continue the search bar and local data persistence features after the database expansion.

Loved having been able to manage two database entities with a relationship. Look forward to working with Realm tomorrow.

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.