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

! ;) -- Cesar Rodas http://www.cesarodas.com/ Mobile Phone: 595 961 974165 Phone: 595 21 645590 [EMAIL PROTECTED] [EMAIL PROTECTED]

Re: [sqlite] Powered by SQLite image?

to [EMAIL PROTECTED] - -- 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?

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

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 how to tweak Gimp, I'll

[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] Journal file question

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 join-mechanisms question

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 Rodas http://www.cesarodas.com/ Mobile Phone: 595 961 974165

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. CREATE TABLE a( word_id INTEGER

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( word_id INTEGER, doc_id INTEGER ); CREATE INDEX a_index1

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 where i could find

Re: [sqlite] SQL and SQLite pronounciation?

- 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

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

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] Version 3.3.14

] - -- 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 configure; make to get this error? Yes. I

Re: [sqlite] Using the Sqlite Btree Backend directly

] - -- 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. Using SQL is a little bit overkill why bother with SQLite then? Use

Re: [sqlite] invalid command name sqlite3

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

: 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, Thanks for the input. I tried changing the case

Re: [sqlite] multiple request handling

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

Re: [sqlite] SQLite installation problems

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]/ [EMAIL PROTECTED] //[EMAIL PROTECTED]/

Re: [sqlite] SQLite installation problems

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

] - -- Cesar Rodas http://www.cesarodas.com/ Mobile Phone: 595 961 974165 Phone: 595 21 645590 [EMAIL PROTECTED] [EMAIL PROTECTED]

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

[sqlite] Script Language

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] [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 algorithm in my University (National

Re: [sqlite] Script Language

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 language with LEMON FLEX. The main goal is to provide a easy way

[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

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 Subject

[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/projects/pagerank

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 use Parents () in math

[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/projects/pagerank (The PageRank

Re: [sqlite] BLOB question

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. -- Cesar Rodas http://www.sf.net

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, long * len

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 pointer to a char so the signature

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 (i0) *value = realloc(*value, (i+1) * Buffsize); memcpy(*value + (i * Buffsize), buff, Buffsize

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

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

[sqlite] misuse of aggregate function

); free(zErr); } } sqlite3_close(db); } -- 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] misuse of aggregate function

/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 my code /* ** SQLite uses this code for testing

[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 version of sqlite

Re: [sqlite] Performance test on windows

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 advance. //Gaurav -- Cesar Rodas http://www.sf.net/projects/pagerank (The PageRank made easy...) http

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

] - -- 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] A little help with count

-01-02|In| 120 | 0.20 | Thx Lloydie T - To unsubscribe, send email to [EMAIL PROTECTED] - -- Cesar Rodas http

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

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

Re: [sqlite] Version 3.3.9

] - - To unsubscribe, send email to [EMAIL PROTECTED] - -- Cesar Rodas

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

[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 interpreted language Thanks

Re: [sqlite] LEMON

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, 2006 11

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

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

[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, following

Re: [sqlite] Re: File Syste

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 level API, like

Re: [sqlite] Re: File Syste

://www.sqlite.org/arch.html might be a good starting point for further research. - To unsubscribe, send email to [EMAIL PROTECTED] - -- Cesar