This week’s article will be about SQL’s aggregate functions. I totally missed including it last week so I wanted to do a short write-up on it this week instead. Honestly, if you’re familiar with using formulas for tables in Excel, these functions should be second-nature for you. I’ll also be dropping in a few extra keywords to help you get those searches as specific as you need them to be.

As with last week, I’ll be using the same example using a table based on Medium articles. If you want to check that out, you can find it here.

First…


Last week I wrote an introductory article to learning Structured Query Language. I covered creating tables, updating tables, dropping tables, and methods for executing SQL through a text editor. If you haven’t seen that already, feel free to check it out here.

The main topics I want to touch on today are how to manipulate data into those SQL tables. The methods we will be using are inserting, updating, selecting, and deleting.

Insert

The first thing we need to know is how to insert data, considering we can’t update or select data that doesn’t exist. If you followed along last week…


As an avid Rails developer, using SQL has become something I take for granted. Thanks to the ORM ActiveRecord library, I haven’t had to physically write out a SQL statement in a while. That being said, today’s article will be a refresher on the basics of SQL: installation, databases, tables, and queries.

Getting Started

SQLite is a great place to start with running SQL commands. You can find the download page here. If you have a Mac running OSX version 10.4 or greater, you may already have SQLite installed by default. Open a terminal and run the command which sqlite3 and if…


It’s been a while since I’ve covered a form of programming conventions, and considering I’m fresh off a holiday, it’ll be a simple but important topic this week: Semantics.

Merriam-Webster Dictionary defines this as “the study of meaning”. If you’re learning a new language, such as Spanish or French, you may come across a word you haven’t seen before like queso or fromage. When you rack your brain to try to decide what that word means, you’re looking at the semantics of that word only to discover it’s the word for cheese.

Why is this important?

It’s important because text on a screen or…


Today’s post will be a short talk about using the npm package react router. As always, the link to the direct documentation can be found here.

Client-Side Routing

Any Full Stack developer must be familiar with routing at its core. Routing is usually handled by the app’s server. This means when you click the link to visit a web app’s “About” page, you are then making a request to that app’s server to see the data associated with the About page.

The difference when it comes to client-side routing is that navigating routes may not necessarily make an entirely new request. This…


Today’s article will be building off of last week’s article about implementing the Maps JavaScript API. If you haven’t already read that, you can find it here. It’s essential to this guide as I’ll be using previously built functions and components. Without further ado, let’s jump in.

As always, if you want this paraphrased information straight from the source, follow this link to the documentation.

Activate the API

So first things first, you need to activate this API in the Google Dev Console, the same way you did in the last walkthrough. You can use JavaScript’s native fetch() method in this walkthrough. …


Today I’m going to be going over a short guide on how to drop a Google Map component into your React project. The official NPM documentation for the library I’m using has all the instructions here if you would like to check that out instead.

Setup

First things first, go here to sign up for your API key. If you’ve done this kind of thing before, its fairly straight forward. Otherwise, you’ll need to sign up and add a new set of credentials. It’ll ask for the project name and whatnot. …


Today I’ll be covering React Lifecycle Methods: what they are, how they are used, and the scenarios they will be most useful. Let’s get right into it.

What are Lifecycle Methods?

Lifecycle methods are a library of methods native to React’s built-in Component class. These methods vary in usage as they are called at different moments of a component’s rendering process. React’s process of rendering components can be separated into 3 phases:

  • Mount
  • Update
  • Unmount

Before you read any further, feel free to check out the React Component Documentation and this Diagram.

The LifeCycle Methods

“Unsafe” Methods

With the introduction of React v16.3 in 2018, there are three lifecycle…


Last week I covered setting up Redux for your React project and glossed over its use cases. Today’s article is meant to expand on that, diving into a few of the more complex features of Redux. If you haven’t read the first article and you are new to the Redux library, I’d suggest checking out the other article here.

Action Creators

Although this article is mainly regarding Thunk, I forgot to include Action Creators last week so I’m including them now as bonus.

Last week we talked about Redux actions, which are plain JavaScript objects that have two keys, a type key…


Today I’ll be discussing a React library known as Redux. This post will cover a few different things, such as when and why you should use it, how to set it up, and basic usage.

Summary

Redux is a library used in React to manage state. The best use case for Redux is for larger applications, as setup and usage requires a few different working parts that is unnecessary for anything very simple. Redux can give your application a central hub of everything you’ll need to manage in your state through the Redux Store. …

Cody Dupuis

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