Re: [sqlite] difference in file size netween MAC and Windows

thanks a lot. On Wed, Feb 26, 2014 at 5:34 PM, Clemens Ladisch wrote: > Lidia Kalinovsky wrote: > > Attached are 2 db empty (no data) files > > This list does not allow attachments. > > > There is big difference in file size - file created on Windows is match > > smaller

Re: [sqlite] How to Troubleshoot Disk I/O Error

On 2014/02/26 16:27, Richard Hipp wrote: LOG: os_win.c:33842: (33) winTruncate2(D:\blp\wintrv\smartclient\applications\appinfo.db-shm) - プロセス㠯ファイル㠫アクセス㠧ã 㠾㠛ん。別㠮プロセス㠌ファイル㠮一部をロムE‚¯ã —ã, extended-result-code: 1546 TRUNCATE

Re: [sqlite] difference in file size netween MAC and Windows

Lidia Kalinovsky wrote: > Attached are 2 db empty (no data) files This list does not allow attachments. > There is big difference in file size - file created on Windows is match > smaller than MAC one. Due to differences in the way these OSes report the sector size, the default page size is

Re: [sqlite] How to Troubleshoot Disk I/O Error

On Wed, Feb 26, 2014 at 9:04 AM, Akintoye Olorode (BLOOMBERG/ 731 LEXIN) < aolor...@bloomberg.net> wrote: > I recompiled with v 3.8.3.1 and enabled sqlite3_log (lines starting with > "LOG:" in output). Result below. Thanks. > > Thanks for the enhanced log. Very helpful! > LOG:

Re: [sqlite] System.Data.SQLite fails to load

On 26 Feb 2014, at 2:15pm, Incongruous wrote: > You've sparked my curiosity, what is this VEE programming language?

Re: [sqlite] System.Data.SQLite fails to load

You've sparked my curiosity, what is this VEE programming language? Is there a web site I can go to read more about it? -Original Message- From: Joe Mistachkin Sent: Tuesday, February 25, 2014 3:44 PM To: 'General Discussion of SQLite Database' Subject: Re: [sqlite] System.Data.SQLite

Re: [sqlite] How to Troubleshoot Disk I/O Error

I recompiled with v 3.8.3.1 and enabled sqlite3_log (lines starting with "LOG:" in output). Result below. Thanks. validate smartclient appinfo database OPEN name=D:\blp\wintrv\smartclient\applications\appinfo.db, pFile=214C18, flags=106, pOutFlags=12F09C OPEN file=2C,

[sqlite] difference in file size netween MAC and Windows

Hello Attached are 2 db empty (no data) files, created with same code. MAC.sqlite is created on MAC and Windows.sqlite is created on Windows. We use sqlite3.lib on Windows and libsqlite3.dylib on MAC. There is big difference in file size - file created on Windows is match smaller than MAC one.

Re: [sqlite] Problem with .mode line

Thank you very much! was the problem ! I have replaced it with the "\n" and now it works great !! -- View this message in context: http://sqlite.1065341.n5.nabble.com/Problem-with-mode-line-tp74045p74125.html Sent from the SQLite mailing list archive at Nabble.com.

Re: [sqlite] System.Data.SQLite fails to load

On 2/26/2014 5:50 AM, Simon Slavin wrote: On 26 Feb 2014, at 10:19am, William Drago wrote: VEE is a graphical programming language similar to NI LabView. Is this Agilent VEE ? If it's very like LabView then you shouldn't be using a .NET framework at all. The

Re: [sqlite] System.Data.SQLite fails to load

On 26 Feb 2014, at 10:19am, William Drago wrote: > VEE is a graphical programming language similar to NI LabView. Is this Agilent VEE ? If it's very like LabView then you shouldn't be using a .NET framework at all. The normal way to use SQLite is to call SQLite

Re: [sqlite] Question about how sqlite recovers after a power loss

Hi Richard, Many thanks for your input. My ideas about how sqlite works were indeed incorrect. When I say "re-opening" the database, I mean opening it and doing a few SELECT to it (as described in a previous email). So I do read it (especially the sqlite_master table), and still the journal

Re: [sqlite] Question about how sqlite recovers after a power loss

On Wed, Feb 26, 2014 at 3:33 AM, Fabrice Triboix wrote: > Hi Simon, > > If I run my program step-by-step, I can see that the sqlite database is > not modified when I do an INSERT. It is modified only when I do a COMMIT. > Correct. Changes are normally kept in memory

Re: [sqlite] Question about how sqlite recovers after a power loss

Hi Max, Many thanks for your input. This is probably how it works. Best regards, Fabrice --Original Message-- From: Max Vlasov To: Fabrice Triboix To: General Discussion of SQLite Database Subject: Re: [sqlite] Question about how sqlite recovers after a power loss Sent: 26 Feb 2014

Re: [sqlite] Question about how sqlite recovers after a power loss

On Wed, Feb 26, 2014 at 12:33 PM, Fabrice Triboix wrote: > > And even then, that would not explain why the journal file lingers after > re-opening the database. > I remember asking a similar question. As long as I remember, the main logical implication is that journal

Re: [sqlite] System.Data.SQLite fails to load

On 2/25/2014 3:44 PM, Joe Mistachkin wrote: William Drago wrote: I am using System.Data.SQLite with a relatively uncommon language called VEE. This is an interpreted language that runs in a 32bit development/runtime environment. I've never heard of this language before; however, it sounds

Re: [sqlite] Question about how sqlite recovers after a power loss

Hi Simon, If I run my program step-by-step, I can see that the sqlite database is not modified when I do an INSERT. It is modified only when I do a COMMIT. I read the page on the sqlite website detailing how sqlite deals with crashes and untimely power losses, and it says that the journal