[sqlite] What to do with a .journal file

I had a process that was writing a sqlite database when the computer crashed. I now have two files: f6.db and f6.db-journal. How do I get the information in the journal file to be incorporated in the database?  I tried open f6.db in the sqlite3 console program, and afterwards the journal file

Re: [sqlite] CSV import deletes trailing zeroes on text fields

1. Rename .csv to .txt2. Excel will now ask for column treatment on import3. Specify the problem column(s) as "text" not "general" There are other problems with csv recognizing text as numbers. I had a column with content, say 123D4. Excel recognized the old FORTRAN double precision format and

Re: [sqlite] Minor typo in example

Two more in here: or an ISO-8601 dates string. But some application store dates On Friday, October 14, 2016 12:27 PM, Robert Weiss <weiss...@yahoo.com> wrote: While we're on the subject there are at least two grammatical errors on the same page: there is no substit

Re: [sqlite] Minor typo in example

While we're on the subject there are at least two grammatical errors on the same page: there is no substitutions  and A NULL means of "unknown" On Friday, October 14, 2016 12:20 PM, David Raymond wrote: In the Row Values page

Re: [sqlite] Query time execution difference between my application and SQLiteBrowser

I haven't gone through the previous emails to see whether anyone has proposed this, but it seems possible to me that the GUI tool (oriented as it is to interaction) is not waiting for the query to finish before displaying the first results. On Wednesday, September 7, 2016 7:21 AM, Laura

[sqlite] SQLITE_USER_AUTHENTICATION

Tthe documentation says to use the flag as? -DSQLITE_USER_AUTHENTICATION whereas in your message you said you used? -D_SQLITE_USER_AUTHENTICATION So unless cl ignores a leading underscore (seems unlikely), you're defining something the code doesn't care about. On Monday, March 14, 2016

[sqlite] How to check if connection to main database is still open or closed before new query ?

Another tactic: ?why not try a simple query such as "SELECT SQLITE_VERSION()"? ?If you get a decent answer you have verified your connection and can execute your actual query. On Tuesday, March 1, 2016 2:41 PM, Keith Medcalf wrote: After you close the connection and verify the return

[sqlite] Is there an index of conformances and deviations against standard SQL?

In partial answer to the original question: http://sqlite.org/omitted.html http://sqlite.org/nulls.html http://sqlite.org/conflict.html Furthermore any non-standard extension, such as FTS3 and ATTACH, might be regarded as a deviation from the standard. And after consulting

[sqlite] Build fail: undefined reference to `pthread_create'

A few builds ago I got a similar message. ?I don't recall whether I actively tried to use threads or got blindsided by change. ?The short story is that linking in libpthread caused the build to succeed. ?The longer story is that threads were unreliable in my environment (Windows/cygwin), caused

[sqlite] SQLite crash

: Robert Weiss wrote: > > [continuing from previous gdb output]:(gdb) thread apply all where 15 > Thread 6 (Thread 12300.0xa64):#0 ?0x74d66d61 in sysfer!FirstHookFunc () > from /cygdrive/c/Windows/SysWOW64/SYSFER.DLL#1 ?0x in ?? () > Anyhow, the cause of this appears to be

[sqlite] SQLite crash

wrote: On 08/12/2015 02:15 AM, Robert Weiss wrote: > The bug seems to be repeatable.? At least, it happened again today. > I haven't used gdb in a long time.? Here's my first crack at it; what else > should I do? > $ gdb sqliteGNU gdb (GDB) 7.8Copyright (C) 2014 Free Softwar

[sqlite] SQLite crash

ching to Thread 12300.0xa64]0x74d66d61 in sysfer!FirstHookFunc () from /cygdrive/c/Windows/SysWOW64/SYSFER.DLL(gdb) bt#0 ?0x74d66d61 in sysfer!FirstHookFunc () from /cygdrive/c/Windows/SysWOW64/SYSFER.DLL#1 ?0x in ?? () On Tuesday, August 11, 2015 1:43 AM, Dan Kennedy wrote:

[sqlite] SQLite crash

Dan Kennedy-- What address, precisely, should I use to send the database to you? ?When I "reply" to your message I get the whole SQLite discussion group, which is what I want to avoid (no offense intended, guys and gals). BTW, the problem does not seem to occur in version 3.8.10.2. Ro

[sqlite] SQLite crash

by those tracking down the bug. Robert Weiss