Image for post
Image for post

For some reason, SQL JOINs are one of those topics where I frequently find myself having to double-check the syntax with a quick Google search before actually writing the query I want to execute. In an effort to solidify my comfort level with this syntax, and to hopefully help out anyone who is just starting to work with JOINs in SQL, I will provide an overview of all the different kinds of JOINs available to use in SQL and when it is appropriate to use each one.

What Is a JOIN?

In the simplest terms, a JOIN in SQL is a way to access data from multiple tables that reference and share overlapping data. For example, let’s say I have two tables of data about the NBA: one that contains team data, and another that contains player data. A team has many players, and each player belongs to a team, so my player data table will have a team_id field that provides the id number of the correct team in the team data table. …


Image for post
Image for post

I’ve used React to build several web apps, and I’ve enjoyed working with it, especially for larger apps. Having only looked into mobile development a little bit, I was curious about what the learning curve would be for someone with my background trying to learn React Native. In this blog post, I will outline the high-level similarities and differences between React and React Native, and go over what stood out to me as someone familiar with the former but not the latter.

What’s The Same

It’s tough to narrow it down because there’s a lot more similarities between React and React Native than there are differences. In both cases, you’re using React to build reusable UI components that make use of state and props to dynamically update. …


Image for post
Image for post

As I’ve been learning to program, Git has mostly been a means to an end. For the uninitiated, Git is a version control system used by developers to improve workflow.

There are a core group of commands I use to organize, track, save, and publish my work, but I’ve always known there’s much more that Git has to offer. …


Image for post
Image for post

In several recent conversations, whether they were job interviews or informal networking coffees, I keep hearing one technology mentioned: Typescript. More often that not, the person who says it has their eyes light up when they mention it.

For those who don’t know, Typescript is a strict, typed superset of Javascript developed by Microsoft. It starts from the same Javascript code you’re probably familiar with, and it compiles to Javascript, but it has a few added features that make life easier for programmers.

After hearing all the hype, I decided to look into Typescript for myself. …


Image for post
Image for post

After using libraries like Bootstrap and Semantic on a few recent projects, I decided to do a refresher on the ins and outs of good ol’ CSS. During my research, I was struck by some features that were only added in CSS3, and I decided to focus specifically on those and summarize them in this blog post.

Attribute Selectors

There are a few selectors new to CSS3 that make it easier to select an attribute with more specificity. The [attr^=val] selector will look for a DOM element with a value that starts with the string passed in. One of the most common use cases for this is links. …


Image for post
Image for post
Google Chrome Extension store

Recently I was curious about what went into making a Chrome extension, and I wanted to make one for myself for fun. I was inspired by the Chrome extension that went viral a few years ago that replaces all instances of the word “millennial” with the term “snake people.” I just had to figure out what my version of millennial-to-snake people was.

I wondered to myself, what’s something I see on the Internet that I would like to see rephrased…


Similarities and differences between Vue and React

Image for post
Image for post
vue.js

During my time at Flatiron School, the majority of our time learning frontend development was spent working with Vanilla JavaScript, React, and Redux. Recently, I started working on a project that uses Vue.js, and I had to familiarize myself with the popular JavaScript framework.

During my research, I thought it might be a good idea to take a look at Vue and React side-by-side and look at some of the high-level similarities and differences. …


Testing can be scary at first

Recently, I was looking at the instructions for a code challenge that I had to complete as part of the application process for a job, and two things quickly stood out to me: the company wanted to see me use React to complete the task, and they stressed that unit tests were very important.

While we had covered the basics of Test-Driven Development (TDD) during my time at Flatiron School, we only had brief practice writing our own unit tests, and it was only using Ruby-specific testing tools like RSpec. Having seen TDD stressed in many job listings and on multiple code challenges, I’ve made it a point of emphasis in my post-Flatiron studies. …


Image for post
Image for post

During a recent interview, I was shown a demo of a website and told that a piece of data being displayed was incorrect and did not match the value in the database. I was asked to explain how I would debug this problem and try to find out where the source of the issue was.

We agreed on a debugging process after a brief conversation, but my initial suggestion relied too heavily on console.log()s, and my interviewer encouraged me to make use of the Network panel in the Google Chrome developer tools as well. While I had used the Chrome dev tools to inspect network activity a few times before on a project, this conversation made me realize that it would be worthwhile to take a deeper dive into this portion of the Chrome dev tools to further improve my debugging process. …


Image for post
Image for post
Did someone say Link?

As I’ve been preparing for interviews, I’ve been studying all of the major data structures and their various applications. Some, such as hashes and arrays, were already familiar to me through my coursework and projects at the Flatiron School and beyond. Others were less familiar or entirely new.

One of the more confusing data structures for me to wrap my head around at first was linked lists. They can be a little counterintuitive at first, particularly if you’re used to more flexible data structures like arrays and hashes. …

About

Connor Finnegan

Full-Stack Web Developer. Studied at @FlatironSchool

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store