Re: [sqlite] Test suite fails on AIX using xlc

2005-03-11 Thread Al Danial
On Fri, 11 Mar 2005 14:29:44 -0500, Andrew Shakinovsky <[EMAIL PROTECTED]> wrote: > Has anyone had any luck compiling SQLite successfully on this platform? > These are the results from the test suite (with some successful runs > removed to preserve space). > > AIX 5.2 Power4+ 64 bit using xlc

Re: [sqlite] thoughts on a web-based front end to sqlite3 db?

2005-03-11 Thread Ng Pheng Siong
On Fri, Mar 11, 2005 at 02:16:35PM -, Steve O'Hara wrote: > I'd like England to win the World Cup... I thought England did win the rugby World Cup the last time out? Oh, you mean _football_! ;-) -- Ng Pheng Siong <[EMAIL PROTECTED]> http://sandbox.rulemaker.net/ngps -+- M2Crypto,

Re: [sqlite] Sometimes it really is a hardware problem....

2005-03-11 Thread Scott Baker
If you're looking for a cool "test-suite" I highly recommend the Ultimate Boot CD. It includes approxmiately 8.7 million tools (not really, but it is a lot), one of which is MemTest86. http://www.ultimatebootcd.com/ It's solved ALL kinds of hardware issues. I highly recommend it. Jay wrote: ---

Re: [sqlite] Version 3.1.5

2005-03-11 Thread Gerald Dachs
On Fri, 11 Mar 2005 13:07:40 -0500 "D. Richard Hipp" <[EMAIL PROTECTED]> wrote: > Version 3.1.5 is now available on the website. This release > fixes a typo in the previous release that caused problems > for OS-X users. > -- > D. Richard Hipp <[EMAIL PROTECTED]> > 'make doc' on linux is still

[sqlite] How to set 'PRAGMA synchronous=on' permanently for a database?

2005-03-11 Thread Eric Hochmeister
Hi, I'm trying to figure out how to set the PRAGMA synchronous attribute to ON permanently for my database. I've read the pragma docs at (http://www.sqlite.org/pragma.html) and looked at the source code and haven't been able to figure it out. I am able to load up my database with sqlite3 and

Re: [sqlite] COMMIT versus END

2005-03-11 Thread Keith Herold
Right; I was thinking of checkpoint stuff, in a sense. Smaller transactions make things waaay slower :) . --Keith On Fri, 11 Mar 2005 14:03:45 -0500 (EST), Clay Dowling <[EMAIL PROTECTED]> wrote: > > Keith Herold said: > > I have a batch process that commits sets of 25 pre-built sql scripts >

[sqlite] Test suite fails on AIX using xlc

2005-03-11 Thread Andrew Shakinovsky
Has anyone had any luck compiling SQLite successfully on this platform? These are the results from the test suite (with some successful runs removed to preserve space). AIX 5.2 Power4+ 64 bit using xlc 7.0: The test aborted at some point before completion. attach2-4.1.1... Expected: [main

Re: [sqlite] Sometimes it really is a hardware problem....

2005-03-11 Thread Jay
--- "D. Richard Hipp" <[EMAIL PROTECTED]> wrote: > I find it utterly amazing that a machine with bad memory could > run a full-blown Linux desktop and a copy of Win2K running in > VMWare for days on end without showing a problem, then suddenly > begin having trouble with the SQLite regression

Re: [sqlite] Sometimes it really is a hardware problem....

2005-03-11 Thread Joel Lucsy
On Fri, 11 Mar 2005 13:48:07 -0500, D. Richard Hipp <[EMAIL PROTECTED]> wrote: > some errors popped up. On a 512MB SIMM, less than 10 memory cells > where showing a problem, and then only if a specific bit pattern > was written into adjacent cells. The error was always in the > 0x08 bit. I

[sqlite] Sometimes it really is a hardware problem....

2005-03-11 Thread D. Richard Hipp
I've been struggling for days to get version 3.1.4 out. Every time I would run the regression test I would get failures. The failures would not always be at the same place, but I would always get one or two. I frequently got failures in the memory-db tests where we create a large in-memory

Re: [sqlite] COMMIT versus END

2005-03-11 Thread D. Richard Hipp
On Fri, 2005-03-11 at 10:20 -0800, Keith Herold wrote: > Is there a difference between COMMIT and END TRANSACTION ? > > I have a batch process that commits sets of 25 pre-built sql scripts > on a timed basis. I have been wrapping the execution of all 25 sets > in a single begin...end transaction

[sqlite] COMMIT versus END

2005-03-11 Thread Keith Herold
Is there a difference between COMMIT and END TRANSACTION ? I have a batch process that commits sets of 25 pre-built sql scripts on a timed basis. I have been wrapping the execution of all 25 sets in a single begin...end transaction set. The problem is that if any of those scripts fails to

[sqlite] Version 3.1.5

2005-03-11 Thread D. Richard Hipp
Version 3.1.5 is now available on the website. This release fixes a typo in the previous release that caused problems for OS-X users. -- D. Richard Hipp <[EMAIL PROTECTED]>

Re: [sqlite] SQLite v3.1.4 - Mac OS X 10.3.8 compile issues

2005-03-11 Thread bbum
On Mar 11, 2005, at 8:09 AM, Eric Hochmeister wrote: I just noticed that a new version of SQLite 3.1.4 was up, so I downloaded it and can't seem to get it to compile. I have successfully been using previous versions of SQLite (3.1.3, 3.0.8, etc.) and this is the first time I've received an issue

[sqlite] SQLite v3.1.4 - Mac OS X 10.3.8 compile issues

2005-03-11 Thread Eric Hochmeister
Hi, I just noticed that a new version of SQLite 3.1.4 was up, so I downloaded it and can't seem to get it to compile. I have successfully been using previous versions of SQLite (3.1.3, 3.0.8, etc.) and this is the first time I've received an issue compiling. Does anyone have any ideas? I'm

Re: [sqlite] Version 3.1.4

2005-03-11 Thread Gerald Dachs
> SQLite version 3.1.4 is now available on the website. > http://www.sqlite.org/ > 'make doc' on linux is still broken, attached patch for 3.1.3 still works. Gerald --- sqlite-3.1.3/Makefile.in.orig 2005-03-07 22:56:04.833954328 +0100 +++ sqlite-3.1.3/Makefile.in2005-03-07

RE: [sqlite] thoughts on a web-based front end to sqlite3 db?

2005-03-11 Thread mike . griffin
For what it's worth, if your in a hurry, try our product, it's Free. Basically, you launch our product, connect to your database and we'll spit out fully functional VB.NET or C# data/business entities using your database meta-data as the input. These objects (classes) do mostly everything that you

[sqlite] Version 3.1.4

2005-03-11 Thread D. Richard Hipp
SQLite version 3.1.4 is now available on the website. http://www.sqlite.org/ Version 3.1.4 fixes a bug in the new autovacuum code that could lead to database corruption. Database corruption will only occur if all of the following are true: * Autovacuum mode is on. (It is off by default)

RE: [sqlite] thoughts on a web-based front end to sqlite3 db?

2005-03-11 Thread Steve O'Hara
I'd like England to win the World Cup... Perhaps we can do a swap. -Original Message- From: Dinsmore, Jeff [mailto:[EMAIL PROTECTED] Sent: 08 March 2005 13:58 To: sqlite-users@sqlite.org Subject: RE: [sqlite] thoughts on a web-based front end to sqlite3 db? I personally would

RE: [sqlite] thoughts on a web-based front end to sqlite3 db?

2005-03-11 Thread Steve O'Hara
Here's my tuppence worth. I come from an engineering background where you're taught that rigour is the most important feature of any development. I find that all the interpreted environments tend not to be that great in this regard. Also, I don't have an axe to grind when it comes to