Top "Sqlite" questions

SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine.

How do i order my SQLITE database in descending order, for an android app?

What is the most efficient method of showing my data in descending order? public String getRank() { String[] rank = new String[]{ …

android sqlite sql-order-by
When is SQLiteOpenHelper onCreate() / onUpgrade() run?

I have created my tables in my SQLiteOpenHelper onCreate() but receive SQLiteException: no such table or SQLiteException: no such column …

android sqlite android-sqlite sqlexception sqliteopenhelper
How to retrieve inserted id after inserting row in SQLite using Python?

How to retrieve inserted id after inserting row in SQLite using Python? I have table like this: id INT AUTOINCREMENT …

python sqlite
SQLite3 database or disk is full / the database disk image is malformed

My database is about 25 MB, and I've verified that the username accessing it, as well as the file permissions haven't …

file sqlite filesystems corruption
Delete column from SQLite table

I have a problem: I need to delete a column from my SQLite database. I wrote this query alter table …

sql sqlite ddl
SQLite: How do I save the result of a query as a CSV file?

I'm new to SQLite. Is there a way I can export the results of a query into a CSV file?

sqlite csv
How does one check if a table exists in an Android SQLite database?

I have an android app that needs to check if there's already a record in the database, and if not, …

android database sqlite
Attempt to write a readonly database - Django w/ SELinux error

I have a CentOS server on which I have Apache, Django, Django CMS and mod_wsgi. My Django project files …

django sqlite selinux
OperationalError: database is locked

I have made some repetitive operations in my application (testing it), and suddenly I’m getting a weird error: OperationalError: …

python django database sqlite locked
How to retrieve the last autoincremented ID from a SQLite table?

I have a table Messages with columns ID (primary key, autoincrement) and Content (text). I have a table Users with …

database sqlite primary-key auto-increment junction-table