Has anybody else had trouble debugging SQlite3 in Visual Studio Express?
Here's what I have: Made a Visual Studio Express project, put the SQLite3
code in, added shell.c, put a breakpoint in sqlite3_exec, and ran the
debugger (debugging argument goes through sqlite3_exec). No stop. Then I
put a br
> As long as your values are within the range of -128 to +127, your
> integers will only take one byte of storage (plus common overhead).
>
There's an extra byte of meta data for each column value in each
row due to manifest typing, so an int will take at least 2 bytes
of storage per colu
> only compiled and linked into an application. There is no server.
Martin, thank you for the answer.
I do not really understand "compiled", "linked into an application"
and "there is no server".
They are far too technical terms.
But, judging from your short answer, I believe that there is no way
I have been trying to understand if and how it is it possible for me
to install SQLite, but due to my little knowledge I find no way.
Also, no information at all is given on the official site, apart from
a general "installation is trivial: just copy the sqlite or sqlite.exe
executable to the target
SELECT lat, lon, depth FROM hydro
WHERE depth>= 49.01 AND depth <=50.99;
The SELECT may be faster still if you use this index instead:
CREATE INDEX hydro_indx2 ON hydro (depth, lat, lon);
as the query can find all the information in the index without
hitting the pages of the main table.
When used with the index, the query may be producing too
many random (slow) disk seeks into your 2GB+ database table.
Increasing the page cache substantially may help.
But if the rows of the main table were accessed in order it might
also reduce the number of page seeks. Out of curiosity, without
I would like to use SQLite from a network share. I would like to create a
server app that would do all of the writing to the database except for
certain tables, one table per client,the clients would write to their own
table only. The client drops it's data/instructions into it's own table,
the s
see sqlite3_index_info.estimatedCost
http://www.sqlite.org/cvstrac/chngview?cn=5649
> AFAICT, when you have a join where one table has a good index, the
> virtual table cannot signal that it has an even better index. I could
> not follow the index-selection logic well enough to have any
> sugge
> One occasionally sees SQLite schemas of the following form:
>
>CREATE TABLE meta(id LONGVARCHAR UNIQUE PRIMARY KEY, );
>
> In other words, one sometimes finds a PRIMARY KEY and a UNIQUE
> declaration on the same column. This works fine in SQLite, but it is
> wasteful, both of disk s
I understand that the SQLite database resides in memory. I understand that
the information in memory gets written to disk, ie saving parts that have
been updated/whole database.
I have read that SQLite has been known to support up 100,000 concurrent
read connections and can support several teraby
> Change cache sizes using separate cache_size
> pragmas for each attached database.
Thank you! (It would be nice if there is a hint for this behaviour in
http://www.sqlite.org/lang_attach.html.)
Is this correct? (At least it does not return an error)
PRAGMA job01.cache_size=200
PRAGMA job02.ca
> Depending on what you are storing in fs_textid and what your LIKE
> pattern is, you might get much better performance (and lower memory
> usage) if you use GLOB instead of LIKE and if you explicitly code the
> pattern rather than using the wildcard "?", and if you create a new
> index:
>
ases whose are attached to a main database. I hope I can do it with GLOB.
At the moment, the question is still unanswered, why LIKE consumes multiple
times 2.5MB when applied to attached
dabases.
Daniel
Ursprüngliche Nachricht----
Von: [EMAIL PROTECTED]
Datum: 15.08.2008 16:30
An
; INTEGER,
'fs_textid' TEXT,
'fs_flag1' INTEGER,
'fs_object' BLOB );
The size of a single record is typically 100 bytes.
Please let me know if you didnt get the example database I sent directly to
[EMAIL PROTECTED]
Regards
Daniel
_
> This causes most of the database to be loaded into cache.
Is there one cache per database connection or one cache per ATTACH'ed database?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
I don’t dare to use the term “leak” here. It is hard so say at the moment where
the memory is going to. At least, the
memory is not freed when sqlite3_finalize() is called on the statement. Might
it be possible, that this memory is
allocated once per attached database and used for caching reas
Hello
Why does SQLite consume 2.5MB memory every time when running a statement on a
attached database with LIKE operator?
Example 1:
SELECT fs_rec FROM fs_main WHERE fs_itemtype=? AND fs_textid LIKE ?;
// consumes <50kB RAM
Example 2:
SELECT fs_rec FROM _job01.fs_main WHERE fs_itemt
Hello,
to answer the following question:
Amount of memory for caching one page with x byte page size?
I found in the Draft 3.6.0 Doc the following information:
PRAGMA page_size = bytes;
Query or set the page size of the database.
The page size may only be set if the database has not yet be
Hello
As usual, there is no general rule. You have to define the best settings for
your embedded environement yourself.
Start here:
"[sqlite] Performance tuning using PRAGMA, other methods"
http://www.mail-archive.com/sqlite-users@sqlite.org/msg29343.html
Try different settings to get the feel
Hello Filipe
Have you already checked your PRAGMA settings four your embedded version? (see
http://www.sqlite.org/pragma.html)
On which operation do you have you performance decrease? Is it INSERT
performance?
Daniel
___
sqlite-users mailing list
sq
quickly. The often discussed "trigger
COUNT() solution" might not be applicable here.
Daniel
Ursprüngliche Nachricht----
Von: [EMAIL PROTECTED]
Datum: 14.07.2008 00:51
An:
Betreff: Re: [sqlite] COUNT() on indexed tables / primary keywith
100'000records
<[EMAIL PR
Hello
Lets say i have 120'000 records and worst case is that upto 90'000 records
match the conditions.
Daniel
Ursprüngliche Nachricht----
Von: [EMAIL PROTECTED]
Datum: 13.07.2008 17:16
An:
Betreff: Re: [sqlite] COUNT() on indexed tables / primary key with
100'000r
Hello
I have following table with around 100'000 rows / ~10MB on a embedded device:
CREATE TABLE 'fs_main' (
'fs_recid' INTEGER PRIMARY KEY NOT NULL,
'fs_contenttype' INTEGER,
'fs_itemtype' INTEGER,
'fs_job' INTEGER,
'fs_textid' TEXT,<- ~5 chars per Record
'fs_flag1' IN
Hi!
We have a 14MB SQLite database on a 16MB flash disk. The journal file gets to
big on some queries, which results in a
SQLITE_FULL error.
Any other ideas to make data storage secure?
Regards
Daniel
___
sqlite-users mailing list
sqlite-users@sqlite
Hello
Is it safe do set PRAGMA synchronous = OFF when a transaction-safe file system
is used?
We are working on WinCE with TFAT (see below) - but this might be a general
question.
Regards
Daniel
TFAT:
The original file allocation table (FAT) file system enabled file modification
operations t
>De: [EMAIL PROTECTED]
>Fecha: 27/05/2008 19:56
>
>It's not supposed to, according to
>http://sqlite.org/lang_createtrigger.html . The syntax
>only allows select, insert, update and delete statements.
>
>What are you trying to achieve?
I need to handle tables wit
Does not work:
CREATE TABLE ttt ( t INTEGER PRIMARY KEY );
CREATE TRIGGER ttt_new_trigger AFTER INSERT ON ttt FOR EACH ROW
BEGIN
CREATE TABLE uuu ( u INTEGER PRIMARY KEY );
END;
SQL error: near "CREATE": syntax error
If I try the CREATE TABLE outside the trigger, it succeds.
If I replace CR
Hello i'm using sqlite with turbogears, and any time i try to store a file in a
blobcol of more that 1mb i get this error:
DataError: String or BLOB exceeded size limit
reading the paper the default value of sqlite for blobclo is 10 but why
i get this error
Thanks and Regards
Luca
___
Thanks Keith,
found them here: http://www.sqlite.org/sqlite-source-2_8_17.zip
On Sat, 10 May 2008 07:08:44 -0700
"Keith Goodman" <[EMAIL PROTECTED]> wrote:
> On Sat, May 10, 2008 at 4:38 AM, [EMAIL PROTECTED]
> <[EMAIL PROTECTED]> wrote:
> > where do
Hi All,
where do I find the latest sqlite2 tarball ?
Thanks for supporting,
Mike
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
I'm using sqlite3 on embedded system.
I've got a very very large
memory usage.
My program must loop to show some values catched from a
table using SELECT statement.
In a while memory usage grow over
phisical RAM, so my device lock.
If I run the same code on a PC after
some minutes the process
Hello
I must use SQLite functions of PHP 4, but it seems that these functions doesn't
works with SQLite 3.
What can I do?
best regards
Giovanni Rossati
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/list
SOLVED!
Thanks to all and expecially to Dennis
I've found MY
MISTAKE!!! :-)
My head is safe ;-)
The error was in
my_custom_function.
Inside this function I need to query the same table
to retrieve some values needed to calculate the float value.
Inside
my_custom_function I use the prepare
I've found what's matter, but I don't understand why ?
I've tried to
use the sqlite3_mprintf() to prepare my sql.
If my numeric fValue is
integer the SQL works fine, but if I've got a floating value the sql
doesn't update the table.
And the bad is that I can get any error
I'll try to expla
>The code looks OK except for the typo (i.e. sPre[2048[ should be
>
sPre[2048]).
Yes, It's a mistype on the mailinglist, the code it's ok!
> I assume that your real table isn't named "table" since that is a
keyword.
The real table name is "inputai"
> Can you open the database
file using the s
The code is very long, I'll try to put here the core of my application.
I'm using a C++ Class where one function is "sqlraw" that I use to
execute a SQL statement:
CLASS DEFINITION
sqlite3 *db;
int expander::
open_db(char * pDbName)
{
int rc;
rc = sqlite3_open(pDbName,
I'm working on a program using sqlite library, but I've got an issue
that I can't solve.
Suddenly, my program don't update the tables
I
don't understand whats matter because, if I write SQL instructions
using Sqlite3 client, UPDATE works fine, and I haven't any ERROR CODE.
sqlite3_exec funct
Hello
My problem is that the SQLites Functions don't recognize the DBs SQLite3, and
Bambalan uses PHP 4.4 that it doesn't support PDO.
I believe that the problem is resolvable because I have developed an
application with Roadsend and SQLite3 with PHP 4 without problems.
I also have another si
Thanks, that
helped.
[EMAIL PROTECTED] wrote:
"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote:
Got the
sqlite3.exe version 3.5.5 but .explain still doesn't seem to work.
Maybe it's me, could someone post a simple example of .explain working?
Got the
sqlite3.exe version 3.5.5 but .explain still doesn't seem to work.
Maybe it's me, could someone post a simple example of .explain working?
[EMAIL PROTECTED] wrote:
Also,
.schema and .explain don't seem to do anything in then sqlite3.exe
version 3.5.4. I downloaded in s
ginal Message - From: <[EMAIL PROTECTED]>
To:
Sent: Friday, February 01, 2008 1:33 AM
Subject: [sqlite] Version 3.5.5 Released
SQLite version 3.5.5 is now available for download from the
SQLite website:
http://www.sqlite.org/
The big change from version 3.5.4 is that the inter
peration within SQLite when I set SQLITE_THREADSAFE=0.
Implementing an efficient RW lock on Windows XP is another challenge
anyway.
-- sword
On Sat, 19 Jan 2008 22:56:43 +0100
Jens Miltner <[EMAIL PROTECTED]> wrote:
>
> Am 19.1.08 um 03:13 schrieb [EMAIL PROTECTED]:
>
> > OK I
OK I figured out SQLITE_THREADSAFE=0 for the second question...
And it seems the answer for the first question is yes, but if you know
a simpler way please share it with us, thanks!
-- sword
On Sat, 19 Jan 2008 09:57:10 +0900
"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote:
> H
ze all SQLite access in the client code.
Regards,
-- sword
-----
To unsubscribe, send email to [EMAIL PROTECTED]
-
--
AlphaC
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
spaces.live.com/spacesapi.aspx?wx_action=create&wx_url=/friends.aspx&mkt=en-us
>
---------
To unsubscribe, send email to [EMAIL PROTECTED]
-
Barabbas Jiang Gmail <[EMAIL PROTECTED]> writes:
>
> Hi all,
>
> I found another strange problem of SQLite on Vista with IE7.
> I have an input method with SQLite. When I opened it in IE7 for
> typing Chinese, the SQLite returned nothing. However, *if IE7 is
> &qu
John Stanton a écrit :
John Stanton wrote:
[EMAIL PROTECTED] wrote:
John Stanton a écrit :
[EMAIL PROTECTED] wrote:
Hello,
I got an error when I try to read some data outside the while{},
inside the while{} it's ok, an idea ?
test.db have just one "table1" and a "
Igor Tandetnik a écrit :
[EMAIL PROTECTED] wrote:
while(sqlite3_step(pStat) != SQLITE_DONE)
{
switch (sqlite3_step(pStat)) {
You call sqlite3_step twice on every iteration, which means you are only
looking at every other row. That's probably not what you wanted.
John Stanton a écrit :
[EMAIL PROTECTED] wrote:
Hello,
I got an error when I try to read some data outside the while{},
inside the while{} it's ok, an idea ?
test.db have just one "table1" and a "field1" with values "one",
"two", "three&quo
"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: Hello,
I got an error when I try to read some data outside the while{}, inside the
while{} it's ok, an idea ?
test.db have just one "table1" and a "field1" with values "one", "two",
Simon Davies a écrit :
On 09/10/2007, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Hello,
I got an error when I try to read some data outside the while{}, inside the
while{} it's ok, an idea ?
test.db have just one "table1" and a "field1" with values "on
); // error
}
sqlite3_finalize(pStat);
sqlite3_close(db);
return 0;
}
Fred.
---------
To unsubscribe, send email to [EMAIL PROTECTED]
-
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 07 October 2007 17:39
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Re: Callback fonction really not flexible to use
Igor Tandetnik a écrit :
[EMAIL PROTECTED] wrote:
Here a sample (in c) of the use i
Igor Tandetnik a écrit :
[EMAIL PROTECTED] wrote:
Here a sample (in c) of the use i would like to do with sqlite
fucntion1() call fonction2() where is sqlite3_exec()
Callback function is the function3() and i would like to add data
in an array, which is retuned to function1() after
can do that ? does the Callback function can return something else than an int ?
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
ror in my code and it works. Hope drh
adds it in
the CVS.
I second that Win9X support should be dropped, it's as pointless as supporting
MS-DOS now.
It should have been dropped when sqlite3 was released.
-- sword
On Wed, 05 Sep 2007 10:20:37 +0200
Ralf Junker <[EMAIL PROTECTED]> wrote:
Tank you very much, I know that all of the sqlite's operates will be parsed
to vdbe code, but i don't know
how can i get the map of vdbe code to file operate.
Ben Combee wrote:
>
> On 7/30/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>>
>> hello, I por
.
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
Hello,
Look at this example with triggers...
regards,
Yves.
SQLite version 3.4.0
Enter
instead ..(196 '1')..2
with ..(195 '1')..22.
HTH
>regards
>ragha
-----
To unsubscribe, send email to [EMAIL PROTECTED]
-
I've download the amalgamation (single .c file) version of SQLite 3.3.17 and
I'm trying to compile it using Embedded Visual C++ 3.0, but I'm getting some
compiling errors such as,fatal error C1083: Cannot open include file:
'assert.h': No such file or directoryIs there any special settings I
Hello drh and lists,
Thank you for the information provided at
the ticket page at
http://www.sqlite.org/cvstrac/tktview?tn=2409
Now I successfully worked around the problem.
--
tamagawa ryuji
[EMAIL PROTECTED] :
> "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote:
>> I&#x
Perhaps you can open a new ticket and include the code and database
>> as an attachment.
>
> I'm grad to do that.
> --
> tamagawa
ged?
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
Hi all,
I found another strange problem of SQLite on Vista with IE7.
I have an input method with SQLite. When I opened it in IE7 for
typing Chinese, the SQLite returned nothing. However, *if IE7 is
"run as administrator," SQLite works.*
Generally I know IE7 on Vista has a implicit security rules:
is not to offtopic).
Regards,
Daniel
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
.17 (also tried 3.3.13 and failed)
WinCE 5.0
Regards
Daniel
-----
To unsubscribe, send email to [EMAIL PROTECTED]
-
b6s" Jiang/
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
---
To unsubscribe, send email to [EMAIL PROTECTED]
-
kSymbol,sExpiryDate, nStrikePrice DESC;
I would appreciate any suggestions on how I can generate an appropriate
SQL statement.
Thanks,
Roger
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
tored (directory extended properties).
-
To unsubscribe, send email to [EMAIL PROT
;copy" some directory to C:\, outside Windows and
Program Files. That copied directory will still be affected by Vista's
restore/backup functionality, i. e. it will have a shadow copy that
confuse SQLite.
Regards,
/Mike/
---
unsubscribe, send email to [EMAIL PROTECTED]
-
Pavan 提到:
Hi,
Can we store/retrieve Japanese/korean characters in sqlite db ?
Thanks,
Pavan.
UTF-8 (or Unicode) rules!
Cheers,
Mike
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
, send email to [EMAIL PROTECTED]
-
.db ".dump" just gives me:
BEGIN TRANSACTION;
COMMIT;
What would cause sqlite3 not to be able to see any tables in my
database?
Thank you very much.
Rob Richardson
-
To unsubscribe, send email
d the
problem db file with the one i just created.
Thanks for the help,
Ian
-- Forwarded message --
From: Steven Danneman <[EMAIL PROTECTED]>
Date: Oct 20, 2006 6:05 PM
Subject: Re: [sqlite] problems reading a sqlite db
To: sqlite-users@sqlite.org
It's possible that
eally 100% sure how i can verify that though.
Can anyone offer any suggestions as to how i would troubleshoot and resolve
this?
thanks
Ian
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
ho ask for your help.
Someone should make> you a saint and pray so you help them.> > > > > On 7/7/06,
John Stanton <[EMAIL PROTECTED]> wrote:> >>>> Sigh Free help is a
privilege, not a right. Explanations are not>> pointless, they are
education
Hi,
I am pretty much a hard copy guy too. But about a month ago I purchased a dual
output video card and a second monitor (LCD). Total price $270. Now I have the
docs on one screen while a work on the other. I like it much better than I
thought I would.
Bill
Hi,
I want to know the names of the system tables in sqlite. I only know of the
table sqlite_master.
Thanks in advance.
Bill
Hi,
I need help in generating a unique integer for the table's primary key. I am
more familiar with MS Access that has a data type called "Autonum" that
generates the integer. Do I need to find the last record to know what the next
number should be?
Thanks in advance,
Bill
Hi,
The product GoDB uses SqLite and works on a lot of PDA and phoes. And many of
these pdas are also mp3 players
Bill
Hi
That is what I thought. Who should I report the bug to?
Cheers,
Robin
Original Message:
-
From: [EMAIL PROTECTED]
Date: Mon, 22 May 2006 08:14:12 -0400
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Can't access sqlite_master from VB6 via ODBC
Robin Wilson &l
on this?
Cheers,
Robin
Original Message:
-----
From: John Newby [EMAIL PROTECTED]
Date: Mon, 22 May 2006 10:39:54 +0100
To: sqlite-users@sqlite.org, [EMAIL PROTECTED]
Subject: Re: [sqlite] Can't access sqlite_master from VB6 via ODBC
Hi Robin, have you looked here, there are
Hi
I thought it wasn't permissions. The VB interface I'm using is ActiveX Data
Objects, which works through ODBC and the SQLite ODBC driver. Might there
be some problem with this driver?
Robin
Original Message:
-
From: John Stanton [EMAIL PROTECTED]
Date: Mon, 22 May
Hi,
Does anyone have experience use SQLite on a Palm or Pocket-PC handheld?
I want the speed of an indexed database. I need faster data access than I get
from the Palm files on my Palm Tungsten T3. I can give more details, but the
main point is, as I sai, I nee help using SQLite on hanhels.
Bill
Thank you very much for your advice. i will try to do it
---Mensaje [EMAIL PROTECTED] wrote:
>Hi All,
>Does anybody know how to use sqlite3_prepare() with read only locking table?
>if i try to insert, delete or update on a table that is afected by
sqlite3_prepare sqlite returns an SQLI
Hi All,
Does anybody know how to use sqlite3_prepare() with read only locking table?
if i try to insert, delete or update on a table that is afected by
sqlite3_prepare sqlite returns an SQLITE_LOCKED error.
i can not call sqlite3_reset, becuase the modification sentence is inside the
sqlite3_pre
Hi Robert,
I have never used SQLite with sqlite3_prepare(),
sqlite3_step(), sqlite3_reset() and sqlite3_finalize().
Do you have any code example that i can use to avoid the use of
sqlite_get_table() ?
Thank you,
Eduardo
---Mensaje original---I don't use the sqlite_get_table() function, and don'
Hi Robert,
I was talking about 3 selects satements using the same connections.
Anyway, thank you very much for your advice of using "PRAGMA cache
size=8", that solved all the problems related to sqlite3_exec memory
problems with a select statement, baut the memory problems are not solved at
all
Hi,
Thank you very much for your help, i have modify the line, it compiles, it
doesn´t fire any exception, but memory is not freed at all (works the same way)
Anyone has another idea?, i tought that SQLite was working since a long time
ago on Windows CE devices, it seems quite strange that no on
Hi Robert,
I was talking about 3 selects satements using the same connections.
Anyway, thank you very much for your advice of using "PRAGMA cache
size=8", that solved all the problems related to sqlite3_exec memory
problems with a select statement, baut the memory problems are not solved at
all
Hi Robert,
I was talking about 3 selects satements using the same connections.
Anyway, thank you very much for your advice of using "PRAGMA cache
size=8", that solved all the problems related to sqlite3_exec memory
problems with a select statement, baut the memory problems are not solved at
all
not a great programmer too
and i reviwed the code buti do not see anything strange that might be
generating this problem, i hope someone with more experience could solve it?.
Thank you,
Eduardo
---Mensaje original---On March 16, 2006 08:49 am, [EMAIL PROTECTED] wrote:
> Hi Again Robert,
>
Hi Again Robert,
I have run your program on the CE emulator (Pocket PC 2003) and i got the same
memory leak.
I have inserted 2 buttons on a MFC dialog application.
The first button executes your code and the second button closes the
application.
If you examine the memory you will discover that t
Hi Robert,
Thank you for your test. I have not test it on the emulator but in 4 different
Windows CE devices i have at work (with different Windows CE OS versions) and
it always give me the same memory leak result.
I will run your test tomorrow at work using the emulator and i will let you
know
Hi again Robert,
I think i forgot to tell you that to detect the memory leak you must not close
the application testing program, the easiest way to detect the memory leak is:
create a simple MFC dialog project. Add 2 buttons, one for executing your
testing program an another one for close the ap
Hi Robert,
Thank you for your test. I have not test it on the emulator but in 4 different
Windows CE devices i have at work (with different Windows CE OS versions) and
it always give me the same memory leak result.
I will run your test tomorrow at work using the emulator and i will let you
know
1 - 100 of 168 matches
Mail list logo
