Introduction
In this project, we will learn how to build a REST API in Flask using SQLite as the database. We will start by creating a sample SQLite database and populating it with some data. Then, we will build a Flask application with endpoints to perform CRUD (Create, Read, Update, Delete) operations on the data in the SQLite database.
👀 Preview
![Alt text](https://file.labex.io/namespace/718bace8-27a3-4200-a588-dde4041ceeb9/flask/project-building-a-rest-api-in-flask-with-sqlite/lab-1/assets/20230926-14-35-22-MYtuGQGs.png)
🎯 Tasks
In this project, you will learn:
- How to create a Flask application with SQLite as the database backend
- How to create a sample SQLite database and table
- How to populate the database table with sample data
- How to implement endpoints to retrieve all users, retrieve a specific user by ID, create a new user, update an existing user, and delete a user
- How to test the REST API endpoints using cURL or a browser
🏆 Achievements
After completing this project, you will be able to:
- Build a Flask application with SQLite as the database
- Perform CRUD operations on data in a SQLite database using Flask
- Implement and test REST API endpoints for a Flask application