Re: [sqlite] Joining list?

2017-09-29 Thread bensonbear
aps writes: | I am trying to join the sqlite3-users list to ask a | technical question but I never receive a response from the | Mailman (and no it isn't in my Spam folder either). Oops, I also was trying to join and also kept not getting responses. Also it told me I was not a subscriber when I

Re: [sqlite] All of a sudden I must commit after every single change and I don't know what happened.

2017-09-28 Thread bensonbear
Ryan writes: | just to be clear: It's not that SQLite commits after every | statement - In SQLite, unless you have explicitly opened a | transaction (using BEGIN), every statement is (and must be) | in and of itself a transaction. Right, I didn't say it committed after every statement, just

Re: [sqlite] All of a sudden I must commit after every single change and I don't know what happened.

2017-09-27 Thread bensonbear
D.Richard Hipp writes: | Good question. I suspect that whatever is going wrong has little or | nothing to do with SQLite, though. What other debugging steps have | you taken? I could not think of anything very useful to try, but in any case I found pretty quickly that the problem was the

[sqlite] All of a sudden I must commit after every single change and I don't know what happened.

2017-09-26 Thread bensonbear
I have an sqlite3 database I use for a web app that I am mostly the sole user of. It has been working fine for years, but all of a sudden today, I find that the app cannot insert and delete items from the database when it needs to. This is an app with a single thread, and for each command the