Sqlite Browser goes non responsive while inserting data into sqlite

Sqlite Browser goes non responsive while inserting data into sqlite

I am developing and android application for ELearning purpose.Now in this application I want to store the questions and answers in the sqlite database.My following query works fine when the question/answer is of 1 line … Read the rest “Sqlite Browser goes non responsive while inserting data into sqlite”

Offline Android application with online syncing

Offline Android application with online syncing

I am developing an Android application that would have an offline data in start and online syncing. That means: user clicks on an item and application reads data for that item from offline (SQLite database or file) and displays … Read the rest “Offline Android application with online syncing”

Unsupported type mapping for SqLite + EntityFramework 5/6

Unsupported type mapping for SqLite + EntityFramework 5/6

I’m trying to create C# app under VS 2012 (.NET 4.5) with usage of SqLite managed by EntityFramework 6.0 (also 5.0 was tried out).
My steps were following:

Install sqlite-netFx45-setup-bundle-x86-2012-1.0.85.0.exe from http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki
It installs components for VS2012… Read the rest “Unsupported type mapping for SqLite + EntityFramework 5/6”

Retrieving data from database to listview failed

Retrieving data from database to listview failed

My program contains an Activity class and a database class. The code I used to save the database values to ListView has some problems.
The following is an inner class in the Activity:
class getclicker extends ListActivity implements … Read the rest “Retrieving data from database to listview failed”

Simple SD card compatible database / NoSql solution for Windows Phone 8

Simple SD card compatible database / NoSql solution for Windows Phone 8

Does anyone know of a good database or NoSql engine for Windows Phone 8 that can be used by my app?
I need to be able to open a read-only database file from … Read the rest “Simple SD card compatible database / NoSql solution for Windows Phone 8”

SQLiteAssetHelper NullPointerException only on some devices

SQLiteAssetHelper NullPointerException only on some devices

I am using SQLiteAssetHelper library to deal with my App DB operations and it’s working fine for almost every phone I’ve tested with. However some users with Android 2.3.3 – 2.3.7 report crashes when a call to open the … Read the rest “SQLiteAssetHelper NullPointerException only on some devices”

Sqlite Database – How to save Image taken from camera intent as well as hashmap to sqlite to retrieve later?

Sqlite Database – How to save Image taken from camera intent as well as hashmap to sqlite to retrieve later?

I am having endless problem with my app, I am busy making an app where the user can take a picture from the point tapped … Read the rest “Sqlite Database – How to save Image taken from camera intent as well as hashmap to sqlite to retrieve later?”

Add new column to sqlite in app new version (iOS) [duplicate]

Add new column to sqlite in app new version (iOS) [duplicate]

I have an app with version 1.0 on app store which uses sqlite database for reading the data.Now I want to update my version to 1.1 with update in database file.While using developer certificate … Read the rest “Add new column to sqlite in app new version (iOS) [duplicate]”

How change the database journal mode

How change the database journal mode

When I create a DataBase on my apply, I have this error:

Could not change the database journal mode of
‘/data/data/example/databases/exemple’ from ‘wal’ to ‘PERSIST’ because
the database is locked. This usually means that there are other open
connections … Read the rest “How change the database journal mode”