Re: [sqlite] how it works

Dne čtvrtek 22 březen 2007 13:16 [EMAIL PROTECTED] napsal(a): > Jakub Ladman <[EMAIL PROTECTED]> wrote: > > Hi > > > > I need to know how this works in detail: > > I have sqlite3 database file stored on SD/MMC FLASH card and i would to > > insert rows to some tables often. There will be triggers

Re: [sqlite] how it works

Jakub Ladman <[EMAIL PROTECTED]> wrote: > Hi > > I need to know how this works in detail: > I have sqlite3 database file stored on SD/MMC FLASH card and i would to > insert > rows to some tables often. There will be triggers to clean old and obsolete > data. > How often it will write to

Re: [sqlite] how it works

> Hi > > I need to know how this works in detail: > I have sqlite3 database file stored on SD/MMC FLASH card and i would to insert > rows to some tables often. There will be triggers to clean old and obsolete > data. > How often it will write to database file? After every INSERT command, or it >

[sqlite] how it works

Hi I need to know how this works in detail: I have sqlite3 database file stored on SD/MMC FLASH card and i would to insert rows to some tables often. There will be triggers to clean old and obsolete data. How often it will write to database file? After every INSERT command, or it goes to some

Re: [sqlite] How sqlite works? Parsing SQL ect

Peter Michaux wrote: Does anyone have a pointer to a link or book that explains the process at a higher level then source code? http://sqlite.org/arch.html Roger - To unsubscribe, send email to [EMAIL PROTECTED]

[sqlite] How sqlite works? Parsing SQL ect

Hi, I would like to build a very light SQL database in javascript. I would like to learn how sqlite parses an SQL statement and then acts on this parsed information. Does anyone have a pointer to a link or book that explains the process at a higher level then source code? Thank you, Peter

Re: [sqlite] how sqlite works?

> > Understand? > > > On 9/15/06, Dennis Cote <[EMAIL PROTECTED]> wrote: > >> >> Cesar David Rodas Maldonado wrote: >> > If there a document of how SQLite Virtual Machine Works ( papers )? I >> > would >> > like do something similar with

Re: [sqlite] how sqlite works?

meen, If SQLite has two index and very large Index (about 10.000.000 each one) how do i merge it, I mean (index1 = index2 for every one and limit it in thousand). Understand? On 9/15/06, Dennis Cote <[EMAIL PROTECTED]> wrote: Cesar David Rodas Maldonado wrote: > If there a document of h

Re: [sqlite] how sqlite works?

Rodas Maldonado wrote: >> > If there a document of how SQLite Virtual Machine Works ( papers )? I >> > would >> > like do something similar with B-Tree, B+ Tree but i dont know how to >> > merge >> > a select with tow Index? Understand my question?? &

Re: [sqlite] how sqlite works?

using the two indexes as the sources. http://en.wikipedia.org/wiki/Merge_sort On 9/15/06, Dennis Cote <[EMAIL PROTECTED]> wrote: Cesar David Rodas Maldonado wrote: > If there a document of how SQLite Virtual Machine Works ( papers )? I > would > like do something similar with

Re: [sqlite] how sqlite works?

nt of how SQLite Virtual Machine Works ( papers )? I > would > like do something similar with B-Tree, B+ Tree but i dont know how to > merge > a select with tow Index? Understand my question?? > > Please answer me > see the links VDBE Tutorial and VDBE Opcodes near he bottom

Re: [sqlite] how sqlite works?

Cesar David Rodas Maldonado wrote: If there a document of how SQLite Virtual Machine Works ( papers )? I would like do something similar with B-Tree, B+ Tree but i dont know how to merge a select with tow Index? Understand my question?? Please answer me see the links VDBE Tutorial and VDBE

[sqlite] how sqlite works?

If there a document of how SQLite Virtual Machine Works ( papers )? I would like do something similar with B-Tree, B+ Tree but i dont know how to merge a select with tow Index? Understand my question?? Please answer me

Re: [sqlite] Re: [Bulk] Re: [sqlite] How sqlite3_column_double works?

Marcelo Zamateo wrote: Excuse me, i'm not good programming in c. A double is 8 bytes width. How does a function return anything other than 4 bytes (in eax register) if not in a pointer? I'm using sqlite from assembler. It depends upon which CPU and calling convention you (and your compiler) are

[sqlite] Re: [Bulk] Re: [sqlite] Re: [Bulk] Re: [sqlite] How sqlite3_column_double works?

I've got it: in c doubles are passed to a function by pushing its two dword parts: first the high and then the low part, and when it's the result of a double type function is returned in the ST0 of the FPU. Thank you! Marcelo.

Re: [sqlite] Re: [Bulk] Re: [sqlite] How sqlite3_column_double works?

On Wed, 02 Feb 2005 19:10:58 -0300, Marcelo Zamateo <[EMAIL PROTECTED]> wrote: > Clay Dowling said: > > > > > double sqlite3_column_double(sqlite3_stmt*, int iCol); > > > > returns a double, not a pointer to a double. > > > Thank you Clay. > Excuse me, i'm not good programming in c. A double is 8

Re: [sqlite] How sqlite3_column_double works?

Marcelo Zamateo said: > Hi everybody! > > I need a tip about how sqlite3_column_double works. I hoped it returns a > pointer to a 8-byte-real, but it don't. double sqlite3_column_double(sqlite3_stmt*, int iCol); returns a double, not a pointer to a double. That seems pretty straight forward to

[sqlite] How sqlite3_column_double works?

Hi everybody! I need a tip about how sqlite3_column_double works. I hoped it returns a pointer to a 8-byte-real, but it don't. Here is what i do: CREATE TABLE [tblTyped] ([a] TEXT, [n] NUMERIC, [i] INTEGER, [b] BLOB) Insert into tblTyped values('helo,,,', 1.1121, '8.0001', 'blob!!!') then