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

--- 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

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

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

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

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

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?

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?

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?

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?

>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?

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?

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?

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?

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

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

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

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

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] spanish chars

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

> 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)

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

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

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

* 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

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

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

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

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