Re: [sqlite] SQlite 2.8.16 -> SQLite 3

2007-03-12 Thread Martin Jenkins
Mitchell Vincent wrote: So is a 60%ish reduction in DB size from 2.8.16 to 3.3.13 normal? Don't know about "normal" but ISTR version 3 did bring some fairly major improvements in file size. Given that you have your data in both SQLite formats would it not be fairly easy to dump both

Re: [sqlite] SQlite 2.8.16 -> SQLite 3

2007-03-12 Thread Mitchell Vincent
On 3/12/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > So is a 60%ish reduction in DB size from 2.8.16 to 3.3.13 normal? > 3.3.13 typically generates database files that are 30-40% smaller than 2.8.16. 60% seems excessive, but is not outside the range of possibility. What kind of data

Re: [sqlite] SQlite 2.8.16 -> SQLite 3

2007-03-12 Thread drh
"Mitchell Vincent" <[EMAIL PROTECTED]> wrote: > I'm converting a bunch of databases from SQLite 2.8.16 to SQLite > 3.3.13 and am seeing something pretty amazing space saving. So good > that it might be too good to be true! > > For example, a 17 meg database is cut d

Re: [sqlite] SQlite 2.8.16 -> SQLite 3

2007-03-12 Thread P Kishor
On 3/12/07, Mitchell Vincent <[EMAIL PROTECTED]> wrote: I'm converting a bunch of databases from SQLite 2.8.16 to SQLite 3.3.13 and am seeing something pretty amazing space saving. So good that it might be too good to be true! For example, a 17 meg database is cut down to 7 megs.

[sqlite] SQlite 2.8.16 -> SQLite 3

2007-03-12 Thread Mitchell Vincent
I'm converting a bunch of databases from SQLite 2.8.16 to SQLite 3.3.13 and am seeing something pretty amazing space saving. So good that it might be too good to be true! For example, a 17 meg database is cut down to 7 megs. That's fantastic if it's just that SQlite is *that* much better

Re: [sqlite] Command line interface SQLITE 2.8.16

2005-09-14 Thread Nemanja Corlija
On 9/14/05, Sijm, Norbert <[EMAIL PROTECTED]> wrote: > > > > Hi, I'm trying to execute a command in a DOS batchfile , but I get a syntax > error. Is this supported in 2.8.16 ? > ( sqlite mydbase.db select * from table1; ) Try enclosing your SQL statements in double quotes, like this: sqlite

[sqlite] Command line interface SQLITE 2.8.16

2005-09-14 Thread Sijm, Norbert
Hi, I'm trying to execute a command in a DOS batchfile , but I get a syntax error. Is this supported in 2.8.16 ? ( sqlite mydbase.db select * from table1; ) PS. When doing firm sqlite mydbase select ... it works ) Regards Norbert

Re: [sqlite] 2.8.16

2005-09-08 Thread Ted Unangst
Mark Drago wrote: I don't seem to have the 'md5sum' program installed on the mac that I have here, but getting the md5sum on linux returns the following. So, if you have some means of getting the md5sum of the file, make sure it matches this: 9c79b461ff30240a6f9d70dd67f8faea sqlite-2.8.16

Re: [sqlite] 2.8.16

2005-09-08 Thread Puneet Kishor
On Sep 8, 2005, at 1:24 PM, Mark Drago wrote: Richard, You can use 'curl' to download the file instead of wget. So, run the following command instead: curl -o sqlite-2.8.16.tar.gz http://www.sqlite.org/sqlite-2.8.16.tar.gz wget is not available by default on Panther. On the other hand

Re: [sqlite] 2.8.16

2005-09-08 Thread Richard Nagle
Nope, done that, still the same errors. Have another person, whom is trying to figure this out as well, in fact, he thinks, something in my shell is mess up.. > Wow, your results are completely different. When the shell trys to read the here-document, it gets the garbage. So the bug is in

Re: [sqlite] 2.8.16

2005-09-08 Thread Mark Drago
Richard, You can use 'curl' to download the file instead of wget. So, run the following command instead: curl -o sqlite-2.8.16.tar.gz http://www.sqlite.org/sqlite-2.8.16.tar.gz I don't seem to have the 'md5sum' program installed on the mac that I have here, but getting the md5sum on linux

Re: [sqlite] 2.8.16

2005-09-08 Thread Richard Nagle
h the command line: >-- >wget http://www.sqlite.org/sqlite-2.8.16.tar.gz >gunzip sqlite-2.8.16.tar.gz >tar -xvf sqlite-2.8.16.tar >cd sqlite-2.8.16 >su >-- > >now what happens when you configure/install from here?

Re: [sqlite] 2.8.16

2005-09-08 Thread Jens Miltner
: -- wget http://www.sqlite.org/sqlite-2.8.16.tar.gz gunzip sqlite-2.8.16.tar.gz tar -xvf sqlite-2.8.16.tar cd sqlite-2.8.16 su -- now what happens when you configure/install from here? On 9/8/05, Richard Nagle <[EMAIL PROTECTED]>

Re: [sqlite] 2.8.16

2005-09-08 Thread Cam Crews
-2.8.16.tar.gz gunzip sqlite-2.8.16.tar.gz tar -xvf sqlite-2.8.16.tar cd sqlite-2.8.16 su -- now what happens when you configure/install from here? On 9/8/05, Richard Nagle <[EMAIL PROTECTED]> wrote: > > On September 08 2005, Cam Crews <[EMAIL PR

Re: [sqlite] 2.8.16

2005-09-08 Thread Richard Nagle
On September 08 2005, Cam Crews <[EMAIL PROTECTED]> wrote: >> So, its something with the C compiler... Well, you can test your compiler pretty easily.. Are you able to compile anything else? At minimum, try compiling hello world first: create a file test.c : ---

Re: [sqlite] 2.8.16

2005-09-08 Thread Cam Crews
> So, its something with the C compiler... Well, you can test your compiler pretty easily.. Are you able to compile anything else? At minimum, try compiling hello world first: create a file test.c : --- #include int main( ) { printf("oh my, 1 step closer to

[sqlite] 2.8.16

2005-09-08 Thread Richard Nagle
Downloaded this, version, and got the same kind of output. V҆—jx?Âê#MÉfl#?sjKöyæ9>[EMAIL PROTECTED]…ºhUˆZ£/SŸ?÷é©='¿l?/ëÿ:˜ìRb}öVÙ¥"(Å[¿<.Q`ƒhYF¢+›¨÷ùáü!"ÀLOÎ í k?ïë¢xeÃb?e·Œfi,Œ[\¡"N¨>= Ã?Ê3}ì?âò<=În'T£?å. Â1 ÜÙ ˜ÅÕô/+yÑ]Ò{Ÿ¨câ´qîÔhÏ!=Na"Z