sqlite Archives - Page 5 of 5

SQLite – UPSERT not INSERT or REPLACE

http://en.wikipedia.org/wiki/Upsert Insert Update stored proc on SQL Server Is there some clever way to do this in SQLite that I have not thought ...

April 30, 2022
0 Comments

Is it possible to insert multiple rows at a time in an SQLite database?

In MySQL you can insert multiple rows like this: INSERT INTO 'tablename' ('column1', 'column2') VALUES ('data1', 'data2'), ('data1', 'data2'), ('data1', 'data2'), ('data1', 'data2'); ...

April 29, 2022
0 Comments

Sqlite primary key on multiple columns

What is the syntax for specifying a primary key on more than 1 column in SQLITE ? 9 s 9 According to the ...

April 27, 2022
0 Comments

How can I avoid concurrency problems when using SQLite on Android?

What would be considered the best practices when executing queries on an SQLite database within an Android app? Is it safe to run ...

April 26, 2022
0 Comments

How do I check in SQLite whether a table exists?

How do I, reliably, check in SQLite, whether a particular user table exists? I am not asking for unreliable ways like checking if ...

April 15, 2022
0 Comments

How can I list the tables in a SQLite database file that was opened with ATTACH?

What SQL can be used to list the tables, and the rows within those tables in an SQLite database file – once I ...

April 13, 2022
0 Comments

Improve INSERT-per-second performance of SQLite

Optimizing SQLite is tricky. Bulk-insert performance of a C application can vary from 85 inserts per second to over 96,000 inserts per second! ...

April 10, 2022
0 Comments

java.lang.ClassNotFoundException: org.sqlite.JDBC error in Sample.java program from xerial

Thanks to user phew for the help/ideas. I missed the obvious command line instructions on Xerial’s site for the Sample program. To get ...

April 5, 2022
0 Comments