Re: [sqlite] How much disk space is required to checkpoint?

2012-09-28 Thread David Barrett
On Fri, Sep 28, 2012 at 10:49 AM, Jay A. Kreibich wrote: > The standard C I/O library includes the tmpfile() call, which performs > the whole process of generating a random temporary file name, opening > the file, and then unlinking the file. Wow, very interesting, thank you. I stand cor

Re: [sqlite] Issue with SQLite3 for WinRT ARM

2012-09-28 Thread Christian Le Gall
Sorry about that. Here is the project: http://dl.dropbox.com/u/4076650/Direct3DApp_ProblemExample.zip > This typically indicates a bug in your program, such as threading > issues, objects used after being freed, or just general memory > corruption. Typically I would agree with you but in the cas

Re: [sqlite] How much disk space is required to checkpoint?

2012-09-28 Thread Jay A. Kreibich
On Wed, Sep 26, 2012 at 02:59:12PM +0100, Simon Slavin scratched on the wall: > Allow me to present an alternative point of view. > > If filling up your filespace is causing you to crash, it's easier to > understand what's going on if you can see the files which are filling > it up. Running out

Re: [sqlite] Sending SQLite3 .timeout command in Command-Line Mode

2012-09-28 Thread John
I used the following to upgrade SQLite 3 on 10.6.8. I now have version 3.6.12 installed in /usr/bin/ and version 3.7.14 installed in /usr/local/bin/. Was this the best way to install it? mkdir ~/tempFolder cd ~/tempFolder curl https://www.sqlite.org/sqlite-autoconf-3071400.tar.gz | tar xvz cd sqli

[sqlite] Win CE support for WAL

2012-09-28 Thread Caleb A. Austin
I have looked over the forums, but have not seen a recent answer to this question, so I will ask it again. Is WAL mode supported if SQLite is used on Windows CE(WEC7)? Also are there any users that are using SQLite on WEC7 that would share there experiences? Thanks Caleb Austin ##

Re: [sqlite] Sending SQLite3 .timeout command in Command-Line Mode

2012-09-28 Thread Jay A. Kreibich
On Thu, Sep 27, 2012 at 10:15:14AM -0400, John scratched on the wall: > As you can tell, I don't have much experience with sql. I was going in the > timeout direction because simply resending the command several seconds > after the locked error occurred seemed to return the correct value. My plan >

Re: [sqlite] Switching journal mode from WAL to DELETE results in SQLITE_IOERR rather than SQLITE_READONLY (bug?)

2012-09-28 Thread Sebastian Krysmanski
Ok, then: is this the expected behavior? On Fri, Sep 28, 2012 at 3:29 PM, Richard Hipp wrote: > On Fri, Sep 28, 2012 at 9:23 AM, Sebastian Krysmanski > wrote: > > > Yes, I know that. It's just that the error code reported by > > "sqlite3_step()" is inconsistent. > > > > I "bug" means that the wr

Re: [sqlite] Switching journal mode from WAL to DELETE results in SQLITE_IOERR rather than SQLITE_READONLY (bug?)

2012-09-28 Thread Richard Hipp
On Fri, Sep 28, 2012 at 9:23 AM, Sebastian Krysmanski wrote: > Yes, I know that. It's just that the error code reported by > "sqlite3_step()" is inconsistent. > I "bug" means that the wrong answer is computed. I don't think getting a slightly different error code for an illegal operation when pe

Re: [sqlite] Switching journal mode from WAL to DELETE results in SQLITE_IOERR rather than SQLITE_READONLY (bug?)

2012-09-28 Thread Sebastian Krysmanski
Yes, I know that. It's just that the error code reported by "sqlite3_step()" is inconsistent. On Fri, Sep 28, 2012 at 3:21 PM, Richard Hipp wrote: > On Fri, Sep 28, 2012 at 9:09 AM, Sebastian Krysmanski > wrote: > > > Hi, > > > > I'm working on a C# SQLite wrapper and have created some unit test

Re: [sqlite] Switching journal mode from WAL to DELETE results in SQLITE_IOERR rather than SQLITE_READONLY (bug?)

2012-09-28 Thread Richard Hipp
On Fri, Sep 28, 2012 at 9:09 AM, Sebastian Krysmanski wrote: > Hi, > > I'm working on a C# SQLite wrapper and have created some unit tests. One of > them checks the behavior when changing the permanent journal mode of a > database (from DELETE to WAL and the other way around) while the database >

Re: [sqlite] Issue with SQLite3 for WinRT ARM

2012-09-28 Thread Richard Hipp
On Fri, Sep 28, 2012 at 9:06 AM, Clemens Ladisch wrote: > Christian Le Gall wrote: > > I have included an example project > > ... and the mailing list server has stripped it. > Please put it somewhere on the web. > The SQLite developers got the project files last night, through a back-channel.

[sqlite] Switching journal mode from WAL to DELETE results in SQLITE_IOERR rather than SQLITE_READONLY (bug?)

2012-09-28 Thread Sebastian Krysmanski
Hi, I'm working on a C# SQLite wrapper and have created some unit tests. One of them checks the behavior when changing the permanent journal mode of a database (from DELETE to WAL and the other way around) while the database is in read-only mode. Here's what I do basically: 1. Open new database i

Re: [sqlite] Issue with SQLite3 for WinRT ARM

2012-09-28 Thread Clemens Ladisch
Christian Le Gall wrote: > I have included an example project ... and the mailing list server has stripped it. Please put it somewhere on the web. > The error I am getting is generally "critical error detected c000374" which > my research tells me is a corrupted heap. This typically indicates a

[sqlite] Issue with SQLite3 for WinRT ARM

2012-09-28 Thread Christian Le Gall
Hey, We need to use SQLite3 for a game we are building on the WinRT platform, the same codebase has worked for a long time but doesn't work when compiling for the WinRT ARM platform. I have tried using the SQLite for Windows Runtime Visual Studio extension (visx) as well as the latest source amalg

Re: [sqlite] ATTACH DATABASE question

2012-09-28 Thread Wolfgang Enzinger
Am Thu, 27 Sep 2012 20:31:36 -0700 schrieb john_prov...@yahoo.com: > I’m confused about how to attach a database file to an existing > database. I open my main database ok, then to attach the second > database, I try to execute the following SQL: > > ATTACH DATABASE ‘c:\mydata\my_attach_database.