Change SQLite database mode to read-write

There can be several reasons for this error message: Several processes have the database open at the same time (see the FAQ). There is a plugin to compress and encrypt the database. It doesn’t allow to modify the DB. Lastly, another FAQ says: “Make sure that the directory containing the database file is also writable … Read more

Import CSV to SQLite

What also is being said in the comments, SQLite sees your input as 1, 25, 62, 7. I also had a problem with , and in my case it was solved by changing “separator ,” into “.mode csv”. So you could try: sqlite> create table foo(a, b); sqlite> .mode csv sqlite> .import test.csv foo The … Read more

Sqlite LIMIT / OFFSET query

The two syntax forms are a little confusing because they reverse the numbers: LIMIT <skip>, <count> Is equivalent to: LIMIT <count> OFFSET <skip> It’s compatible with the syntax from MySQL and PostgreSQL. MySQL supports both syntax forms, and its docs claim that the second syntax with OFFSET was meant to provide compatibility with PostgreSQL. PostgreSQL … Read more

How Scalable is SQLite? [closed]

Yesterday I released a small site* to track your rep that used a shared SQLite database for all visitors. Unfortunately, even with the modest load that it put on my host it ran quite slowly. This is because the entire database was locked every time someone viewed the page because it contained updates/inserts. I soon … Read more