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 things first, here’s a look at our…
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.
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, I’ll be using the same example from that article. If you run
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.
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 the return output is
/user/bin/sqlite3, then you’re good to go. …
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.
It’s important because text on a screen or a page don’t have all of the aspects of a conversation. There’s no added in voice tone or body language to read, and can easily be misreading. I’m sure anyone reading this can somewhat relate this to deciphering text message conversations. …
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.
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 is the core difference between a Single Page Application and a Full Stack Web App. In an SPA, you can request all the data you need on the landing page thanks to its asynchronous behavior. …
As always, if you want this paraphrased information straight from the source, follow this link to the documentation.
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.
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.
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:
With the introduction of React v16.3 in 2018, there are three lifecycle methods that are now considered legacy methods, and therefore have been aliased as “unsafe” methods. You may still use them, however, they are advised against since new React versions have offered safer alternatives. …
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.
Although this article is mainly regarding Thunk, I forgot to include Action Creators last week so I’m including them now as bonus.
type key and a
payload key. Action Creators are simply pure functions that can optionally accept arguments and return the action you want to create. …
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.
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. …