Maybe you are too C++ orientated. You have no need to touch any Sqlite
structure, that is what the API does. Just use it.
JS
Micha Bieber wrote:
@list
Maybe I'm too C++ biased - but what is the state of the sqlite3 and
similar - e.g. 'Db' - structures in sqlites C-Interface ? Is this
Micha Bieber wrote:
Thursday, May 18, 2006, 17:36:53, Jay Sprenkle wrote:
Since you pass that in to begin with, why do you need the database
to provide information you already have?
Thats by design (tm), but it might be not the best one. For performance reasons
I have splitted my project
Mike, if you are going to implement a lock server, why not finish the
job and include Sqlite in the server, then you will not have a problem.
JS
Mike Ashmore wrote:
Hello all,
I'm working on a system in which I'm using SQLite to open a number of
database files and to perform operations on
> It is not a smart technique to assume that you can access underlying
> data structures and expect them to remain identically placed between
> releases.
What do you think, was my reason to ask, whether these structures are public
and stable or not ... ;-)
Micha
--
Hi,
I can not find the maximum of an 'INTEGER AUTOINCREMENT' field. Is it greater
thar 50.000.000 ?
Thanks
--
Delf
[EMAIL PROTECTED] wrote:
I can not find the maximum of an 'INTEGER AUTOINCREMENT' field. Is it
greater thar 50.000.000 ?
It's a signed 64-bit value. The larget representable value is
0x7FFF = 9223372036854775807
Igor Tandetnik
I have an old port of Sqlite for Palm OS mentioned at
the wiki page:
http://www.sqlite.org/cvstrac/wiki?p=SqlitePalm
Other ports to Palm OS are also listed on the same
page.
HTH,
Jalil Vaidya
--- "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote:
> Hi,
> Does anyone have experience use SQLite
Hi Dennis
Thanks for your answer. You have see my problem and its solution.
I look sometimes at SQLite with my "OLE-DB"-Eyes. In OLE-DB is
the Recordset Reader and Writer allways at the same time.
Now I consider this... and it works fine.
Greetings, Anne
> I think you are saying you have
Hi to all
Today I inserted as a Test 100 Records in my DB. I repeat therefor
100 times the same "Insert into...". The Job starts and I wait,
and wait, and wait.
I say, Programm hangs or died, because I do a Mistake in Code.
But it isn't.
The Job needs really so much time. Trace-Message
Anne,
Try wrapping your inserts in a transaction. Individual inserts are
quite fast, but transactions are not. Therefor anything that you can do
to reduce the number of transactions will boost the speed. My
preference is to wrap a transaction around every 200 or 300 inserts,
depending on
On 5/19/06, Brannon King <[EMAIL PROTECTED]> wrote:
So I first had these commands:
create table blah (b INTEGER, c INTEGER);
insert into blah values(400,300);
insert into blah values(360,250);
select a,max(b-a) from blah where c=a and a > 200 and a < 500;
And how do I simply return a range of
On 5/20/06, Dennis Cote <[EMAIL PROTECTED]> wrote:
Brandon,
...
Brannon,
I'm sorry I got your name wrong. I try to be careful about that, but I now
see your's slipped by me a couple of times.
Dennis Cote
On 5/18/06, Brannon King <[EMAIL PROTECTED]> wrote:
The statement
CREATE UNIQUE INDEX primkey ON 4dData (x,y,z)
is too slow for me. It takes 13 sec on 700k records on my Athlon XP 2GHz.
That's about four seconds longer than it took me to put the data in there.
The two times together are still
Dennis Cote wrote:
Where did you get the idea there are "fake" columns?
"SELECT 200" returns 200. I'd call that a fake column. What is the
proper name for it?
What I was picturing was something like this: "SELECT (BETWEEN 200 AND
500) as a, a+2" and then get 300 outputs. That would be
I'v got the next problem:
string cola = "SELECT * FROM ultimo;";
char zErrMsg;
int ret = sqlite3_exec( base_datos, cola.c_str(), (bd::analisis_ultimo), 0,
);
the compiler tell me this:
/home/Programas/preguntas/src/bd.cpp:151: error: no matches converting
function `analisis_ultimo' to
Is it declared as a static function? Something like "static int
bd::analisis_ultimo(void* arg)" ? I assume it would need to be static
just like all the other thread function parameters or callback
parameters in various APIs.
Esteban Zeller wrote:
I'v got the next problem:
string cola =
El Sábado 20 Mayo 2006 21:40, Brannon King escribió:
> Is it declared as a static function? Something like "static int
> bd::analisis_ultimo(void* arg)" ? I assume it would need to be static
> just like all the other thread function parameters or callback
> parameters in various APIs.
>
> Esteban
Declare it static in the class declaration, not at the function definition.
Esteban Zeller wrote:
El Sábado 20 Mayo 2006 21:40, Brannon King escribió:
Is it declared as a static function? Something like "static int
bd::analisis_ultimo(void* arg)" ? I assume it would need to be static
just
It's done:
private:
static int analisis_ultimo( void *NotUsed, int argc, char **argv, char
**azColName );
ultima_entrada *ultima;
El Sábado 20 Mayo 2006 22:07, Brannon King escribió:
> Declare it static in the class declaration, not at the function definition.
>
> Esteban
I'm receiving sql errors like the following
"no such table: main.phs_matrices_1"
when trying to create an index using the syntax:
"CREATE INDEX IF NOT EXISTS phsm_1_idx ON phs_matrices_1 (a, b, c)"
from my C++ program.
The error statement is true - phs_matrices_1 doesn't belong to main,
but
The documentation says to put the database name on the front of the
index name, not the table name when using the create index command. I
thought it was weird myself.
Micha Bieber wrote:
I'm receiving sql errors like the following
"no such table: main.phs_matrices_1"
when trying to create
On 5/20/06, Esteban Zeller <[EMAIL PROTECTED]> wrote:
the functions uses the same prototipe of the example but it's inside of a
class
If you use the bind/step API calls instead you don't need to use callbacks.
It's much cleaner with C++. If you want examples you can look at the source
in the
At 21:28 20/05/2006, you wrote:
The benefits I'm trying to get out of sqlite are the data queries. I
collect a large, sparse 2D array from hardware. The hardware device
is giving me a few GB of data data at 200MB/s. Future hardware
versions will be four times that fast and give me terabytes of
For your mail i think you have everything planned, but just for
curiosity, how do you plan to pass data from hardware (800 MB/s +
Database data) to a raid?? A GigEthernet has 1000 Mb/s (so, 128 MB/s),
a PCI-X based solution has 1.3 to 2.6 Gb/s (so 150-300 MB/s), and
similar for SATA and
Anne, you don't say that you make your 100 inserts a transaction.
Unless you do that the ACID feature of Sqlite will make it slow as it
has to finalize each insert onto disk before starting on the next.
Within a transaction it will do the 100 inserts then finalize the entire
100 onto disk in
You don't seem to need a data manipulation system like Sqlite, more a
form of high volume storage. Do you really need elaborate SQL,
journalling, ROLLBACK and assured disk storage?
Di you consider some form of hashed storage, perhaps linear hashing, to
build a compact and high performance
John Stanton wrote:
You don't seem to need a data manipulation system like Sqlite, more a
form of high volume storage. Do you really need elaborate SQL,
journalling, ROLLBACK and assured disk storage?
Di you consider some form of hashed storage, perhaps linear hashing,
to build a compact
Brannon King wrote:
John Stanton wrote:
You don't seem to need a data manipulation system like Sqlite, more a
form of high volume storage. Do you really need elaborate SQL,
journalling, ROLLBACK and assured disk storage?
Di you consider some form of hashed storage, perhaps linear hashing,
28 matches
Mail list logo