Here are the 30 common SQL queries with examples. These cover a wide range of database operations from basic to more advanced. Basic SELECT Queries Filtering and Conditions Aggregations and Grouping Joins Subqueries Data Modification Advanced Queries These queries cover the most common operations you’ll need when working with SQL databases. Each example can be… Read More »
In this tutorial we will see how to save an image as a string in preferences. Watch more flutter videos on my youtube channel here. Watch Video Tutorial Add Dependencies First thing we have to do is to add the plugins. Open pubspec.yaml file and add the below Dependencies. So Let’s start… First we will… Read More »
We are going to create an Offline Database using data from a Webservice. Watch Video Tutorial We are going to use the below service for that. https://jsonplaceholder.typicode.com/photos This service has about 5000 records, we are going to parse these records and insert all the records into the Offline SQLite database. Generate JSON Models To create… Read More »
Watch Video Tutorial Add Dependency SQFlite is a Flutter library for doing local Database Operations. You can download it from here. To Integrate SQFlite library in your project In your flutter project add the dependency: You can download the sample project from here. employee.dart Database Utils Here is a sample DB Utility file. DBHelper.dart… Read More »