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
> 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
> 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
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
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
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,
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
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
>
> 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
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
> 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
> 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:
>
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: "Ge
,
'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
___
sqlite-users mailing list
sqlite-users
> 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
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
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
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
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
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: <sqlite-users@sqlite.org>
Betreff: Re: [sqlite] COUNT() on indexed tables / primary keywit
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: <sqlite-users@sqlite.org>
Betreff: Re: [sqlite] COUNT() on indexed tables / prima
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'
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
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
>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 with
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
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
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
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
>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
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
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
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?
C:\ sqlite
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 sqlite-3_5_5.zip
Message - From: <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
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 v
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 figured ou
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
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
ve.com/spacesapi.aspx?wx_action=create_url=/friends.aspx=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 "fiel
"[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 "one&quo
}
sqlite3_finalize(pStat);
sqlite3_close(db);
return 0;
}
Fred.
-----
To unsubscribe, send email to [EMAIL PROTECTED]
-
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]
-
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:
>
> >Isn't
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 port the sqli
-
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've
ou can open a new ticket and include the code and database
>> as an attachment.
>
> I'm grad to do that.
> --
> tamagawa ryuji
>
> ---
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
).
Regards,
Daniel
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
also tried 3.3.13 and failed)
WinCE 5.0
Regards
Daniel
-----
To unsubscribe, send email to [EMAIL PROTECTED]
-
uot; Jiang/
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
ger
-
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]
-
(directory extended properties).
-
To unsubscribe, send email to [EMAIL PROTECTED
; 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/
--
/
-
To 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
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 the end-o
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 <[EM
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 many wrappers for SQLite
http
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 2006 09:07
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
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
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
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 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
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
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
);
MessageBox(_T(NO2),_T(),MB_OK);
}
sqlite3_free(zErrMsg);
sqlite3_close(db);
}
Thank you in advance,
Eduardo Esteban
---Mensaje original---On March 14, 2006 01:49 pm, [EMAIL PROTECTED] wrote:
Hello again,
Thank for your answers:
first of all thank you who pointed that i should
---Mensaje original---You might look to recoding your application to not use
get_table, a
memory hog. Instead use step in a loop.
Jay Sprenkle wrote:
On 3/14/06, [EMAIL PROTECTED] wrote:
Hi all,
I am having real problems with SQLite on Windows CE (.NET 4.1 and
Pocket PC 2003).
ret
Hi all,
I am having real problems with SQLite on Windows CE (.NET 4.1 and Pocket PC
2003).
I have tried everything and it seems that there is a memory leak with SQLite on
Windows CE.
I have test it with SQLite versions 3.2.2 and 3.3.4 and SQLite seems that it
reserves memory and doesn´t free
atins only tlb1 whith 2 coloumns and 2 records.
Any
Suggestions ?
Messaggio originale
Da: [EMAIL PROTECTED]
Data:
26-gen-2006 5.57 PM
A: <sqlite-users@sqlite.org>
Ogg: Re: [sqlite] How
to compile sqlite3 C sample code
On Jan 26, 2006, at 11:03 AM,
[EMAIL PROTECTED] wrote:
Hello, I was thinking about a trick that I once used with an Oracle database.
To speed up a data transfer from one database to another, I put the redo log
files on a RAM disk. I was severely flamed for this unresponsible suggestion
but it made things quicker. Later I learned that there exists
I'm a novice and after compiled and correctly installed SQLite 3.x,
i've tried to compile sample C++ program found in Quickstart page.
I've
got Linker errors, like follows:
/home/etrax/tmp/cckIV5JC.o: In
function `main':
t.c:(.text+0xd6): undefined reference to
`sqlite3_open'
Hi !
I need to create a program in Delphi/Windows. I think that SQLite is
best for it.
But:
I need inmemory tables with "infile tables".
This app. is get many datas from another DB. But because these datas are
not fitted in memory, I need SQLite to put them into local file/local DB.
But I want
Hi !
I don't know about the language issue, someone else must answer that.
I have a solution for search. If I put another field aside every
char-based field, with manually UPPERED content, then I can search in
with SQL, not with my search functions. And I can create another plus
field with
0, schreef [EMAIL PROTECTED]:
Hi !
In the years of 2000 I wrote 3 programs.
These apps are placed in CD, but in this time I don't have good solution
for online databases.
Then I placed an Installer in CD, and this Setup prg. is install
InterBase 6.0 in the computer with my software.
That is
Hi !
In the years of 2000 I wrote 3 programs.
These apps are placed in CD, but in this time I don't have good solution
for online databases.
Then I placed an Installer in CD, and this Setup prg. is install
InterBase 6.0 in the computer with my software.
That is very wrong solution (I think it
1 - 100 of 144 matches
Mail list logo
