[sqlite] (Virtual Tables) xFilter - called only once per xOpen ?

Hi again, still working on my Virtual Table implementation/object model here, and I have a question about the relationship between xOpen and xFilter. By perusing the code and playing around with some sample statements, it looks to me like there will only be one call to xFilter for any given cursor

Re: [sqlite] results of SELECT contains carriage returns

Following up my earlier post: I have a database where some values contain carriage returns. I am using the command line to execute sqlite commands, eg: sqlite3 Disney.db "SELECT * FROM Characters" When I get the result of a SELECT statement, the output has columns separated by pipe charact

Re: [sqlite] Question - Multiple Users, Multiple files

Thanks guys for all the replies I appreciate it. I'm leaning more and more towards using sqlite after your comments for these reasons. 1. Each user will have his/her own database and so will likely only be accessed at any one time by one user. To reduce concurrency issues as well as for better

[sqlite] documentation on the webserver

Good Evening Dr. Hipp, I'd like to request a small change to the web server for sqlite.org. I was trying to get a project working today and stumbled a bit. I think a change to the procedures would have helped me, and will help others. I was using 3.14 and found out about the "goofy interface" p

[sqlite] feature enhancement: extending rowid

Can I suggest a feature enhancement? Having a builtin function that returns the row number of the row in the result set would be useful for some of the things I'm doing. Rowid is close, but not won't work in my application. -- SqliteImporter and SqliteReplicator: Command line utilities for Sqli

Re: [sqlite] Escaping wildcards when using LIKE & UTF-16

Yeah, I know I can do that, and that's my backup option. I just wasn't sure how much performance suffers in this situation because this has to keep re-compiling the SQL statements (whereas right now, all my SQL statements are only prepared once at runtime and then the appropriate values are si

Re: [sqlite] Question - Multiple Users, Multiple files

Jason Abayomi wrote: Sorry about the previous mail, I hit tab in a gmail and it automatically sent it. Anyway, back to my question I'm planning out a program right now - web based - that would require each user of the application to be able to create their own independent data store with its own

Re: [sqlite] Question - Multiple Users, Multiple files

Sorry about the previous mail, I hit tab in a gmail and it automatically sent it. Anyway, back to my question I'm planning out a program right now - web based - that would require each user of the application to be able to create their own independent data store with its own schema and modificati

Re: [sqlite] Escaping wildcards when using LIKE & UTF-16

Vitali Lovich wrote: Maybe there's something else I can do to get around it for my purposes. What I have for instance is a table representing ID3 tags. What I want to do is select from the table any existing tags that match a variable number of fields - for instance, I can say I want to matc

[sqlite] fts1, rowid, and insert ... select ... bug?

Aloha, While testing the new full text search feature, I noticed the following: SQLite version 3.3.8 Enter ".help" for instructions sqlite> CREATE TABLE a (data TEXT); sqlite> INSERT INTO a VALUES ('some data'); sqlite> CREATE VIRTUAL TABLE b USING fts1 (data TEXT); sqlite> INSERT INTO b (ROWID,

Re: [sqlite] fts2 (full-text search v2) checked into CVS.

Cesar David Rodas Maldonado wrote: Ok. I have another question. I compile SQLite (the last version 3.3.8) with this fts2 extension. So how can i index something (i mean with the SQL). A good reference for using fts1 or fts2 is available at URL: http://www.sqlite.org/cvstrac/wiki?p=FtsOne

Re: [sqlite] Question - Multiple Users, Multiple files

Hi Jason, My concern is scalability and the performance hit of having let's say 5000 users potentially, accessing 5000 databases at the same time on the server. Based on my readings around the web there are ways to optimize sql queries (transactions, in memory dbs and all that) but even with tha

Re: [sqlite] Escaping wildcards when using LIKE & UTF-16

Maybe there's something else I can do to get around it for my purposes. What I have for instance is a table representing ID3 tags. What I want to do is select from the table any existing tags that match a variable number of fields - for instance, I can say I want to match using title & artist

[sqlite] Question - Multiple Users, Multiple files

Sorry about the previous mail, I hit tab in a gmail and it automatically sent it. Anyway, back to my question I'm planning out a program right now - web based - that would require each user of the application to be able to create their own independent data store with its own schema and modificati

[sqlite] Newbie Question - Multiple Users, Multiple files

Hi Guys,

Re: [sqlite] fts2 (full-text search v2) checked into CVS.

Ok. I have another question. I compile SQLite (the last version 3.3.8) with this fts2 extension. So how can i index something (i mean with the SQL). Thanks. And I think this ext is very useful On 10/13/06, Scott Hess <[EMAIL PROTECTED]> wrote: You'll want (from the bottom of http://www.sqli

Re: [sqlite] [sqlite]: How does a transaction work

On 13 Oct 2006 13:01:28 -, you wrote: >Hi, >I wanted to know how does a transaction work.. > >In the following example shown below, where is the transaction updated. Is it >in the memory or some temp file or is it directly written to the database >file. Please give more internal details

Re: [sqlite] fts2 (full-text search v2) checked into CVS.

You'll want (from the bottom of http://www.sqlite.org/download.html): cvs -d :pserver:[EMAIL PROTECTED]:/sqlite login cvs -d :pserver:[EMAIL PROTECTED]:/sqlite checkout sqlite or perhaps cvs -d :pserver:[EMAIL PROTECTED]:/sqlite login cvs -d :pserver:[EMAIL PROTECTED]:/sqlite checkout s

Re: [sqlite] I think lemon bug

Oh, my source is not latest one. Thanks, problem is solved. On 10/13/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: [EMAIL PROTECTED] wrote: > > Your work-around is to say %%d instead of %d. Or (better) get the latest version of lemon where this bug is fixed. -- D. Richard Hipp <[EMAIL PRO

Re: [sqlite] new sqlite-based webserver

Well I've never created one before but I think it should be a straight forward setup. Best regards, __ Raymond Irving --- Günter Greschenz <[EMAIL PROTECTED]> wrote: > thanks ! > > "some kind" of SourceFourge is already available: > you can download the > source :-) > do you know how to crea

Re: [sqlite] Escaping wildcards when using LIKE & UTF-16

Vitali Lovich wrote: I have a statement along the lines of: "SELECT * FROM table WHERE value LIKE :abc" I want to bind a UTF-16 string to abc - however, it can potentially contain % or _ - does sqlite provide any functionality for escaping these characters (I know I have to use the escape clau

Re: [sqlite] new sqlite-based webserver

thanks ! "some kind" of SourceFourge is already available: you can download the source :-) do you know how to create a project on sourcefourge ? until now i've downloaded only ... but i think it will take 1 or 2 weeks (i've not much time now...) cu, gg Raymond Irving schrieb: Very nice i

Re: [sqlite] Some Queries.

"Kalyani Tummala" <[EMAIL PROTECTED]> wrote: > Hello, > > I am a new user of this group (just joined). First of all I appreciate > you for creating and maintaining such a small and robust database. I > have a few simple queries on sqlite regarding footpring. I hope the > owner has the answers. >

Re: [sqlite] database corrouption during power failure

"jayanth KP" <[EMAIL PROTECTED]> wrote: > Hi Richard, > > We are ALREADY using sqlite 2.8.13. Your original post said you were using 2.8.3. Must have been a typo. > > OBSERVATIONS: > - > > 1) If i call sync() system call after database update, the database is not > getting corrup

Re: Re: [sqlite] database corrouption during power failure

Hi Richard, We are ALREADY using sqlite 2.8.13. OBSERVATIONS: - 1) If i call sync() system call after database update, the database is not getting corrupted. 2) In one scenario of corruption sqlite_open() returned an error message "file is encrypted or is not a database". 3) In a

[sqlite] [sqlite]: How does a transaction work

Hi, I wanted to know how does a transaction work.. In the following example shown below, where is the transaction updated. Is it in the memory or some temp file or is it directly written to the database file. Please give more internal details on this. sqlite_exec_printf(pDBHandle,"begin tra

Re: [sqlite] database corrouption during power failure

"jayanth KP" <[EMAIL PROTECTED]> wrote: > Hi, > >Please can anybody respond to this question. I am able to hits is issue > pretty often now... In my previous response, reproduced below, I showed you the cause of the problem and how to fix it. What further response do you want? > > > > > >

Re: [sqlite] I think lemon bug

"Jong-young Park" <[EMAIL PROTECTED]> wrote: > Hi all. > > I want to use "Lemon" parser generator for my own project because of > multi-threading. > But I find the strange bug. > > I made sample calculator program for testing. > See the part of grammar file : > > expr(X) ::= expr(A) PLUS NUM(B)

Re: Re: [sqlite] database corrouption during power failure

Hi, Please can anybody respond to this question. I am able to hits is issue pretty often now... Regards, Jayanth On Fri, 06 Oct 2006 [EMAIL PROTECTED] wrote : >"jayanth KP" <[EMAIL PROTECTED]> wrote: > > Hi, > >I have a question regarding power failure handling in sqlite 2.8.3. > >

Re: [sqlite] I think lemon bug

[EMAIL PROTECTED] wrote: > > Your work-around is to say %%d instead of %d. Or (better) get the latest version of lemon where this bug is fixed. -- D. Richard Hipp <[EMAIL PROTECTED]> - To unsubscribe, send email to [E

Re: [sqlite] DELETE TRIGGER does not work as expected

Inoqulath <[EMAIL PROTECTED]> wrote: > What's wrong with the trigger? Triggers in SQLite are not yet recursive. This will likely be fixed at some point in the future so you should not depend on this behavior, but for now recursive triggers do not work. -- D. Richard Hipp <[EMAIL PROTECTED]> -

[sqlite] Re: I think lemon bug

Hmm.. sorry, maybe it's not a problem about directive. On my testing, '%' as modular operator doesn't cause problem. In printf, %u or %x works good. I think only '%d' is problem. On 10/13/06, Jong-young Park <[EMAIL PROTECTED]> wrote: Hi all. I want to use "Lemon" parser generator for my ow

[sqlite] I think lemon bug

Hi all. I want to use "Lemon" parser generator for my own project because of multi-threading. But I find the strange bug. I made sample calculator program for testing. See the part of grammar file : expr(X) ::= expr(A) PLUS NUM(B) . { X = A+B; printf("plus-result : %d\n",X); } Af

[sqlite] DELETE TRIGGER does not work as expected

Hi List I've got a Problem on deleting records via trigger. Table "tb_categorie" references itself to arrange data in a tree-structure like: cars(tag=1,parent_tag=0) vans (tag=2,parent_tag=1) pickups (tag=3,parent_tag=2) van (tag=4,parent_tag=2) sport