Choosing the correct database can be tricky. Are you working on a hobby project? Or is it for a company with a large team of developers? Let’s take a look at some of the factors that might influence your decision!
Commercial databases have been around for a long time. Some of the popular ones are Oracle and IBM DB2. The database software comes with a high licensing cost and is only available for commercial use. These are premium databases that offer guaranteed on-demand technical support. They also include a large suite of tools that can accommodate most of the problems…
In my last blog, we learned about how to create a table, insert data, and query data in that table using SQL. Now let’s take a look at how we can make more complex queries using SQL to get data from two tables using joins and how we can create separate join tables!
In the last blog, we used a
students table as our example. Let's go ahead and see how we would create that table again using SQL:
CREATE TABLE students(
id INTEGER PRIMARY KEY,
Now let’s make a new table…
SQL stands for Structured Query Langauge and can be pronounced either “S-Q-L” or “sequel”. SQL is a language that communicates and manages data within a relational database management system (RDBMS). It allows us to perform all of the CRUD functionalities (create, read, update, delete) via statements using SELECT, DELETE, INSERT, UPDATE, CREATE, and DROP within a database.
The following examples will assume that you have basic knowledge of relational databases. Different relational databases (SQLite, PostgreSQL, MySQL) do not support all of the same SQL data types. For the examples below, we will use data types found in a SQLite database.
Relational database indexes can greatly increase the speed at which our database is queried. However, there is a cost to using them — let’s dig into it!
An index is a data structure that contains a copy of a column (or columns, more on that later) from a database table that is ordered to increase the speed of database retrieval operations on the original column in a table. An index also contains a “key” on each copied row that points to the original row of data in the column of the table. …
Besides the engine, the runtime environment also contains APIs, an event loop, and a callback queue (and maybe some other parts depending on which runtime environment is being used).
The React Hook Form is an NPM package for ReactJS that helps simplify the management of form data as well as increasing code performance by reducing the number of re-renders. The package is being steadily supported by developers and has a large base of users, which makes finding helpful documentation and tutorials easy. I’m going to walk you through a simple implementation of React Hook Form to show just how useful this package is.
We want to create a sign-up form with multiple input fields that are submitted when a button is clicked. …
A great definition from MDN: A promise object represents the eventual completion (or failure) of an asynchronous operation and its resulting value.
CI/CD stands for Continuous Integration / Continuous Deployment. It is a method of developing applications that involves continuous monitoring and testing, and deployment via automation. Changes and updates are able to be continuously shipped to production. This pipeline carries the app through the entire lifecycle from development to production and then is repeated indefinitely as the application grows and changes.
Let’s take a look at how development practices used to work. Say we have two developers, Sam and Jordan. They both have the same starting code pulled down from an SCM (Source Code Management) system like GitHub. Sam is working…
Scope refers to the accessibility of the variables within our code. There are two main types of scope: global and local.
Local scope has 2 levels of scope: function and block.
A closure is created every time a function is created. It encapsulates the variables inside of the function and creates a local scope while allowing access to variables that are in the function's outer scope. …
Prerequisite knowledge: basic JS functions, console.logs, and Web APIs like setTimeout and addEventListener.
Former live music audio engineer. Recent bootcamp grad, current job seeker.