Category Archives: SQLite

Google’s Flutter Tutorial – Save Image as String in SQLite Database

By | October 17, 2019

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. [java] shared_preferences: ^0.5.0 // save the data in preferences.… Read More »

Offline Database from WebService using SQFlite in Flutter

By | August 11, 2019

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 json models, make… Read More »

SQlite Database Operations in Flutter

By | September 27, 2018

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: [java] dependencies: … sqflite: any [/java] You can download the sample project from here. employee.dart [java] class Employee { int id; String… Read More »