Category Archives: SQLite

30 most common SQL queries with examples

By | March 18, 2025

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 »

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. So Let’s start… First we will… Read More »

Offline Database from WebService using SQFlite in Flutter

By | September 8, 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… Read More »

SQlite Database Operations in Flutter

By | March 17, 2019

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 »