Hi Dennis, may be I understand now. I have enabled mail delivery in my sqlite users account options (which was not enabled before), now I should receive all messages so that I can reply to one of them. May be it was my problem, because I have never received any message from sqlite user mailing list. Thanks for your patience and your help, LB
[EMAIL PROTECTED] wrote: Send sqlite-users mailing list submissions to sqlite-users@sqlite.org To subscribe or unsubscribe via the World Wide Web, visit http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users or, via email, send a message with subject or body 'help' to [EMAIL PROTECTED] You can reach the person managing the list at [EMAIL PROTECTED] When replying, please edit your Subject line so it is more specific than "Re: Contents of sqlite-users digest..." Today's Topics: 1. Re: Scope of sqlite3_changes(), how to reset it? (Igor Tandetnik) 2. Re: DBD::SQLite::Amalgamation? (rahed) 3. Re: DBD::SQLite::Amalgamation? (Jim Dodgen) 4. Re: DBD::SQLite::Amalgamation? (P Kishor) 5. Re: DBD::SQLite::Amalgamation? (Jim Dodgen) 6. Re: DBD::SQLite::Amalgamation? (P Kishor) 7. Re: Indexing and Search speed ([EMAIL PROTECTED]) 8. When I try to .read I get a "can't open" message (Douglas McCarroll) 9. Re: When I try to .read I get a "can't open" message (P Kishor) 10. Re: When I try to .read I get a "can't open" message (Steven Fisher) 11. Re: When I try to .read I get a "can't open" message (Clark Christensen) ---------------------------------------------------------------------- Message: 1 Date: Mon, 31 Mar 2008 12:03:32 -0400 From: "Igor Tandetnik" Subject: Re: [sqlite] Scope of sqlite3_changes(), how to reset it? To: sqlite-users@sqlite.org Message-ID: Michael Schlenker wrote: > 1. Is sqlite3_changes() reset to 0 when a new sqlite3_exec() is > started? May or may not. E.g. if you execute a SELECT statement it doesn't affect change count. > 2. Does a PRAGMA index_list() manipulate sqlite3_changes() in any way? I haven't tried it, but I don't see why it should. > 3. How can i reset sqlite3_changes() manually if its not done on > sqlite3_exec()? "Reset" as in set to zero? Run a statement that is guaranteed not to touch any rows, e.g. delete from sometable where 0; Igor Tandetnik ------------------------------ Message: 2 Date: Mon, 31 Mar 2008 19:31:20 +0000 From: rahed Subject: Re: [sqlite] DBD::SQLite::Amalgamation? To: "General Discussion of SQLite Database" Message-ID: Content-Type: text/plain; charset=UTF-8 On 3/31/08, Jim Dodgen wrote: > Any Perl people out there using this yet (version 3.5.7)? > > I'm continually having problems when doing "make test" Today I tried and installed on Solaris successfully. Both the module 1.14 and sqlite3 amalgamation. -- Radek ------------------------------ Message: 3 Date: Mon, 31 Mar 2008 12:59:58 -0700 From: "Jim Dodgen" Subject: Re: [sqlite] DBD::SQLite::Amalgamation? To: sqlite-users@sqlite.org Message-ID: <[EMAIL PROTECTED]> Content-Type: text/plain; charset=ISO-8859-1 Humm... I'll keep looking. thanks On 3/30/08, Jim Dodgen wrote: > Any Perl people out there using this yet (version 3.5.7)? > > I'm continually having problems when doing "make test" > > It hangs forever and never completes > > I have tried this on multiple boxes running both Fedora and Redhat ES, > all 64 bit. > -- Jim Dodgen [EMAIL PROTECTED] ------------------------------ Message: 4 Date: Mon, 31 Mar 2008 15:14:07 -0500 From: "P Kishor" Subject: Re: [sqlite] DBD::SQLite::Amalgamation? To: "General Discussion of SQLite Database" Message-ID: Content-Type: text/plain; charset=ISO-8859-1 On 3/30/08, Jim Dodgen wrote: > Any Perl people out there using this yet (version 3.5.7)? > > I'm continually having problems when doing "make test" > > It hangs forever and never completes > > I have tried this on multiple boxes running both Fedora and Redhat ES, > all 64 bit. Jim, I am using 3.5.6 (using the amalgamation... see the instructions I put on the SQLite wiki) and that worked well for me on both a Mac Leopard and a RHEL ES3 box. I see no reason to upgrade to 3.5.7 yet. That said, I also not working with 64 bit system. You might get better luck in getting an answer if you post at least the tail portion of the make output, otherwise no one has any idea where your process hangs. -- Puneet Kishor http://punkish.eidesis.org/ Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/ Open Source Geospatial Foundation (OSGeo) http://www.osgeo.org/ ------------------------------ Message: 5 Date: Mon, 31 Mar 2008 13:34:42 -0700 From: "Jim Dodgen" Subject: Re: [sqlite] DBD::SQLite::Amalgamation? To: [EMAIL PROTECTED], "General Discussion of SQLite Database" Message-ID: <[EMAIL PROTECTED]> Content-Type: text/plain; charset=ISO-8859-1 On 3/31/08, P Kishor wrote: > On 3/30/08, Jim Dodgen wrote: > > Any Perl people out there using this yet (version 3.5.7)? > > > > I'm continually having problems when doing "make test" > > > > It hangs forever and never completes > > > > I have tried this on multiple boxes running both Fedora and Redhat ES, > > all 64 bit. > > > Jim, > > I am using 3.5.6 (using the amalgamation... see the instructions I put > on the SQLite wiki) and that worked well for me on both a Mac Leopard > and a RHEL ES3 box. I see no reason to upgrade to 3.5.7 yet. That > said, I also not working with 64 bit system. > > You might get better luck in getting an answer if you post at least > the tail portion of the make output, otherwise no one has any idea > where your process hangs. > It makes ok, here is the output from "make test". the hang is after "t/06error" it never finishes DBD-SQLite-Amalgamation-3.5.7 # make test PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t t/00basic...............ok t/01logon...............ok t/02cr_table............ok t/03insert..............ok t/04select..............ok t/05tran................ok t/06error...............ok 1/2 (this never finishes) # uname -a Linux timmy 2.6.11-1.1369_FC4smp #1 SMP Thu Jun 2 23:16:33 EDT 2005 x86_64 x86_64 x86_64 GNU/Linuxperl # perl -v This is perl, v5.8.6 built for x86_64-linux-thread-multi > > > -- > Puneet Kishor http://punkish.eidesis.org/ > Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/ > Open Source Geospatial Foundation (OSGeo) http://www.osgeo.org/ > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Jim Dodgen [EMAIL PROTECTED] ------------------------------ Message: 6 Date: Mon, 31 Mar 2008 15:44:07 -0500 From: "P Kishor" Subject: Re: [sqlite] DBD::SQLite::Amalgamation? To: "Jim Dodgen" Cc: General Discussion of SQLite Database Message-ID: Content-Type: text/plain; charset=ISO-8859-1 On 3/31/08, Jim Dodgen wrote: > On 3/31/08, P Kishor wrote: > > On 3/30/08, Jim Dodgen wrote: > > > Any Perl people out there using this yet (version 3.5.7)? > > > > > > I'm continually having problems when doing "make test" > > > > > > It hangs forever and never completes > > > > > > I have tried this on multiple boxes running both Fedora and Redhat ES, > > > all 64 bit. > > > > > > Jim, > > > > I am using 3.5.6 (using the amalgamation... see the instructions I put > > on the SQLite wiki) and that worked well for me on both a Mac Leopard > > and a RHEL ES3 box. I see no reason to upgrade to 3.5.7 yet. That > > said, I also not working with 64 bit system. > > > > You might get better luck in getting an answer if you post at least > > the tail portion of the make output, otherwise no one has any idea > > where your process hangs. > > > > > > It makes ok, here is the output from "make test". the hang is after > "t/06error" it never finishes > > DBD-SQLite-Amalgamation-3.5.7 > > # make test > PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" > "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t > t/00basic...............ok > t/01logon...............ok > t/02cr_table............ok > t/03insert..............ok > t/04select..............ok > t/05tran................ok > t/06error...............ok 1/2 > > (this never finishes) well, look in the t directory for the specific test. In my case, I see the following -- use Test; BEGIN { plan tests => 2 } use DBI; unlink('foo'); my $db = DBI->connect('dbi:SQLite:foo', '', '', { RaiseError => 1, PrintError => 0 }); eval { $db->do('ssdfsdf sdf sd sdfsdfdsf sdfsdf'); }; ok($@); $db->do('create table testerror (a, b)'); $db->do('insert into testerror values (1, 2)'); $db->do('insert into testerror values (3, 4)'); $db->do('create unique index testerror_idx on testerror (a)'); eval { $db->do('insert into testerror values (1, 5)'); }; ok($@); You could follow from there and see what is actually failing, or where it is getting stuck. Seems like a pretty simple test to me, so I can't fathom where things are hanging. If you want to live dangerously, you could also just force a make anyway in spite of the hanging test and see if the installation works for you. Then you could work back and try and figure out what is going wrong. > > # uname -a > Linux timmy 2.6.11-1.1369_FC4smp #1 SMP Thu Jun 2 23:16:33 EDT 2005 > x86_64 x86_64 x86_64 GNU/Linuxperl > > # perl -v > > This is perl, v5.8.6 built for x86_64-linux-thread-multi > > > > > -- Puneet Kishor http://punkish.eidesis.org/ Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/ Open Source Geospatial Foundation (OSGeo) http://www.osgeo.org/ ------------------------------ Message: 7 Date: Mon, 31 Mar 2008 21:08:07 +0000 From: [EMAIL PROTECTED] Subject: Re: [sqlite] Indexing and Search speed To: General Discussion of SQLite Database Message-ID: <[EMAIL PROTECTED]> From: Dennis Cote > No, that's not true. A sub-query is like any other query. I have > rearranged the query to make it more readable. > > select types.Track,types.URL > from ALBUM > inner join (select * from MUSIC where Artist_Id =?) as types > on ALBUM.AlbumId=types.Album_Id > order by ALBUM.YomiAlbumName; > > In this case the sub-query is returning the subset of the Music table by > the specified artist. This result table is given the name "types", and > it is joined to the album table. I didn't know this was possible -- my trusty "learn SQL in 10 minutes" has failed me. But it makes sense from your explanation. Thanks. In most cases like this, I've 'hidden' the join inside a view so the syntax is clean. But, I expect moving the filtering before the join is much more efficient, no? ------------------------------ Message: 8 Date: Mon, 31 Mar 2008 17:11:35 -0400 From: "Douglas McCarroll" Subject: [sqlite] When I try to .read I get a "can't open" message To: "sqlite-users@sqlite.org" Message-ID: Content-Type: text/plain; charset=ISO-8859-1 I'm sure I'm doing something simple and obvious wrong here. I'm a complete sqlite n00b. Help? C:\_source>sqlite3 test SQLite version 3.5.7 Enter ".help" for instructions sqlite> .read test.sql; can't open "test.sql;" sqlite> .read C:/_source/test.sql; can't open "C:/_source/test.sql;" ------------------------------ Message: 9 Date: Mon, 31 Mar 2008 16:16:24 -0500 From: "P Kishor" Subject: Re: [sqlite] When I try to .read I get a "can't open" message To: "General Discussion of SQLite Database" Message-ID: Content-Type: text/plain; charset=ISO-8859-1 On 3/31/08, Douglas McCarroll wrote: > I'm sure I'm doing something simple and obvious wrong here. I'm a complete > sqlite n00b. > > Help? > > C:\_source>sqlite3 test > SQLite version 3.5.7 > Enter ".help" for instructions > sqlite> .read test.sql; > can't open "test.sql;" > sqlite> .read C:/_source/test.sql; > can't open "C:/_source/test.sql;" > _______________________________________________ take out the ; at the end of the statement. .read is a sqlite3 shell command, not a SQL statement. Also, try putting your path in single quotes (or is double quotes... try both). sqlite> .read 'test.sql' ------------------------------ Message: 10 Date: Mon, 31 Mar 2008 14:18:00 -0700 From: Steven Fisher Subject: Re: [sqlite] When I try to .read I get a "can't open" message To: General Discussion of SQLite Database Message-ID: <[EMAIL PROTECTED]> Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes On 31-Mar-2008, at 2:11 PM, Douglas McCarroll wrote: > I'm sure I'm doing something simple and obvious wrong here. I'm a > complete > sqlite n00b. > > Help? > > C:\_source>sqlite3 test > SQLite version 3.5.7 > Enter ".help" for instructions > sqlite> .read test.sql; > can't open "test.sql;" You shouldn't be including the semicolon. It's that way for most dot commands. (Wish it was ignored if present; I make this mistake a lot myself.) ------------------------------ Message: 11 Date: Mon, 31 Mar 2008 14:25:52 -0700 (PDT) From: Clark Christensen Subject: Re: [sqlite] When I try to .read I get a "can't open" message To: General Discussion of SQLite Database Message-ID: <[EMAIL PROTECTED]> Content-Type: text/plain; charset=us-ascii It's the trailing semicolon. The dot commands don't require them, while SQL statements do. ----- Original Message ---- From: Douglas McCarroll To: "sqlite-users@sqlite.org" Sent: Monday, March 31, 2008 2:11:35 PM Subject: [sqlite] When I try to .read I get a "can't open" message I'm sure I'm doing something simple and obvious wrong here. I'm a complete sqlite n00b. Help? C:\_source>sqlite3 test SQLite version 3.5.7 Enter ".help" for instructions sqlite> .read test.sql; can't open "test.sql;" sqlite> .read C:/_source/test.sql; can't open "C:/_source/test.sql;" _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ------------------------------ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users End of sqlite-users Digest, Vol 3, Issue 99 ******************************************* --------------------------------- You rock. That's why Blockbuster's offering you one month of Blockbuster Total Access, No Cost. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users