Node :: Inserting Data Into an SQLite Table from a Node.js Application

Summary: in this tutorial, you will learn how to insert one or more row into an SQLite table from a Node.js application. To insert data into an SQLite table from a Node.js application, you follow these steps: Open a database connection. Execute an INSERT statement. Close the database connection. For the demonstration, we will create a new database named sample.db in the db folder. When you open a database connection in the default mode, the database is created if it does not exist....

July 25, 2021 · 3 min · bynaki

Node :: Controlling the Execution Flow of Statements

Summary: in this tutorial, you will learn how to control the execution flow of statements. The sqlite3 module provides you with two methods for controlling the execution flow of statements. The serialize() method allows you to execute statements in serialized mode, while the parallelize() method executes the statements in parallel. Let’s look into each method in detail to understand how it works. Executing statement in serialized mode with Database.serialize The serialize() method puts the execution mode into serialized mode....

July 24, 2021 · 3 min · bynaki

Node :: Querying Data in SQLite Database from Node.js Applications

Summary: in this tutorial, you will learn how to query data from the SQLite database from a Node.js application using sqlite3 API. To query data in SQLite database from a Node.js application, you use these steps: Open a database connection. Execute a SELECT statement and process the result set. Close the database connection. The sqlite3 module provides you with some methods for querying data such as all(), each() and get()....

July 23, 2021 · 4 min · bynaki

Node :: Connecting To SQLite Database Using Node.js

Summary: in this tutorial, you will learn how to connect to an SQLite database from Node.js applications. Installing sqlite3 module To interact with the SQLite database, you need to download and install sqlite3 module. You can use npm to do so using the following command: > npm install sqlite3 After installing the sqlite3 module, you are ready to connect to a SQLite database from a Node.js application. @types도 같이 깔자....

July 22, 2021 · 4 min · bynaki

AWS :: How to deploy GitHub pages with AWS Route 53 registered custom domain and force HTTPS

In this guide I will explain how to deploy a website to GitHub pages forcing HTTPS over a custom domain that is registered with AWS Route 53. We will set up our domain so that the www subdomain will redirect to the apex domain. Summary Set up the GitHub repo Commit and push an index.html or use Jekyll Configure AWS Route 53 Step 1: Create GitHub repo and turn on GitHub Pages If it does not exist yet, create a repository using the naming pattern your-github-username....

July 18, 2021 · 3 min · bynaki