Re: [sqlite] Seems like a bug in the parser

2006-08-23 Thread Joe Wilson
--- Kurt Welgehausen <[EMAIL PROTECTED]> wrote: > > select a from qqq group by b; > > This question was discussed on the list a year or 2 ago. > > The column a in the simple query above is meaningless; it's > an arbitrary value from each group. There are queries, > however, where a non-grouped

Re: [sqlite] concurrency version 2.8.17

2006-08-23 Thread Mark Richards
That's the ticket.. and it looks like sqlite_busy_timeout() may be my answer. Many thanks! /m [EMAIL PROTECTED] wrote: Look in the www directory. There are TCL script which output HTML that goes (or went) onto the website. -- D. Richard Hipp <[EMAIL PROTECTED]>

Re: [sqlite] concurrency version 2.8.17

2006-08-23 Thread drh
Mark Richards <[EMAIL PROTECTED]> wrote: > The source has a docs directory which contains an html file describing > lemon. > > Otherwise there are no docs I can find in the source tree (other than > the source!). > Look in the www directory. There are TCL script which output HTML that goes

Re: [sqlite] Seems like a bug in the parser

2006-08-23 Thread Jonathan Ellis
On 8/23/06, Andrew McCollum <[EMAIL PROTECTED]> wrote: I find this feature useful, especially in queries which use aggregate functions, such as the following: SELECT sum(a) FROM tbl GROUP BY b The question should be what the compelling reason is to remove a useful feature. ... And *that* is

Re: [sqlite] SQLite with Index

2006-08-23 Thread John Stanton
Sqlite creates B-Tree indices. It is a form of self balancing tree index. Manzoor Ilahi Tamimy wrote: Dear All, I have question about Index. When we create an index on a table then how SQLite manage it. Whether SQLite uses Hashing or some other technique to handle index. Can some one

Re: [sqlite] implementing busy_handler callback

2006-08-23 Thread John Stanton
I would endorse that. It makes the logic simpler and execution more efficient compared with the various polling strategies used to look at file locks. It is particularly the case if you multi-use is due to threading in a single process. Ritesh Kapoor wrote: I think a good way of using

Re: [sqlite] running a script?

2006-08-23 Thread Clark Christensen
It should work fine with filenames with semicolons. My problem is when I include the trailing semicolon, and it isn't really part of the filename or table name. You _might_ need to use forward slashes instead of backslashes as the path separator inside the SQLite shell on Windows. Or you

Re: [sqlite] running a script?

2006-08-23 Thread Clay Dowling
John Salerno said: > I'm asking about an actual file, though, not just a single query. I've > tried something like what you suggest with the file path, but it > doesn't work. > sqlite database.db < script.sql > > > On 8/23/06, Scott Baker <[EMAIL PROTECTED]> wrote: >> echo "SELECT * FROM

Re: [sqlite] running a script?

2006-08-23 Thread John Salerno
Thanks guys. Does any of this change for Windows though? I don't believe I can use cat or | in the command prompt. I've also tried some of those structures already and there seems to be a problem with my file paths: C:\name\name\file.ext I don't know if it's the colon or the slashes, but it

Re: [sqlite] running a script?

2006-08-23 Thread Clark Christensen
>From the SQLite shell .read myfile Or, from the OS command shell sqlite3 foo.db ".read myfile" .help in the SQLite shell will give you the available commands Note. For me, it's a habit to end lines in the SQLite shell with a semicolon. That breaks the .read and .import commands because

Re: [sqlite] running a script?

2006-08-23 Thread Ulrich Schöbel
On Wednesday 23 August 2006 21:45, John Salerno wrote: > Hi everyone. Can someone tell me the proper syntax for running a sql > script when starting up sqlite from the command line interface? > > Thanks, > John > > --- >-- To

Re: [sqlite] running a script?

2006-08-23 Thread John Salerno
I'm asking about an actual file, though, not just a single query. I've tried something like what you suggest with the file path, but it doesn't work. On 8/23/06, Scott Baker <[EMAIL PROTECTED]> wrote: echo "SELECT * FROM Table" | sqlite database.bin John Salerno wrote: > Hi everyone. Can

Re: [sqlite] running a script?

2006-08-23 Thread Scott Baker
echo "SELECT * FROM Table" | sqlite database.bin John Salerno wrote: > Hi everyone. Can someone tell me the proper syntax for running a sql > script when starting up sqlite from the command line interface? > > Thanks, > John > >

[sqlite] running a script?

2006-08-23 Thread John Salerno
Hi everyone. Can someone tell me the proper syntax for running a sql script when starting up sqlite from the command line interface? Thanks, John - To unsubscribe, send email to [EMAIL PROTECTED]

RE: [sqlite] Seems like a bug in the parser

2006-08-23 Thread Andrew McCollum
I find this feature useful, especially in queries which use aggregate functions, such as the following: SELECT sum(a) FROM tbl GROUP BY b The question should be what the compelling reason is to remove a useful feature. -Andrew McCollum -Original Message- From: Kurt Welgehausen

Re: [sqlite] sqlite book

2006-08-23 Thread Bud Beacham
I have purchased two books on SQLite. "The Definitive Guide to SQLite" by Micheal Owens covers version 3. "SQLite" by Chris Newman covers version 2, but most is applicable to version 3. I have found both to be helpful, and would recommend buying either, or both. However, IMO

Re: [sqlite] spanish chars

2006-08-23 Thread Will Leshner
On 8/23/06, Preston Z <[EMAIL PROTECTED]> wrote: the problem is when i get the data through the C api with a call to sqlite3_get_table, the chars are missing/distorted. Are they missing/distorted, or, is the method you are using to inspect them not understanding the encoding they are in. You

[sqlite] Subquery occassionally returns null

2006-08-23 Thread Nathan Biggs
I am occasionally getting a strange behavior on one of my queries where the sub-query is returning NULL even though the record exists. Here is the query: Insert into table2 values (2, (select id from table1 where x = '12345' and y = '4567'), 0); The record for table1 where x = '12345' and y

[sqlite] sqlite book

2006-08-23 Thread Cesar David Rodas Maldonado
Hello.. Please I need to know if is there a Good book about SQLite i want to learn it, i want to know how to optimize and how it works Thanks to all

[sqlite] spanish chars

2006-08-23 Thread Preston Z
I haven't worked with internationalization much before so please forgive me if this is a stupid question or not related to sqlite. I have an charset problem using sqlite 3.2.2, I run into the following issue: we have started adding spanish transaltions to our database. The app that loads the

Re: [sqlite] Seems like a bug in the parser

2006-08-23 Thread Kurt Welgehausen
> select a from qqq group by b; This question was discussed on the list a year or 2 ago. The column a in the simple query above is meaningless; it's an arbitrary value from each group. There are queries, however, where a non-grouped column is meaningful, such as a join where the grouping column

[sqlite] New DBManager Professional 3.3.3 (Enterprise Edition)

2006-08-23 Thread COS
DBTools Software is pleased to announce the new DBManager Professional 3.3.3 Enterprise Edition. This version is a major bug fix with a few extra funcionality added to the application. For a complete lists of changes check http://www.dbtools.com.br/EN/article.php?id=00071. You can download the

Re: [sqlite] Stop multiple simultaneous users

2006-08-23 Thread Jay Sprenkle
On 8/22/06, Dr Gerard Hammond <[EMAIL PROTECTED]> wrote: Hi, How can I stop multiple simultaneous users accessing a SQLite database? use locking to obtain an exclusive lock Is there a SQLite function that tells me how many people/applications have the database open? No, you want to ask the

[sqlite] SQLite with Index

2006-08-23 Thread Manzoor Ilahi Tamimy
Dear All, I have question about Index. When we create an index on a table then how SQLite manage it. Whether SQLite uses Hashing or some other technique to handle index. Can some one guide me where can I find the details working process of SQLIte when we create Index. Best regards,

[sqlite] Re: Seems like a bug in the parser

2006-08-23 Thread A. Pagaltzis
* Alexei Alexandrov <[EMAIL PROTECTED]> [2006-08-23 09:20]: > All other databases I know will complain if you give them this query. Except MySQL, glory that it is. Regards, -- Aristotle Pagaltzis //

[sqlite] Partial indexes

2006-08-23 Thread Mikey C
Any plans to support partial indexes in SQLite? http://en.wikipedia.org/wiki/Partial_index http://db.cs.berkeley.edu/papers/ERL-M89-17.pdf PostgreSQL supports them and they seem very useful. -- View this message in context: http://www.nabble.com/Partial-indexes-tf2151623.html#a5941879 Sent

[sqlite] Re : [sqlite] how can i optimize this query

2006-08-23 Thread Pierre Aubert
Hello Cesar, may be you can have a look at ft3 (ft3.sourceforge.net) which does the same thing. Some advices: * partition your table ft_index on wordid I use 1024 tables and use them like that: ft_index[ wordid % 1024 ] to access them. This reduce the size of the table and thus the

Re: [sqlite] Seems like a bug in the parser

2006-08-23 Thread Mario Frasca
Joe Wilson wrote: --- [EMAIL PROTECTED] wrote: SQLite accepts the above and does the right thing with it. It is the equivalent of saying: SELECT a FROM (SELECT a,b FROM qqq GROUP BY b); Not sure what you mean by the "right thing". It's not obvious why the rows returned by this GROUP BY

Re: [sqlite] Seems like a bug in the parser

2006-08-23 Thread Alexei Alexandrov
On 8/22/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: SQLite accepts the above and does the right thing with it. It is the equivalent of saying: SELECT a FROM (SELECT a,b FROM qqq GROUP BY b); The subquery here doesn't make any sense to me. How a single 'a' is chosen for the grouped