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 7.0:
> The test aborted at some point before completion.
> 
> attach2-4.1.1...
> Expected: [main unlocked temp closed file2 unlocked]
>  Got: []
> attach2-4.1.2...
> Expected: [main unlocked temp closed file2 unlocked]
>  Got: []
> attach2-4.2... Ok
> attach2-4.2.1...
> Expected: [main shared temp closed file2 unlocked]
>  Got: []
> attach2-4.2.2...
> Expected: [main unlocked temp closed file2 unlocked]
>  Got: []
> attach2-4.3... Ok
> attach2-4.3.1...
> Expected: [main shared temp closed file2 unlocked]
>  Got: []
> attach2-4.3.2...
> Expected: [main unlocked temp closed file2 unlocked]
>  Got: []
> attach2-4.4... Ok
> attach2-4.4.1...
> Expected: [main shared temp closed file2 unlocked]
>  Got: []
> attach2-4.4.2...
> Expected: [main unlocked temp closed file2 unlocked]
>  Got: []
> attach2-4.5... Ok
> attach2-4.5.1...
> Expected: [main shared temp closed file2 unlocked]
>  Got: []
> attach2-4.5.2...
> Expected: [main unlocked temp closed file2 reserved]
>  Got: []
> attach2-4.6.1... Ok
> attach2-4.6.1.1...
> Expected: [main shared temp closed file2 shared]
>  Got: []
> attach2-4.6.1.2...
> Expected: [main unlocked temp closed file2 reserved]
>  Got: []
> attach2-4.6.2... Ok
> attach2-4.6.2.1...
> Expected: [main shared temp closed file2 shared]
>  Got: []
> attach2-4.6.2.2...
> Expected: [main unlocked temp closed file2 reserved]
>  Got: []
> attach2-4.7... Ok
> attach2-4.7.1...
> Expected: [main shared temp closed file2 shared]
>  Got: []
> attach2-4.7.2...
> Expected: [main reserved temp closed file2 reserved]
>  Got: []
> attach2-4.8... Ok
> attach2-4.8.1...
> Expected: [main shared temp closed file2 shared]
>  Got: []
> attach2-4.8.2...
> Expected: [main reserved temp closed file2 reserved]
>  Got: []
> attach2-4.9... Ok
> attach2-4.9.1...
> Expected: [main shared temp closed file2 shared]
>  Got: []
> attach2-4.9.2...
> Expected: [main reserved temp closed file2 reserved]
>  Got: []
> attach2-4.10... Ok
> attach2-4.10.1...
> Expected: [main shared temp closed file2 shared]
>  Got: []
> attach2-4.10.2...
> Expected: [main pending temp closed file2 reserved]
>  Got: []
> attach2-4.11... Ok
> attach2-4.11.1...
> Expected: [main unlocked temp closed file2 unlocked]
>  Got: []
> attach2-4.11.2...
> Expected: [main pending temp closed file2 reserved]
>  Got: []
> attach2-4.12...
> Expected: [0 {}]
>  Got: [1 {disk I/O error}]
> attach2-4.12.1...
> Expected: [main unlocked temp closed file2 unlocked]
>  Got: []
> attach2-4.12.2...
> Expected: [main unlocked temp closed file2 unlocked]
>  Got: []
> attach2-4.13... Ok
> attach2-4.14... Ok
> attach2-4.15...
> Expected: [1 2 1 2]
>  Got: [1 2]
> attach2-5.1... Ok
> attach2-5.2...
> Error: disk I/O error
> autovacuum-ioerr-2.2.1...
> Error: no such function: randstr
> autovacuum-ioerr-2.2.2... Ok
> autovacuum-ioerr-2.2.3...
> Expected: [1]
>  Got: [0]
> autovacuum-ioerr-3.1.1...
> Error: no such function: randstr
> autovacuum-ioerr-3.1.2... Ok
> autovacuum-ioerr-3.1.3...
> Expected: [1]
>  Got: [0]
> autovacuum-ioerr-5.1.3...
> Expected: [1]
>  Got: [0]
> autovacuum-ioerr-7.2.1... Ok
> autovacuum-ioerr-7.2.2... Ok
> autovacuum-ioerr-7.2.3... Ok
> autovacuum-ioerr2-1.1.1...
> Error: no such function: randstr
> autovacuum-ioerr2-1.1.2... Ok
> autovacuum-ioerr2-1.1.3...
> Expected: [1]
>  Got: [0]
> autovacuum-ioerr2-2.1.1...
> Error: no such function: randstr
> autovacuum-ioerr2-2.1.2... Ok
> autovacuum-ioerr2-2.1.3...
> Expected: [1]
>  Got: [0]
> autovacuum-ioerr2-3.1.1... Ok
> autovacuum-ioerr2-3.1.2... Ok
> autovacuum-ioerr2-3.1.3... Ok
> autovacuum-ioerr2-4.1.1...
> Error: no such function: randstr
> autovacuum-ioerr2-4.1.2... Ok
> autovacuum-ioerr2-4.1.3...
> Expected: [1]
>  Got: [0]
> bigfile-1.1... Ok
> bigfile-1.2...
> Error: file is encrypted or is not a database
> bigfile-1.3...
> Error: file is encrypted or is not a database
> bigfile-1.4...
> Error: file is encrypted or is not a database
> bigfile-1.5...
> Error: file is encrypted or is not a database
> bigfile-1.6...
> Error: file is encrypted or is not a database
> bigfile-1.7...
> Error: file is encrypted or is not a database
> bigfile-1.8...
> Error: file is encrypted or is not a database
> bigfile-1.9...
> Error: file is encrypted or is not a database
> bigfile-1.10...
> Error: file is encrypted or is not a database
> bigfile-1.11...
> Error: file is encrypted or is not a database
> bigfile-1.12...
> Error: file is encrypted or is not a database
> bigfile-1.13...
> Error: file is encrypted or is not a database
> bigfile-1.14...
> Error: file is encrypted or is not a 

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, ZServerSSL for Zope, Blog
http://www.sqlcrypt.com -+- Database Engine with Transparent AES Encryption


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:
--- "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 suite.  Yet that
is what appears to have happened.

I had the same sort of thing happen. The machine just would not
compile the linux source. Luckily it had different errors each time
which is what tripped me to look for a hardware problem.
http://www.memtest86.com/
Has a nifty tester with an ISO image. You can make a bootable cd
to test your machine. It makes a great addition to your test tools
suite.

		
__ 
Do you Yahoo!? 
Yahoo! Mail - now with 250MB free storage. Learn more. 
http://info.mail.yahoo.com/mail_250


--
Scott Baker
Canby Telephone - Network Administrator - RHCE
Ph: 503.266.8253


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 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 22:56:41.189427456
+0100 @@ -451,6 +451,9 @@
 arch.html: $(TOP)/www/arch.tcl
tclsh $(TOP)/www/arch.tcl >arch.html

+arch.png:  $(TOP)/www/arch.png
+   cp $(TOP)/www/arch.png .
+
 arch2.gif: $(TOP)/www/arch2.gif
cp $(TOP)/www/arch2.gif .




[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 send the PRAGMA
synchronous=on; command which sets it only for the duration that I'm
using sqlite3 to view/manipulate the database.  Once I quit and access
it again, the synchronous attribute is reset.

How can I save the PRAGMA synchronous attribute to be equal to 'ON'
permanently? (so that its saved in the database)


Thanks,

Eric


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
> > 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 execute properly, than all 25 scripts are
> > rolled back.  It would be nice to get a bit better granuality, with
> > partial commits or something.
> 
> That's pretty much the definition of a transaction.  Everything succeeds
> or everything fails.  Smaller transactions are what you want.  The things
> that should succeed or fail together go in the same transaction.
> 
> Clay Dowling
> --
> Lazarus Notes from Lazarus Internet Development
> http://www.lazarusid.com/notes/
> Articles, Reviews and Commentary on web development
> 


-- 
**
- Ever notice how 'big' isn't, compared to 'small'?

- I'm not a professional; I just get paid to do this.

- Rules for programming:
   1.  Get it working, right?
   2.  Get it working right.

- Things I've learned about multithreaded programming:

123...   PPArrvooottieedcc ttm  ueelvvteeirrtyyhtt
rhheiianndgge  dwi hnpi rctohhg eri aslm omscitanalgt 
 iowcbh,je engceltvo ebwrah lip,co hso srci abonlt ehb
.ee^Nr waicscee snsoetd  'aotb jtehcet -slaomcea lt'il
m^Ne from two or more threads
**


[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 unlocked temp closed file2 unlocked]
 Got: []
attach2-4.1.2...
Expected: [main unlocked temp closed file2 unlocked]
 Got: []
attach2-4.2... Ok
attach2-4.2.1...
Expected: [main shared temp closed file2 unlocked]
 Got: []
attach2-4.2.2...
Expected: [main unlocked temp closed file2 unlocked]
 Got: []
attach2-4.3... Ok
attach2-4.3.1...
Expected: [main shared temp closed file2 unlocked]
 Got: []
attach2-4.3.2...
Expected: [main unlocked temp closed file2 unlocked]
 Got: []
attach2-4.4... Ok
attach2-4.4.1...
Expected: [main shared temp closed file2 unlocked]
 Got: []
attach2-4.4.2...
Expected: [main unlocked temp closed file2 unlocked]
 Got: []
attach2-4.5... Ok
attach2-4.5.1...
Expected: [main shared temp closed file2 unlocked]
 Got: []
attach2-4.5.2...
Expected: [main unlocked temp closed file2 reserved]
 Got: []
attach2-4.6.1... Ok
attach2-4.6.1.1...
Expected: [main shared temp closed file2 shared]
 Got: []
attach2-4.6.1.2...
Expected: [main unlocked temp closed file2 reserved]
 Got: []
attach2-4.6.2... Ok
attach2-4.6.2.1...
Expected: [main shared temp closed file2 shared]
 Got: []
attach2-4.6.2.2...
Expected: [main unlocked temp closed file2 reserved]
 Got: []
attach2-4.7... Ok
attach2-4.7.1...
Expected: [main shared temp closed file2 shared]
 Got: []
attach2-4.7.2...
Expected: [main reserved temp closed file2 reserved]
 Got: []
attach2-4.8... Ok
attach2-4.8.1...
Expected: [main shared temp closed file2 shared]
 Got: []
attach2-4.8.2...
Expected: [main reserved temp closed file2 reserved]
 Got: []
attach2-4.9... Ok
attach2-4.9.1...
Expected: [main shared temp closed file2 shared]
 Got: []
attach2-4.9.2...
Expected: [main reserved temp closed file2 reserved]
 Got: []
attach2-4.10... Ok
attach2-4.10.1...
Expected: [main shared temp closed file2 shared]
 Got: []
attach2-4.10.2...
Expected: [main pending temp closed file2 reserved]
 Got: []
attach2-4.11... Ok
attach2-4.11.1...
Expected: [main unlocked temp closed file2 unlocked]
 Got: []
attach2-4.11.2...
Expected: [main pending temp closed file2 reserved]
 Got: []
attach2-4.12...
Expected: [0 {}]
 Got: [1 {disk I/O error}]
attach2-4.12.1...
Expected: [main unlocked temp closed file2 unlocked]
 Got: []
attach2-4.12.2...
Expected: [main unlocked temp closed file2 unlocked]
 Got: []
attach2-4.13... Ok
attach2-4.14... Ok
attach2-4.15...
Expected: [1 2 1 2]
 Got: [1 2]
attach2-5.1... Ok
attach2-5.2...
Error: disk I/O error
autovacuum-ioerr-2.2.1...
Error: no such function: randstr
autovacuum-ioerr-2.2.2... Ok
autovacuum-ioerr-2.2.3...
Expected: [1]
 Got: [0]
autovacuum-ioerr-3.1.1...
Error: no such function: randstr
autovacuum-ioerr-3.1.2... Ok
autovacuum-ioerr-3.1.3...
Expected: [1]
 Got: [0]
autovacuum-ioerr-5.1.3...
Expected: [1]
 Got: [0]
autovacuum-ioerr-7.2.1... Ok
autovacuum-ioerr-7.2.2... Ok
autovacuum-ioerr-7.2.3... Ok
autovacuum-ioerr2-1.1.1...
Error: no such function: randstr
autovacuum-ioerr2-1.1.2... Ok
autovacuum-ioerr2-1.1.3...
Expected: [1]
 Got: [0]
autovacuum-ioerr2-2.1.1...
Error: no such function: randstr
autovacuum-ioerr2-2.1.2... Ok
autovacuum-ioerr2-2.1.3...
Expected: [1]
 Got: [0]
autovacuum-ioerr2-3.1.1... Ok
autovacuum-ioerr2-3.1.2... Ok
autovacuum-ioerr2-3.1.3... Ok
autovacuum-ioerr2-4.1.1...
Error: no such function: randstr
autovacuum-ioerr2-4.1.2... Ok
autovacuum-ioerr2-4.1.3...
Expected: [1]
 Got: [0]
bigfile-1.1... Ok
bigfile-1.2...
Error: file is encrypted or is not a database
bigfile-1.3...
Error: file is encrypted or is not a database
bigfile-1.4...
Error: file is encrypted or is not a database
bigfile-1.5...
Error: file is encrypted or is not a database
bigfile-1.6...
Error: file is encrypted or is not a database
bigfile-1.7...
Error: file is encrypted or is not a database
bigfile-1.8...
Error: file is encrypted or is not a database
bigfile-1.9...
Error: file is encrypted or is not a database
bigfile-1.10...
Error: file is encrypted or is not a database
bigfile-1.11...
Error: file is encrypted or is not a database
bigfile-1.12...
Error: file is encrypted or is not a database
bigfile-1.13...
Error: file is encrypted or is not a database
bigfile-1.14...
Error: file is encrypted or is not a database
bigfile-1.15...
Error: file is encrypted or is not a database
bigfile-1.16...
Error: file is encrypted or is not a database
collate4-1.1.3...
Expected: [{} A B a b sort]
 Got: [{} A B a b nosort]
collate4-1.1.4... Ok
collate4-1.1.5... Ok
collate4-1.1.6...
Expected: [{} A a B b sort]
 Got: [{} A a B b nosort]
collate4-1.1.7... Ok
collate4-1.1.8... Ok
collate4-1.1.9... Ok
collate4-1.1.10...
Expected: [{} B a 

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 suite.  Yet that
> is what appears to have happened.

I had the same sort of thing happen. The machine just would not
compile the linux source. Luckily it had different errors each time
which is what tripped me to look for a hardware problem.

http://www.memtest86.com/

Has a nifty tester with an ISO image. You can make a bootable cd
to test your machine. It makes a great addition to your test tools
suite.




__ 
Do you Yahoo!? 
Yahoo! Mail - now with 250MB free storage. Learn more. 
http://info.mail.yahoo.com/mail_250


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 removed the offending SIMM, rebooted and all tests
> passed.

Was the magic number of cells 8? I'm wondering if you had a bad "chip"
that somehow passed QA, but wasn't in a critical section of memory to
corrupt the system.

-- 
Joel Lucsy
"The dinosaurs became extinct because they didn't have a space
program." -- Larry Niven


[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 database, make lots of changes, roll those
changes back, then verify that the database holds exactly the same
information as it did before the transaction.  In a database of
about a megabyte in size, I would sometimes see a single bit
difference after the rollback.  The bit that changed would always
be the 0x08 bit.  But the location of the change within the
database was seemingly random.

I was talking with Dan about this yesterday - he was unable to
reproduce the problem.  So I said "Maybe it's hardware?"
"Not likely", Dan replied.  And rightly so.  No programmer ever
wants to admit that a nasty problem might be lurking in their
own code.  It is always easier to blame something else - some
library you are linking against, the operating system, the
hardware you are running on.  But at the end of the day, the
problem usually does end up being in your own code and not
elsewhere.  So after you have been programming for a while
(decades in my case) you begin to be very suspicious when
people go blaming malfunctions on the parts they didn't write.

But last night, I was at wits end trying to track down the problem
in SQLite.  I figured it can't hurt to test the memory, so I
rebooted using the SuSE install disk which happens to have a
nifty memory checker built in.  About 10 minutes into the test,
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 removed the offending SIMM, rebooted and all tests
passed.

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 suite.  Yet that
is what appears to have happened.

Now it is still always the best policy to blame your own code
first.  When something isn't working right, the person sitting
behind the keyboard is the most likely cause.  Sometimes you
will run into problems with the library you are using, or with
your compiler, or your OS, but those cases are rare.  Hardware
is seldom an issue.  But as this case shows, sometime, very
rarely, it really can be the hardware's fault.

-- 
D. Richard Hipp <[EMAIL PROTECTED]>



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 set.  The problem is that if any
> of those scripts fails to execute properly, than all 25 scripts are
> rolled back.  It would be nice to get a bit better granuality, with
> partial commits or something.
> 
> Enter COMMIT.  Does it allow you to commit portions of the sql
> scripts?  I.e., could I start a BEGIN TRANSACTION;  then at the end of
> each script execute a COMMIT to successfully commit that portion, and
> then proceed to the end, and END TRANSACTION.  That way, if somewhere
> down the line, I lose the 15th file, at least the first 14 are in the
> database.
> 

COMMIT and END are the same thing.  To do what you are trying to do
above, you should COMMIT then immediately do another BEGIN.
-- 
D. Richard Hipp <[EMAIL PROTECTED]>



[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 execute properly, than all 25 scripts are
rolled back.  It would be nice to get a bit better granuality, with
partial commits or something.

Enter COMMIT.  Does it allow you to commit portions of the sql
scripts?  I.e., could I start a BEGIN TRANSACTION;  then at the end of
each script execute a COMMIT to successfully commit that portion, and
then proceed to the end, and END TRANSACTION.  That way, if somewhere
down the line, I lose the 15th file, at least the first 14 are in the
database.

Or is COMMIT a synonym for END TRANSACTION?

-- Keith
**
- Ever notice how 'big' isn't, compared to 'small'?

- I'm not a professional; I just get paid to do this.

- Rules for programming:
   1.  Get it working, right?
   2.  Get it working right.

- Things I've learned about multithreaded programming:

123...   PPArrvooottieedcc ttm  ueelvvteeirrtyyhtt
rhheiianndgge  dwi hnpi rctohhg eri aslm omscitanalgt 
 iowcbh,je engceltvo ebwrah lip,co hso srci abonlt ehb
.ee^Nr waicscee snsoetd  'aotb jtehcet -slaomcea lt'il
m^Ne from two or more threads
**


[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 compiling.
Does anyone have any ideas?  I'm using Mac OS X 10.3.8.
Brief note.
In the patch, search for F_FULLSYNC and replace it with F_FULLFSYNC.
http://www.sqlite.org/cvstrac/chngview?cn=2372


[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 using Mac OS X 10.3.8.

./libtool --mode=compile gcc -g -O2 -DOS_UNIX=1 -DHAVE_USLEEP=1 -I.
-I../sqlite-3.1.4/src -DNDEBUG
-I/System/Library/Frameworks/Tcl.framework/Versions/8.4/Headers
-DSQLITE_OMIT_CURSOR -DTHREADSAFE=0 -c ../sqlite-3.1.4/src/os_unix.c
 gcc -g -O2 -DOS_UNIX=1 -DHAVE_USLEEP=1 -I. -I../sqlite-3.1.4/src
-DNDEBUG -I/System/Library/Frameworks/Tcl.framework/Versions/8.4/Headers
-DSQLITE_OMIT_CURSOR -DTHREADSAFE=0 -c ../sqlite-3.1.4/src/os_unix.c 
-fno-common -DPIC -o .libs/os_unix.o
../sqlite-3.1.4/src/os_unix.c: In function `full_fsync':
../sqlite-3.1.4/src/os_unix.c:733: error: `F_FULLSYNC' undeclared
(first use in this function)
../sqlite-3.1.4/src/os_unix.c:733: error: (Each undeclared identifier
is reported only once
../sqlite-3.1.4/src/os_unix.c:733: error: for each function it appears in.)
make: *** [os_unix.lo] Error 1


Thanks,

Eric


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 22:56:41.189427456 +0100
@@ -451,6 +451,9 @@
 arch.html: $(TOP)/www/arch.tcl
tclsh $(TOP)/www/arch.tcl >arch.html

+arch.png:  $(TOP)/www/arch.png
+   cp $(TOP)/www/arch.png .
+
 arch2.gif: $(TOP)/www/arch2.gif
cp $(TOP)/www/arch2.gif .




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 need to do in a typical application. The advice below
is good, and I would add one thing. How long will it (the application) be
around and how hard will it be to maintain.

anyway, see http://www.mygenerationsoftware.com if you're interested.

- Mike

> 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 the "anything but Microsoft" prejudice
> that
> a lot of non-MS programmers seem to have.  So, I would say that you need
> to
> decide what it is you're actually developing and then select a tool that
> is
> going to achieve that result - here's some questions to ask yourself;
>
>  a) Am I developing a web application or just providing some dynmic
> content
>
>  b) Can I fix the deployment platform (Windows/Linux/Solaris)
>
>  c) How much time have I got to develop this
>
>  d) What level/quality of service do I need to provide
>
> There are lots of other questions but these are good ones to try and
> resolve
> straight off.
>
> Most of the applications I am involved in writing are multi-developer,
> corporate wide systems and as such, it's not practical to choose a toolset
> that isn't supported by a good vendor and a large user base.  This tends
> to
> narrow the choices down to commercial products like
> .NET/Java/Delphi/C/C++/VB - by commerical I'm talking about the
> Development
> Environments (IDE).
>
> Over the years I've come to realise that programming is much the same in
> any
> modern environment - same symantics, different syntax.  what really makes
> the difference for me is the development environment, I'm at the age where
> I
> can no longer bear the thought of using notepad/emacs/vi/vim as my
> development editor for the sake of spending a few quid on a proper tool
> for
> the job that has Intellisense, aut-formatting, syntax checking etc.
>
> With that in mind, your choice is further narrowed and my current absolute
> favourite is Java Servlets with JDBC using JetBrains IntelliJ.  Low cost,
> professional, high performance, good CV fodder, beautiful IDE.
> If your pockets are deeper and you're sticking with Windows then .NET and
> ADO is quite frankly the best possible way to go.
>
> Hey, you wanted an opinion
>
> p.s. anyone using assembler in a web environment should be kept away from
> sharp objects for their own safety!!
>
>
>
>
> -Original Message-
> From: Eli Burke [mailto:[EMAIL PROTECTED]
> Sent: 07 March 2005 21:23
> To: sqlite-users@sqlite.org
> Subject: [sqlite] thoughts on a web-based front end to sqlite3 db?
>
>
> I've been working on a project using sqlite3 since last fall. At the time,
> I knew that it would need a web-based front-end eventually. I have a very
> small bit of experience with PHP, and I assumed that PHP would support
> sqlite3 sooner or later. Well, it's later, and as far as I know, PHP
> is still using the 2.x branch.
>
> So, I was wondering if any of the more opinionated among you would care
> to suggest an interface language. It'll be on a Linux box, presumably
> running apache although I'm open to alternatives. The app itself uses
> sqlite3 for scheduling jobs and storing job data, so the web interface
> only needs to be able to insert some data and do visualization
> (pretty standard stuff I think).
>
> Ease of learning is a plus as I need to get something basic up and
> running fairly fast. I've heard good things about Python in that respect.
> Does anyone have alternative suggestions, or if you agree that Python Is
> Good, would you suggest using APSW, pysqlite, or something else?
>
> Thanks,
> Eli
>
>
>
>




[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)
   * A transaction is started using BEGIN
   * Within that transaction you run CREATE UNIQUE INDEX...
   * The create unique index fails because there were
 preexisting rows in the table that were not unique.

This is an obscure corner case, but it is probably worth
updating anyhow.

Other features added to 3.1.4 include the ability to turn
the F_FULLSYNC ioctl on and off in OS-X.  And some enhancements
where made so that 3.1.4 will always be able to read and write
database files generated by version 3.2 after it appears.

As always, please let me know if you see any problems.
 
-- 
D. Richard Hipp <[EMAIL PROTECTED]>



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 prefer replies that don't contain vulgar/obscene
content.

Thanks.

Jeff Dinsmore
MIS - Interfaces
Ridgeview Medical Center
[EMAIL PROTECTED]
952.442.2191 x6592


-Original Message-
From: Richard Heyes [mailto:[EMAIL PROTECTED]
Sent: Monday, March 07, 2005 8:37 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] thoughts on a web-based front end to sqlite3 db?


Eli Burke wrote:
> I've been working on a project using sqlite3 since last fall. At the
> time, I knew that it would need a web-based front-end eventually. I
> have a very small bit of experience with PHP, and I assumed that PHP
> would support sqlite3 sooner or later. Well, it's later, and as far as

> I know, PHP is still using the 2.x branch.
>
> So, I was wondering if any of the more opinionated among you would
> care to suggest an interface language. It'll be on a Linux box,
> presumably running apache although I'm open to alternatives. The app
> itself uses sqlite3 for scheduling jobs and storing job data, so the
> web interface only needs to be able to insert some data and do
> visualization (pretty standard stuff I think).
>
> Ease of learning is a plus as I need to get something basic up and
> running fairly fast. I've heard good things about Python in that
respect.
> Does anyone have alternative suggestions, or if you agree that Python
Is
> Good, would you suggest using APSW, pysqlite, or something else?

Since noone has mentioned it yet, I'd suggest Brainfuck
(http://www.muppetlabs.com/~breadbox/bf/). Very easy to learn (only
eight instructions) so you should have something up and running pretty
quickly. Notably, it has some of the most elegant code structure I've
ever seen.

HTH.

--

Richard Heyes


Ridgeview Medical Center Confidentiality Notice: This email message,
including any attachments, is for the sole use of the intended recipient(s)
and may contain confidential and privileged information. Any unauthorized
review, use, disclosure or distribution is prohibited. If you are not the
intended recipient, please contact the sender by reply email and destroy all
copies of the original message.





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 the "anything but Microsoft" prejudice that
a lot of non-MS programmers seem to have.  So, I would say that you need to
decide what it is you're actually developing and then select a tool that is
going to achieve that result - here's some questions to ask yourself;

 a) Am I developing a web application or just providing some dynmic content

 b) Can I fix the deployment platform (Windows/Linux/Solaris)

 c) How much time have I got to develop this

 d) What level/quality of service do I need to provide

There are lots of other questions but these are good ones to try and resolve
straight off.

Most of the applications I am involved in writing are multi-developer,
corporate wide systems and as such, it's not practical to choose a toolset
that isn't supported by a good vendor and a large user base.  This tends to
narrow the choices down to commercial products like
.NET/Java/Delphi/C/C++/VB - by commerical I'm talking about the Development
Environments (IDE).

Over the years I've come to realise that programming is much the same in any
modern environment - same symantics, different syntax.  what really makes
the difference for me is the development environment, I'm at the age where I
can no longer bear the thought of using notepad/emacs/vi/vim as my
development editor for the sake of spending a few quid on a proper tool for
the job that has Intellisense, aut-formatting, syntax checking etc.

With that in mind, your choice is further narrowed and my current absolute
favourite is Java Servlets with JDBC using JetBrains IntelliJ.  Low cost,
professional, high performance, good CV fodder, beautiful IDE.
If your pockets are deeper and you're sticking with Windows then .NET and
ADO is quite frankly the best possible way to go.

Hey, you wanted an opinion

p.s. anyone using assembler in a web environment should be kept away from
sharp objects for their own safety!!




-Original Message-
From: Eli Burke [mailto:[EMAIL PROTECTED]
Sent: 07 March 2005 21:23
To: sqlite-users@sqlite.org
Subject: [sqlite] thoughts on a web-based front end to sqlite3 db?


I've been working on a project using sqlite3 since last fall. At the time,
I knew that it would need a web-based front-end eventually. I have a very
small bit of experience with PHP, and I assumed that PHP would support
sqlite3 sooner or later. Well, it's later, and as far as I know, PHP
is still using the 2.x branch.

So, I was wondering if any of the more opinionated among you would care
to suggest an interface language. It'll be on a Linux box, presumably
running apache although I'm open to alternatives. The app itself uses
sqlite3 for scheduling jobs and storing job data, so the web interface
only needs to be able to insert some data and do visualization
(pretty standard stuff I think).

Ease of learning is a plus as I need to get something basic up and
running fairly fast. I've heard good things about Python in that respect.
Does anyone have alternative suggestions, or if you agree that Python Is
Good, would you suggest using APSW, pysqlite, or something else?

Thanks,
Eli