From the course: Master Next.js by Building Scalable Apps with Routing, Databases, and Performance

Unlock this course with a free trial

Join today to access over 25,200 courses taught by industry experts.

Introduction to SQLite

Introduction to SQLite - Next.js Tutorial

From the course: Master Next.js by Building Scalable Apps with Routing, Databases, and Performance

Start my 1-month free trial Buy for my team

Introduction to SQLite

“

In this section, we are going to have an overview of SQLite and also learn how to work with the SQLite queries. So first of all, what is SQLite? SQLite is a database technology which has existed since a long time, and it is used extensively in developing mobile applications due to its lightweight character. SQLite was introduced in the year 2000, created by Richard Hipp, and has been renowned for being a very lightweight database, and it is a serverless technology. Even though SQLite was used extensively in the mobile applications, databases like MySQL or MongoDB were used more in web applications or local softwares. So first, let's install the required tools to operate the SQLite database. One way is that either you can go to the official website and download the executable file, or we can directly use the VS Code extension that allows us to operate SQLite databases. We will go with the later approach that is install the extension in VS Code as that will be more useful for us to work…

Contents