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

Node :: Upgrading npm

Is there a quicker way of just updating all the dependencies, including major version changes? So, like npm update but for major version updates as well? Yes, there is a tool called npm-check-updates that will do this. Just run the following command: npx npm-check-updates -u This will update the dependencies to the latest versions (including major version changes) in the package.json file. If we are happy to go ahead with the upgrades we need to run the following command:...

July 18, 2021 · 1 min · bynaki