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

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] wrote:

Re: [sqlite] Re: Threads

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 application point of view

Re: [sqlite] SQLITE3 Prepare / Step

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 to re-execute

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

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 question, when a query

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

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

[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

[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 - CREATING A SQLITE3 BINARY INSTEAD OF A BASH

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 used to generate sqlite3

Re: [sqlite] HELP! DDD SQLite

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 Cory

[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 9/7/07,

Re: [sqlite] FTS2 suggestion

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

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 what I read I'd say the main

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 like

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] wrote:

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

[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

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 does a single job, and does

[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