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 »

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: You can download the sample project from here. employee.dart Database Utils Here is a sample DB Utility file. DBHelper.dart… Read More »

CRUD Operations in SQLite using SQLiteOpenHelper – Android

By | June 26, 2016

We do SQLite operations in Android by extending the SQLiteOpenHelper Class. I will create an Employee table with three fields id name company. I have a model class same as the database table Employee. Employee.java Lets see How we can do the CRUD (Create, Read, Update and Delete) Operations. CREATE We create a class that… Read More »

Custom Loaders with SQLite in Android

By | June 1, 2016

Introduced in Android 3.0, loaders make it easy to asynchronously load data in an activity or fragment. Loaders have these characteristics: They are available to every Activity and Fragment. They provide asynchronous loading of data. They monitor the source of their data and deliver new results when the content changes. They automatically reconnect to the… Read More »

How to store an Image from Android to a SQlite and retrieve it?

By | December 23, 2012

Hello all… In today’s post I will show you how to store an image in an SQLite database and retrieve it. First I will just create a Database Helper Class for adding and reading from the Database. Our Database contains only one table “Images” with two columns “id” and “image”. Note : If you want… Read More »

How to load a spinner with values from SQlite Database in android?

By | November 18, 2012

Here is a simple example showing how to load a database values in a spinner in android. OK we will start. This is the layout for the spinner row. spinner_row.xml This is the layout for the interface. activity_main.xml Now this is the MainActivity.java file that uses the spinner and the database. Join the Forum discussion… Read More »

How to save CheckBox values in SQlite Database and Load it later?

By | March 13, 2012

Hello…….. This post is just a simple demonstration to show a way to store a checkbox value in a database and reload it. Here I am storing only a value of a single checkbox and reloading it. But you can make changes in the code to save the id and value of the checkbox in… Read More »

Working with SQLite databases through command Line in android.

By | January 23, 2012

Hello all, In todays tutorial I will show you how to work with sqlite databases in android through command line. Advantages 1. You can browse any number of databases. 2. You can write any queries and execute. First go through these tutorials to get a glance of how to work with sqlite databases in android.… Read More »

SQLiteManager plugin for eclipse

By | April 18, 2011

When you are working on an Android application that stores data in a SQLite database.There arise many questions like where does this database file get stored on the filesystem ? How can we access the database? I will give solution to all these problems. I created the SQLite database from my previous post about Using… Read More »

How to use SQLite in ANDROID, A really simple example.

By | April 17, 2011

Hello ANDROID Lovers…….. In today’s tutorial I will show you how to deal with SQLite Databases in ANDROID. You know that SQLite are Lightweight databases which is maintained only on the client side. They don’t need a server. The SQLite databases are simply a file wrapped around with some stuff which helps us deal with… Read More »

Working with SQLite Database in ANDROID.

By | February 14, 2011

Below is a straight forward example of how to deal with SQLite database in ANDROID. Go ahead and copy and paste the following code to your java file. The example has one database and performs functions like insert delete and listing of values in a textView. In the XML file set up a TableLayout with… Read More »

Common SQL commands with example

By | January 20, 2024

Certainly! SQL (Structured Query Language) is used to interact with relational databases. Here are some common SQL commands with examples: Example: Example: Example: Example: Example: Example: Example: Example: These are just a few examples of common SQL commands. SQL is a powerful language with many features, and its usage can vary depending on the specific… Read More »

Flutter DataTable + MySQL

By | September 28, 2019

In this demo we will create a flutter app that communicates with the Server and create a table, insert records, update records, fetch all records and delete records. The Data from the Server will be displayed in a DataTable. Watch Video Tutorial Here I am using XAMPP to create a local Server. You can download… 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… Read More »

Video Tutorials

By | December 28, 2018

  Visit my youtube channel here.   Google’s Flutter Tutorial – Share Data to other applications.     Google’s Flutter Tutorial – Upload Image to Server     Google Flutter Tutorial – Tabbed AppBar     Google Flutter Tutorial – Carousel     Google Flutter Tutorial – Gradients     Google Flutter Tutorial – Bottom… Read More »

Category:

GridView Demo in Flutter

By | October 10, 2018

Hi Friends, Today we will see how to implement GridView in Flutter.     We are going to use this service for the data First we will create a Model for the Grid Cell No we will create view for Grid Cell Create a file named “cell.dart” and copy this into it. Service Class We… Read More »

Room Database from Google – A Simple Example

By | April 5, 2018

Lets talk about the Room Persistent Library from Google. The Room persistence library provides an abstraction layer over SQLite to allow fluent database access while harnessing the full power of SQLite. The library helps you create a cache of your app’s data on a device that’s running your app. This cache, which serves as your… Read More »

Using Loaders in Android Using SimpleCursorAdapter in Android.

By | May 20, 2016

Introduced in Android 3.0, loaders make it easy to asynchronously load data in an activity or fragment. Loaders have these characteristics: They are available to every Activity and Fragment. They provide asynchronous loading of data. They monitor the source of their data and deliver new results when the content changes. They automatically reconnect to the… Read More »

Simple Core Data tutorial in iOS

By | July 7, 2015

In this tutorial we will be making a simple application to save a person details using Core Data. Here we will have two models or it can be said as Database tables – Model1 and Model2. Below are the basic things about Core Data… Core Data Stack The key objects of the stack are the… Read More »

How to write a custom content provider in android? with a sample application using our own custom content provider.

By | September 22, 2013

Hello all we all know what are content providers right? Those who are unaware of content providers please visit this link http://developer.android.com/guide/topics/providers/content-providers.html In a breif content Providers are Content providers manage access to a structured set of data. They encapsulate the data, and provide mechanisms for defining data security. Content providers are the standard interface… Read More »

How to get table values from a MySQL database and show it in Android as Tables.?

By | September 25, 2012

Here we are accessing a mysql database and get the table values and show it in the Android side as tables. These are some tutorials that I have posted on connection with php and getting tablevalues. 1. Android phpmySQL connection redone. 2. Simplest Lazy Loading ListView Example in Android with data populated from a MySQL… Read More »

How to Uninstall Avast Anti Theft for Android?

By | September 14, 2012

If you have installed Avast and the Avast anti theft application on your Android and decide you no longer need it, you may find it difficult to remove. It is protected so you first need to remove it’s protection. Here’s how to do it. Go to Device Settings Security Select Device Administrators – you can… Read More »

ListView with Sections in android.

By | February 24, 2012

Hello all………. We have seen many posts about ListViews like creating a listview, adding data to it, customizing a listview etc. Take a look at some of these examples 1. Single Selection ListView in android 2. Flitering a ListView using an input from an EditText in Android. 3. How to create a custom ListView in… Read More »

How to save data or score in Android Cocos2D?

By | January 21, 2012

Hello Friends Today I will show you how to save data in cocos2D android in a database and reload it when the game starts. This has been always a problem withe game developers for cocos2D android. I will show you a way to save almost any number of data in a database using SQlite in… Read More »