This tutorial series walks you through interacting with an SQLite database using Bun.
Section 1. Getting Started
In this section, you’ll start by connecting to an SQLite database from a Bun app and learn how to create new tables.
- Connecting to an SQLite database – Connect to an SQLite database file using Bun.
- Creating tables – Create tables in an SQLite database file from Bun.
Section 2. Performing Common Database Operations
This section shows you how to insert, query, update, and delete data from an SQLite database from a Bun app.
- Inserting data into a table – Insert one or more rows into a table from a Bun app.
- Selecting data – show you how to retrieve data from a table in an SQLite database from a Bun program.
- Updating data – Update data in a table in an SQLite database from a Bun app.
- Deleting data – Delete data from a table in an SQLite database from a Bun app.
- Import CSV file into a table – Read data from a CSV file and load it into a table.
Section 3. Managing Transactions
This section shows you how to perform database transactions in SQLite from Bun.
- Transaction – Perform a database transaction in SQLite database from Bun.
Was this tutorial helpful ?