DEV Community

Aaron Gholson
Aaron Gholson

Posted on

Flatiron - Phase 3

Phase 3 at Flatiron is now complete! This phase was relatively relaxed compared to the previous ones, even though we learned a few new programming languages. Python was the main focus, and after grasping the basics of it, we integrated SQL into our learning. Personally, I found Python relatively easy to pick up, but things got a bit confusing for me when SQL was introduced.

Let's break down SQLite for those who might not be familiar with it. In the expansive world of databases, where heavyweight giants like MySQL and PostgreSQL reign supreme, there's an unsung hero that often goes unnoticed—SQLite. This unassuming database management system (DBMS) may not be a household name, but it's a powerhouse in its own right. Unlike traditional databases that require a separate server process, SQLite is embedded directly into the application that uses it. This unique design makes it an incredibly lightweight and efficient choice for various scenarios. SQLite's versatility extends to a range of applications: mobile apps, desktop apps, web apps, and more. Its simplicity, efficiency, and cross-platform support make it an ideal choice for a wide range of applications.

Our project for phase 3 was to create a CLI application using Python and SQL. This project wasn't too challenging since we had a template to work with, but a majority of the work involved troubleshooting and bug fixing. We encountered problems that required us to do some in-depth research or quick thinking to resolve. One of my biggest challenges was ensuring that the user inputted an integer and not a string, and vice versa. I explored a few ways to address this issue, and in the end, I opted to create functions that I could call to check if the input values were of the correct types. Initially, this solution threw errors and even closed the program, but my partner and I were able to clean up the code and complete the task without any issues.

This phase of Flatiron was not as stressful as the previous ones, although understanding databases posed a personal challenge for me. It's challenging for me to code a program without immediate visual feedback. In React, having the application update in real time was a very helpful feature that I definitely took for granted. However, as we conclude phase 3, I have a solid grasp of SQL and Python, so I'm still very satisfied with the Flatiron course.

Sentry image

Hands-on debugging session: instrument, monitor, and fix

Join Lazar for a hands-on session where you’ll build it, break it, debug it, and fix it. You’ll set up Sentry, track errors, use Session Replay and Tracing, and leverage some good ol’ AI to find and fix issues fast.

RSVP here →

Top comments (0)

The Most Contextual AI Development Assistant

Pieces.app image

Our centralized storage agent works on-device, unifying various developer tools to proactively capture and enrich useful materials, streamline collaboration, and solve complex problems through a contextual understanding of your unique workflow.

👥 Ideal for solo developers, teams, and cross-company projects

Learn more

👋 Kindness is contagious

Please leave a ❤️ or a friendly comment on this post if you found it helpful!

Okay