Re: [sqlite] p in sclp in parse.y

Hello Himanshu, I'll look into it today, and get back. Thanks Uma HG <[EMAIL PROTECTED]> wrote: Hello, Could you tell me what the 'p' in 'sclp' in 'parse.y' stands for? I am trying to make a modification to the grammar file. Also the rule for sclp uses selcollist and the rule for

Re: [sqlite] Re: Threads

AIL PROTECTED]> wrote: Do you have parallel I/O or are you using Windows or Unix? Uma Krishnan wrote: > How about when you need to take advantage of parallel I/O etc, or you need to > access multiple SQLite databases w/i a transaction? > > Are you dissuading thread usage from DB

Re: [sqlite] Re: Threads

How about when you need to take advantage of parallel I/O etc, or you need to access multiple SQLite databases w/i a transaction? Are you dissuading thread usage from DB application point of view, or even within SQLite kernel? Thanks in advance - Uma John Stanton <[EMAIL PROTECTED]>

Re: [sqlite] SQLITE3 Prepare / Step

chines using step. By compiling a SQL in advance you can ensure that the program will not fail in mid execution with an SQl error. Uma Krishnan wrote: > In SQLite3 one uses prepare/step to execute query. The question that I have > is, when your stepping yields no more rows, and one has t

[sqlite] SQLITE3 Prepare / Step

knows it has to reissue the query. In standard DB/JDBC parlance, one prepares (one time, unless recompiled), executes, loops for next (/step) until all rows fetched, then closes. Subsequently one can skip prepare and proceed to execute. Thanks in advance Uma Uma Krishnan <[EMAIL PROTEC

Re: [sqlite] HELP WITH SQLITE INTERNALS - VDBE and Virtual tables

Yes. Makes sense (not to cache query results for embedded apps). So what is cached. Just dirty pages? or are raw tables cached when queried? Thanks Uma Scott Hess <[EMAIL PROTECTED]> wrote: On 10/17/07, Trevor Talbot wrote: > On 10/17/07, Uma Krishnan wrote: > > One other

Re: [sqlite] HELP WITH SQLITE INTERNALS - VDBE and Virtual tables

Thanks John and Joe for your responses. As far as I know, Postgres does not have a virtual engine. I could be wrong. One other question, when a query is issued, does SQLite cache the results, so that future queries can be processed off the cache (I think not) Thanks Uma John Stanton <[EMAIL

[sqlite] HELP WITH SQLITE INTERNALS - VDBE and Virtual tables

Hello, I'm a student trying to understand SQLite for my DB project. There are a couple of aspects that I don't quite understand: 1) VDBE. I see how the vdbe stack is created using VDBEAddOp etc. But once the code is generated, I don't see when it's executed. Moreover, is it typical to have an

[sqlite] sqlite3_prepare vs. sqlite3_get_table

Hello, Is sqlite3_get_table a legitimate call when you want to get a bunch of rows? what are the pros and cons as against using sqlite3_prepare/step. Thanks in advance. Uma

[sqlite] HELP!!!! LINKING AND LOADING FTS - on Linux/Ubuntu

have the LD_LIBRARY set up correctly. What am I doing wrong? Thanks in advance Uma Uma Krishnan <[EMAIL PROTECTED]> wrote: Hello, I'm having trouble loading fts2. I modified makefile to create fts2 library on Linux/Ubuntu.I When I attempt to load fts2 using the command select load_ext

[sqlite] LINKING AND LOADING FTS - on Linux/Ubuntu

Hello, I'm having trouble loading fts2. I modified makefile to create fts2 library on Linux/Ubuntu.I When I attempt to load fts2 using the command select load_extension('fts2'), i get the error shared library not found. ( noticed that it had not created the .so file, only .la file.) What am I

Re: [sqlite] HELP - CREATING A SQLITE3 BINARY INSTEAD OF A BASH

shared make clean make sqlite3 optional: file sqlite3 ldd sqlite3 --- Uma Krishnan wrote: > I'm trying to debug sqlite3. But in order for me to do that, I need sqlite3 > binary. The makefile > generates a bash file. I'm confused as how that happens. After all, gcc is >

[sqlite] HELP - CREATING A SQLITE3 BINARY INSTEAD OF A BASH

Hello, I'm trying to debug sqlite3. But in order for me to do that, I need sqlite3 binary. The makefile generates a bash file. I'm confused as how that happens. After all, gcc is used to generate sqlite3 executable Any pointers will be much appreciated. Thanks Uma

Re: [sqlite] HELP! DDD & SQLite

points prior to execution. Ken Uma Krishnan wrote: Hello I'm trying to debug SQLite (to understand the code). But e when I attach the process sqlite3, the sqlite3 terminal hangs (ie would not accept any user inputs) till I detach. Can someone please tell me what I'm doing wrong Thanks Uma

[sqlite] HELP! DDD & SQLite

Hello I'm trying to debug SQLite (to understand the code). But e when I attach the process sqlite3, the sqlite3 terminal hangs (ie would not accept any user inputs) till I detach. Can someone please tell me what I'm doing wrong Thanks Uma Cory Nelson <[EMAIL PROTECTED]> wrote: On

Re: [sqlite] FTS2 suggestion

s like quality and recall, mostly because I'm not aware of any major users with enough of an installed baseline to even generate decent metrics. [Basically, solving concrete identified problems rather than looking for ill-defined potential problems.] -scott On 8/24/07, Uma Krishnan wrote: &

Re: [sqlite] sqlite db portability

Just FYI, ODBC specs is very similar to JDBC, except that ODBC is in C whereas JDBC is in java. Thanks Uma Markus Hoenicka <[EMAIL PROTECTED]> wrote: Quoting Uma Krishnan : > Hello Markus, > > How is libdbi different from, say odbc? > I've never used ODBC, but from w

Re: [sqlite] sqlite db portability

Hello Markus, How is libdbi different from, say odbc? Thanks in advance Uma Markus Hoenicka <[EMAIL PROTECTED]> wrote: Shilpa Sheoran writes: > Can the sqlite db file be accessed using another DB api's eg. MySQL > or anyother. > Not directly, but you can use a database abstraction layer

Re: [sqlite] FTS2 suggestion

Would it not be more useful to first implement potter stemmer algorithm, and then to implement n-gram (as I understand n-gram is for cross column fuzzy search?). What is the general game plan for FTS3 with regard to fuzzy search? Thanks in advance "Cesar D. Rodas" <[EMAIL PROTECTED]>

RE: [sqlite] In-Memory

Uma Krishnan 08/08/07 10:44 PM Please respond to sqlite-users@sqlite.org To sqlite-users@sqlite.org cc Subject RE: [sqlite] In-Memory Hello, Has anyone used SQLite as an In-Memory implementation. If so would you like to share your ideas? Thanks in advance - Uma

RE: [sqlite] In-Memory

Hello, Has anyone used SQLite as an In-Memory implementation. If so would you like to share your ideas? Thanks in advance - Uma

Re: [sqlite] sqlite3

How about the various implementations to use SQLite in client server environment (based on wiki): http://www.it77.de/sqlite/sqlite.htm http://www.oneledger.co.uk/sql4sockets.html http://users.iol.it/irwin/ http://sqlitedbms.sourceforge.net/ Does anyone have any experience any of these? Pros and

[sqlite] FTS2

Downloading SQLite source does not come with FTS2 source? If not, how do I download FTS2 source. I see only a way to download binary. Thanks in advance Uma

[sqlite] Lemon Parser: Modular

I had posted earlier to find if Lemon parser can be made modular. As per previous post responses, who had advised that I look in lemon parser forum. But I could not find a separate forum. Please refer to the following link to get a better idea of what I'm trying to do:

Re: [sqlite] Lemon Parser - Modular & Extensible ?

if this is the right group. But could not find a lemon parser user group. Christian Smith <[EMAIL PROTECTED]> wrote: Uma Krishnan uttered: > Hello: > > Is lemon parser modular and extensible? Extensible to do what? It generates parsers, and is self contained. It do

[sqlite] Lemon Parser - Modular & Extensible ?

Hello: Is lemon parser modular and extensible? Thanks Uma Asif Lodhi <[EMAIL PROTECTED]> wrote: Hi Everybody, I have just joined this mailing list as Sqlite looks like a good software solution to my needs. What I need right now is RE-assurance of "crash-recovery" that is