One of the most essential skills as a programmer is being able to identify and utilize the appropriate tool for a specified task. In the context of database management, this will mean using SQL to …

Throughout this lesson, we’re going to access an SQLite database with temperature data for countries over the last 150 years. We’re going to take this data, collect it per year in a JavaScript obje…

In the previous exercise we were able to import the ‘sqlite3’ library and use that to open our SQLite database — so far so good! But we still haven’t retrieved any information from it. Since …

[…] is a useful tool to fetch all the data we have that meets certain criteria. But what if we only want to get a particular row? We could do something like this: […] In this example, we …

Now we know how to retrieve data from a database when we know exactly what we’re looking for. But we may not always know what values we will need to search for when writing our program. When we wri…

Not all SQL commands return rows, and in fact, some essential SQL commands do not. If we […] a row or […] a […] we will not receive a row in response. To perform SQL commands that do no…

No one’s perfect. Code, like people, can make mistakes. This is OK! What’s important is that we learn how to handle our difficulties while keeping our composure. Handling errors is an important par…

While learning JavaScript, you likely learned about the powerful method […] that allows us to process every element in an array separately. Now we will use a similar method that will enable us …

So far we’ve managed to: 1. Query a database for weather records by location. 2. Reformat that data into a JavaScript object. 3. Manipulate that JavaScript object to find new, meaningful informati…

By default, the commands we issue to our database run in parallel. Every request we make gets sent to the database — which processes them all as quickly as it can, regardless of the order i…

Wow, we were able to take data from a source, manipulate it for our needs, and save it separately. We’ve managed to set up a database, create tables, insert data, and modify it — all within J…