Top "Sqlite" questions

Opening database file from within SQLite command-line shell

I'm using the SQLite Command Line Shell. As documented, I can open a database by supplying it as an argument …

sqlite

How to convert byte array to Bitmap

I want to store image in SQLite DataBase. I tried to store it using BLOB and String, in both cases …

android sqlite bitmap bytearray

sqlite database default time value 'now'

Is it possible in a sqlite database to craete a table that has a timestamp column that default to DATETIME(…

sql sqlite

How to perform an SQLite query within an Android application?

I am trying to use this query upon my Android database, but it does not return any data. Am I …

android sqlite android-sqlite

Unable to load DLL 'SQLite.Interop.dll'

Periodically I am getting the following exception: Unable to load DLL 'SQLite.Interop.dll': The specified module could not be …

c# visual-studio-2010 sqlite

Best way to work with dates in Android SQLite

I'm having some trouble working with dates on my Android application that uses SQLite. I have a couple questions: What …

android sql database sqlite date

List of tables, db schema, dump etc using the Python sqlite3 API

For some reason I can't find a way to get the equivalents of sqlite's interactive shell commands: .tables .dump using …

python api sqlite dump

SQLiteDatabase.query method

I am using the query method of SQLiteDatabase. How do I use the query method? I tried this: Cursor cursor = …

android sqlite

Convert MySQL to SQlite

Is it possible to convert from MySQL to SQLite with a free tool on windows?

mysql sqlite

How to connect SQLite with Java?

I am using one simple code to access the SQLite database from Java application . My code is import java.sql.…

java sqlite jdbc classpath