Flutter sqlite course | The ultimate sqflite tutorial with example
In this course you'll learn how to work with SQLite package in flutter from zero to hero, I'll guide you along this course so that at the end you can make all the basic operations (Create, Read, Update, Delete) with SQFLite plugin.
So if you want to benefit the maximum from this course I advise you to open your code editor and try to practise with me, in this way you'll not only stay on the same way as me but also you'll understand how to adapt this SQFLite in other projects.
Setting up the project
It's time to create a new flutter project and install the sqflite plugin and start coding, just jump to next lecture and you'll find an easy guide to setup your project.
Create a new item in database with SQFLite package
How to create a new item in the database using SQFLite project, all you need is and input fields in the UI so that the user can enter some informations and the flutter sqlite package will take care of the rest and store those informations into the database.
Show all items from database with SQFLite package
How to select all items from the database using SQFlite package in flutter, it's easy now, all you need is to call a simple method that returns some future data and then covert this data to an array of your model in our case will be a model of product.
Delete an item in database with SQFLite package
How delete an item from database using Flutter SQFLite plugin, it's easy now with this package, all you need to do is to call a simple method in your database helper that will take care of deleting that item.
of course we'll make look easy because we'll attach to each product a button so that the user when he tap on that button the method of deleting will be executed.
Update an item in database with SQFLite package
How to update an item in the database using Flutter sqlite package, we want when the user taps on the update button a new page appears with the old values in the inputs, the user can modify those values and press save button, the update method from the database helper takes care of saving the new provider data into the database.
Show a single item from database with SQFLite package
How to show a single item from the database using flutter sqlite package, it's easy, what want is when the user taps on a single item, he'll be redirected to new page where he can see all the details about that item that he has selected.
The logic behind this is simple, flutter sqflite package is going to care of all this.
Please make sure to go for the next pages where you can found all the details about sqlite plugin and how it works from creating, deleting, updating and selecting.
Stay focused until the end and you'll be able to master the flutter sqlite package.