[sqlite] SQLite join-mechanisms question

the doc_id that has word_id 1,2 and 4. And suppose that there is: - 4 docs with word_id 1 - 5 docs with word_id 2 - 353500 docs with word_id 4 What i am searching is a optimized way to join, i mean, the algorithm. And I think SQLite has a great performance with joins. Thank to all. -- Cesar

Re: [sqlite] SQLite join-mechanisms question

I want to know SQLite join algorithm On 12/04/07, P Kishor <[EMAIL PROTECTED]> wrote: On 4/12/07, Cesar Rodas <[EMAIL PROTECTED]> wrote: > Hello. > > I have a question about SQLite join-mechanisms. Let me explain with an > example. > > I have the follow table.

Re: [sqlite] SQLite join-mechanisms question

On 12/04/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: "Cesar Rodas" <[EMAIL PROTECTED]> wrote: > Hello. > > I have a question about SQLite join-mechanisms. Let me explain with an > example. > > I have the follow table. > CREATE TABLE a

Re: [sqlite] SQLite join-mechanisms question

Thank very very much That is the information that i was searching for! ;) On 12/04/07, Dennis Cote <[EMAIL PROTECTED]> wrote: Cesar Rodas wrote: > Thanks for the answer mister Hipp, but I am searching an SQL help. > I'd like > to know how is the SQLite join algorithm or whe

Re: [sqlite] Journal file question

create the journal)? PS: Yes, I know, I'm still google-ing, but I'm not having much luck, that's why I'm posting here.. Thanks! -- ...it's only a matter of time... -- Cesar Rodas http://www.cesarodas.com/ Mobile Phone: 595 961 974165 Phone: 595 21 645590 [EMAIL PROTECTED] [EMAIL PROTECTED]

[sqlite] SQLite wrapper

Hello to every one! I want to ask if there is a Ruby and/or Ruby on Rails SQLite wrapper... Thanks to all. -- Cesar Rodas http://www.cesarodas.com/ http://cesars.users.phpclasses.org/winners.html - I won!!! ;) Mobile Phone: 595 961 974165 Phone: 595 21 645590 [EMAIL PROTECTED] [EMAIL PROTECTED]

Re: [sqlite] Powered by SQLite image?

y to put one up tomorrow :) Cheers Thanks -- Alberto Simões - To unsubscribe, send email to [EMAIL PROTECTED] ----- -- Cesar Rodas http://www.cesarodas.com/ http://cesars.users.phpclasses.org/winners.html I won ;) Mobile Phone:

Re: [sqlite] Powered by SQLite image?

eers Alberto -- Alberto Simões - To unsubscribe, send email to [EMAIL PROTECTED] ----- -- Cesar Rodas http://www.cesarodas.com/ http://cesars.users.ph

Re: [sqlite] Powered by SQLite image?

Will u please send me to this email? thank you On 04/05/07, Alberto Simões <[EMAIL PROTECTED]> wrote: On 5/4/07, Cesar Rodas <[EMAIL PROTECTED]> wrote: > Looks great... and this image is public domain? Sure. Be free to use it. Also, I have the xcf file. So if anybody knows ho

Re: [sqlite] Re: INSERT OR REPLACE without new rowid

This is a good solution! Thanks for your idea man! ;) -- Cesar Rodas http://www.cesarodas.com/ Mobile Phone: 595 961 974165 Phone: 595 21 645590 [EMAIL PROTECTED] [EMAIL PROTECTED]

[sqlite] File Syste

".c" file? -- Cesar Rodas http://www.phpclasses.org/grank (A PHP implementation of PageRank)

[sqlite] Re: File Syste

I mean.. is there a manual that explain how to use SQLite Core in low level API, like berkeley DB, without SQL. Thank to all On 13/12/06, Cesar Rodas <[EMAIL PROTECTED]> wrote: Hello to all I starting a project http://code.google.com/p/gxdfs/ that is a Distributed File System, fol

Re: [sqlite] Re: File Syste

magine the public API will get you pretty far. Pat -Original Message- From: Cesar Rodas [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 13, 2006 6:21 AM To: sqlite-users@sqlite.org Subject: [sqlite] Re: File Syste I mean.. is there a manual that explain how to use SQLite Core in low lev

Re: [sqlite] Re: File Syste

--- To unsubscribe, send email to [EMAIL PROTECTED] ----- -- Cesar Rodas http://www.phpclasses.org/grank (A PHP implementation of PageRank)

Re: [sqlite] Problem with sqlite3 on CGI scripts with ANSI C

be secure or error-free. If you receive this communication unintentionally, please inform us immediately. Thank you. > > > - To unsubscribe, send email to [EMAIL PROTECTED] - -- Cesar Rodas http://www.phpclasses.org/grank (A PHP implementation of PageRank)

[sqlite] LEMON

Where can i find a tutorial with examples of how to use LEMON parser... because i need to build interpreted language Thanks to all -- Cesar Rodas http://www.phpclasses.org/grank (A PHP implementation of PageRank)

Re: [sqlite] LEMON

Another URL where i can find a tutorial? On 29/12/06, Lloyd <[EMAIL PROTECTED]> wrote: Ethereal make use of Lemon On Fri, 2006-12-29 at 11:08 -0400, Cesar Rodas wrote: > Where can i find a tutorial with examples of how to use LEMON parser... > because i need to build interpre

Re: [sqlite] LEMON

erator-tutori al.html Looks OK but I have not looked at this site before. Shawn M. Downey MPR Associates 10 Maxwell Drive, Suite 204 Clifton Park, New York 12065 518-371-3983 x113 (work) 860-508-5015 (cell) -Original Message- From: Cesar Rodas [mailto:[EMAIL PROTECTED] Sent: Friday, December 29

Re: [sqlite] Version 3.3.9

- To unsubscribe, send email to [EMAIL PROTECTED] - -- Cesar Rodas http://www.phpclasses.org/grank (A PHP implementation of PageRank)

[sqlite] SQLite on tempfs

Hello I am wondering if will be faster if i create a SQLite DB in a tempfs, but with out index?

Re: [sqlite] A little help with count

Out | 47 | 0.10 | | 4 |2007-01-02|In| 120 | 0.20 | Thx Lloydie T - To unsubscribe, send email to [EMAIL PROTECTED] ------

Re: [sqlite] Re: A little help with count

ws from mytable; Igor Tandetnik - To unsubscribe, send email to [EMAIL PROTECTED] ----- -- Cesar Rodas http://www.sf.net/projects/pagerank (The PageRank made easy...) M

Re: [sqlite] Database is locked when working in 2 processes

[EMAIL PROTECTED] ----- -- Cesar Rodas http://www.sf.net/projects/pagerank (The PageRank made easy...) http://www.sf.net/projects/fastfs ( The Fast File System) Mobile Phone: 595 961 974165 Phone: 595 21 645590 [EMAIL PROTECTED] [EMAIL PROTECTED]

Re: [sqlite] Performance test on windows

ecords ~113 seconds. > > May be I did something wrong for building, or the parameters passed for > building sqlite werent correct. > I am willing to update the test results on the site, could anyone here > guide > me for the things which I might be doing wrong. > > Thanks in adv

[sqlite] Where could i find?

I am wondering if there is a place on the net that I could download all the version of sqlite? I mean sqlite v1.x.x, sqlite v2.x.x I really want the 1.x.x becouse the code is easier to understand, and is simplest that the sqlite3 -- Cesar Rodas http://www.sf.net/projects/pagerank

Re: [sqlite] Where could i find?

I just try-out on http://www.sqlite.org/sqlite-1.0.18.tar.gz and doesn't work... please if any body have the source.. I really need it.. thanks to all On 02/02/07, Cesar Rodas <[EMAIL PROTECTED]> wrote: I am wondering if there is a place on the net that I could download all the v

[sqlite] misuse of aggregate function

CHAR(50) NULL"\ ");", /* Insert */ "INSERT INTO users VALUES('root',md5(\"root\"),'Root','[EMAIL PROTECTED]');" }; void BeginSQLiteTable() { sqlite3 *db; int rc; char *zErr; rc = sqlite3_open("scvBase.db",); if (rc != SQLITE_O

Re: [sqlite] misuse of aggregate function

D]'); thanks to all On 08/02/07, Cesar Rodas <[EMAIL PROTECTED] > wrote: I am compliled the test_md5.c with my sqlite, but when i execute something I get the follow error "Error: misuse of aggregate function md5() " Any one can helpme please? Thanks to all Here i post m

[sqlite] BLOB question

Does any one has a C code to save a binary file into a blob, and wants to share? Because i am getting an "segmentation fault" error from a file that I load into memory then I generate the query with a sqlite3_mprintf.. Thanks to all -- Cesar Rodas http://www.sf.net/project

Re: [sqlite] BLOB question

'%Q') ", value); /* here i have a segmentation fault! */ /** Here I compile in debug mode there segmentation fault is here */ sqlite3/printf.c LINE 608 for(i=n=0; (ch=escarg[i])!=0; i++){ escarg is NULL; I know that is not an SQLite bug. I know that that is my fault. Thanks.

Re: [sqlite] BLOB question

I found the answer!! http://www.sqlite.org/cvstrac/wiki?p=BlobExample thanks for you help too Wesley On 23/02/07, Cesar Rodas <[EMAIL PROTECTED]> wrote: #define E_IO_COULDNT_OPEN - 1 #define E_IO_ERRO -2 #define uchar unsigned char * int LoadFileContent(uchar *path, uchar ** value

Re: [sqlite] BLOB question

Sorry I copy bad when I wanted to write "#define uchar unsigned char" but I did "#define uchar unsigned char *" On 23/02/07, Martin Jenkins <[EMAIL PROTECTED]> wrote: Cesar Rodas wrote: > #define uchar unsigned char * suggests it's a char but is in fact a point

Re: [sqlite] BLOB question

good idea!! i didn't think in this!! On 23/02/07, Martin Jenkins <[EMAIL PROTECTED]> wrote: Cesar Rodas wrote: >while ( (n=fread(buff,Buffsize,1,file)) > 0) >{ >if (i>0) >*value = realloc(*value, (i+1) * Buffsize); >memcpy(*v

Re: [sqlite] (newbie) pictures in tables, what's the best way ?

, Stef Mientki - To unsubscribe, send email to [EMAIL PROTECTED] - -- Cesar Rodas http://www.sf.net/projects/pagerank (The PageRank made easy...

[sqlite] Lemon example

Here is Lemon tutorial. Shows how to make a calculator with a feature of use Parents "()" in math expression. http://www.cesarodas.com/2007/03/creating-basic-calculator-with-lemon.html. The author disclaims the copyright of the calculator. -- Cesar Rodas http://www.sf.net/project

Re: [sqlite] Lemon example

The URL is ok, I opened here... try again and let me know if you could not and I will email you the content of the example. On 05/03/07, Clay Dowling <[EMAIL PROTECTED]> wrote: Cesar Rodas wrote: > Here is Lemon tutorial. Shows how to make a calculator with a feature of >

[sqlite] Update question

Hello to all I want to know if sqlite supports updates to more than a table, as mysql allows Ex: UPDATE items,month SET items.price=month.price WHERE items.id=month.id; Thanks to all

Re: [sqlite] Update question

eeking a passionate developer to join our team building products. Position is in the Washington D.C. metro area. If interested contact [EMAIL PROTECTED] -Original Message- From: Cesar Rodas [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 07, 2007 2:53 PM To: sqlite-users@sqlite.org S

[sqlite] Script Language

a SQLite support in the core, for teach SQL too. Is any one instresting to help in this project? Thanks to all. PD: The language doesn't have a name jet, and will be Public Domain. -- Cesar Rodas http://www.cesarodas.com/ Mobile Phone: 595 961 974165 Phone: 595 21 645590 [EMAIL PROTECTED

Re: [sqlite] Script Language

Your help will be welcome. On 09/03/07, Noel Frankinet <[EMAIL PROTECTED]> wrote: Cesar Rodas a écrit : > I am planning to develop a interpreted language with LEMON && FLEX. > The main > goal is to provide a easy way to script commons actions, and to teach >

Re: [sqlite] Script Language

with code On 09/03/07, Noel Frankinet <[EMAIL PROTECTED]> wrote: Cesar Rodas a écrit : > Your help will be welcome. > > On 09/03/07, Noel Frankinet <[EMAIL PROTECTED]> wrote: >> >> Cesar Rodas a écrit : >> > I am planning to develop a interpreted

[sqlite] LEMON question

I want to know if I can here public some LEMON PARSER examples that I have done... because as i far i know LEMON is maintained into SQLite project. Best Regards -- Cesar Rodas http://www.cesarodas.com/ Mobile Phone: 595 961 974165 Phone: 595 21 645590 [EMAIL PROTECTED] [EMAIL PROTECTED]

Re: [sqlite] Search engines and the Sqlite.Org website

-- To unsubscribe, send email to [EMAIL PROTECTED] ----- -- Cesar Rodas http://www.cesarodas.com/ Mobile Phone: 595 961 974165 Phone: 595 21 645590 [EMAIL PROTECTED] [EMAIL PROTECTED]

Re: [sqlite] SQLite installation problems

my system? Also is there an rpm package for RH4 enterprise? Thanks, Brian -- Cesar Rodas http://www.cesarodas.com/ Mobile Phone: 595 961 974165 Phone: 595 21 645590 [EMAIL PROTECTED] [EMAIL PROTECTED]

Re: [sqlite] SQLite installation problems

is there an rpm package for RH4 enterprise? Thanks, Brian -- Cesar Rodas http://www.cesarodas.com/ Mobile Phone: 595 961 974165 Phone: 595 21 645590 [EMAIL PROTECTED] [EMAIL PROTECTED]

Re: [sqlite] invalid command name "sqlite3"

- To unsubscribe, send email to [EMAIL PROTECTED] ----- -- Cesar Rodas http://www.cesarodas.com/ Mobile Phone: 595 961 974165 Phone: 595 21 645590 [EMAIL PROTECTED] [EMAIL PROTECTED]

Re: [sqlite] invalid command name "sqlite3"

- From: Cesar Rodas [mailto:[EMAIL PROTECTED] Sent: Friday, March 30, 2007 12:31 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] invalid command name "sqlite3" what OS are you using? On 30/03/07, Reber Douglas-ra7758 <[EMAIL PROTECTED]> wrote: > > Noah, > > Thank

Re: [sqlite] multiple request handling

Pavan. -- ' Always finish stronger than you start * -- Cesar Rodas http://www.cesarodas.com/ Mobile Phone: 595 961 974165 Phone: 595 21 645590 [EMAIL PROTECTED] [EMAIL PRO

Re: [sqlite] Using the Sqlite Btree Backend directly

- To unsubscribe, send email to [EMAIL PROTECTED] - -- Cesar Rodas http://www.cesarodas.com/ Mobile Phone: 595 961 974165 Phone: 595 21 645590 [EMAIL PROTECTED] [EMAIL PROTECTED]

Re: [sqlite] Using the Sqlite Btree Backend directly

On 31/03/07, Cesar Rodas <[EMAIL PROTECTED]> wrote: On 30/03/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > <[EMAIL PROTECTED]> wrote: > > > > > > > > I'm looking at using Sqlite as a storage backend for a program. > > > > Usin

Re: [sqlite] Version 3.3.14

-- To unsubscribe, send email to [EMAIL PROTECTED] - -- Cesar Rodas http://www.cesarodas.com/ Mobile Phone: 595 961 974165 Phone: 595 21 645590 [EMAIL PROTECTED] [EMAIL PROTECTED]

Re: [sqlite] Version 3.3.14

sorry! was only my proxy cache.. On 02/04/07, Cesar Rodas <[EMAIL PROTECTED]> wrote: here http://www.sqlite.org/download.html i only could see the 3.13.. what is wrong with that? On 02/04/07, Clark Christensen <[EMAIL PROTECTED]> wrote: > > > Did you use "configur

Re: [sqlite] sqlite and generate dynamic html

To unsubscribe, send email to [EMAIL PROTECTED] --------- -- Cesar Rodas http://www.cesarodas.com/ Mobile Phone: 595 961 974165 Phone: 595 21 645590 [EMAIL PROTECTED] [EMAIL PROTECTED]

Re: [sqlite] sqlite and generate dynamic html

gt; > - > To unsubscribe, send email to [EMAIL PROTECTED] > > - > > -- Vivek Rajan (503) 646-3985 -- Cesar Rodas http://www.cesarodas.com/ Mobile Phone: 595 961 974165 Phone: 595 21 645590 [EMAIL PROTECTED] [EMAIL PROTECTED]

Re: [sqlite] SQL and SQLite pronounciation?

' letters in Portuguese. Cheers -- Alberto Simões - To unsubscribe, send email to [EMAIL PROTECTED] --------- -- Cesar Rodas http://www.cesarodas.com/ Mobile Phone: 595 961 974165 Phone: 595 21 645590 [EMAIL PROTECTED] [EMAIL PROTECTED]