Aha, just stumbled across an article explaining this. Also Django have info on their NewbieMistakes page. The solution is to make sure the directory containing the database file also has write access allowed to the process. In my case, running this command fixed the problem: sudo chown www-data .
Using LIKE:
I found on the sqlite documentation (https://www.sqlite.org/lang_datefunc.html) this text: Compute the date and time given a unix timestamp 1092941466, and compensate for your local timezone. That didn’t look like it fit my needs, so I tried changing the “datetime” function around a bit, and wound up with this: That seems to work – is that … Read more
just wondering how i can create a temp table and then select from it further down the script. Example. Ideally I want to have a temp table then use it later in the script to reference from. Any help would be great!
SQLite has had to sacrifice other characteristics that some people find useful, such as high concurrency, fine-grained access control, a rich set of built-in functions, stored procedures, esoteric SQL language features, XML and/or Java extensions, tera- or peta-byte scalability, and so forth Source : Appropriate Uses For SQLite
I want to migrate my iPhone app to a new database version. Since I don’t have some version saved, I need to check if certain column names exist. This Stackoverflow entry suggests doing the select and parse the result. Is that the common way? Alternatives?
In windows you can try this program http://www.nirsoft.net/utils/opened_files_view.html to find out the process is handling db file. Try closed that program for unlock database In Linux and macOS you can do something similar, for example, if your locked file is development.db: $ fuser development.db This command will show what process is locking the file: > … Read more
IFNULL, see here: http://www.sqlite.org/lang_corefunc.html#ifnull no brackets around the function
From django doc: SQLite is meant to be a lightweight database, and thus can’t support a high level of concurrency. OperationalError: database is locked errors indicate that your application is experiencing more concurrency than sqlite can handle in default configuration. This error means that one thread or process has an exclusive lock on the database … Read more
Django NewbieMistakes PROBLEM You’re using SQLite3, your DATABASE_NAME is set to the database file’s full path, the database file is writeable by Apache, but you still get the above error. SOLUTION Make sure Apache can also write to the parent directory of the database. SQLite needs to be able to write to this directory. Make … Read more