Re: [sqlite] Test suite fails on AIX using xlc
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?
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....
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
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?
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
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
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....
--- "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....
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....
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
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
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
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
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
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
> 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?
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
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?
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?
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