Hi all,
I'm new to the list, and I can't find any archive to look trough...
My questions was :
- what is the best way to store date-time values with sqlite3?
- to store boolean values?
I assume INTEGER is the solution, but I wanted to know if there was some
convention about that...
Thanks for
My memory manager reports that the SQL below results in memory being reused
after it has already been freed when it is RUN FOR A SECOND TIME on the same
database connection.
Psydocode (I do not run C):
sqlite3_initialize;
sqlite3_open(DB_FILE_NAME, DB);
sqlite3_exec(DB, SQL, NULL, NULL,
On Mon, 28 Sep 2009 19:07:05 -0700 (PDT), oryann9
orya...@yahoo.com wrote:
Is there a method, set of tools to gather and show
either graphically or non-graphically the performance
of SQLite3 databases?
I am trying to determine the current memory, disk IO
and cpu load all DB transactions place on
On Sep 27, 2009, at 5:28 PM, Dr. David Kirkby wrote:
sqlite3.c, line 18731: warning: integer overflow detected: op
sqlite3.c, line 18748: warning: integer overflow detected: op
Both cases are complaining about a constant: (0x1f28)Both are
harmless.
sqlite3.c, line 32546: warning:
/1970).
If you don't need to manipulate these fields in your SQL, then you can
choose any format you want. E.g. in my application I find it convenient
to store dates as integers like 20090929 (I don't need times).
- to store boolean values?
As integer 0 or 1.
Igor Tandetnik
On Sep 29, 2009, at 4:30 PM, Ralf Junker wrote:
My memory manager reports that the SQL below results in memory being
reused after it has already been freed when it is RUN FOR A SECOND
TIME on the same database connection.
Hi Ralf,
Thanks for this report. I'm unable to reproduce the
Hi Nicolas,
My application is windows based. I did set the pragma Page
Size = 4096 as suggested by Alexey. but, it hardy made any difference to
the speed. I am abandoning the multi-threading idea, as the other components
used in my application aren't thread safe.
Also, i was
) or a traditional Unix time (the number of seconds
since midnight 1/1/1970).
If you don't need to manipulate these fields in your SQL, then you can
choose any format you want. E.g. in my application I find it convenient
to store dates as integers like 20090929 (I don't need times).
/ - to store boolean
My program is using sqlite3_exec() to run SQL command which has the type of
char*. Now I want to allow unicode in my DB. What do I have to change?
Obviously, sqlite3_exec() won't work any more.
Phuoc
-
www.folksfun.com
--
View this message
On Tue, 29 Sep 2009 07:07:54 -0700 (PDT), bigboss97
bigboss97@yahoo.com wrote:
My program is using sqlite3_exec() to run SQL command which has the type of
char*. Now I want to allow unicode in my DB. What do I have to change?
Obviously, sqlite3_exec() won't work any more.
Phuoc
This page
Is there a method, set of tools to gather and show
either graphically or non-graphically the performance
of SQLite3 databases?
I am trying to determine the current memory, disk IO
and cpu load all DB transactions place on our server.
Set up a suite of benchmark queries and use the
On Sep 29, 2009, at 6:32 PM, Joe Bennett wrote:
Have two tables structured exactly the same. Want to compare both of
them and get the delta. Been Googling for about an hour now and I see
tools that do this (maybe a freeware one I haven't found?) and was
looking for a solution that more meets
Hi,
Have two tables structured exactly the same. Want to compare both of
them and get the delta. Been Googling for about an hour now and I see
tools that do this (maybe a freeware one I haven't found?) and was
looking for a solution that more meets the budget I was given for this
project,
What is the delta?
RBS
Hi,
Have two tables structured exactly the same. Want to compare both of
them and get the delta. Been Googling for about an hour now and I see
tools that do this (maybe a freeware one I haven't found?) and was
looking for a solution that more meets the budget I was
[quoting fixed]
On Tue, 29 Sep 2009 09:11:52 -0700 (PDT), oryann9
orya...@yahoo.com wrote:
Kees Nuyt wrote:
oryann9 orya...@yahoo.com wrote:
Is there a method, set of tools to gather and show
either graphically or non-graphically the performance
of SQLite3 databases?
I am trying to determine
Figuratively I'm looking to take a row in table A, find it in table B
and compare the values in each column... If there is a delta, let me
know What I am trying to do is take an old table and compare it to
the new one and show the changes...
-Joe
On Tue, Sep 29, 2009 at 12:37 PM,
Good day,
Are you looking to simply identify records that are different (not missing
from the tables) or identify records with ANY field different and get the
result?
Is there a primary key? Posting the structure would be helpful. This should
not be hard.
C:\Documents and
On 29 Sep 2009, at 5:11pm, oryann9 wrote:
I did do this, set-up a cron job using vmstat, free and top.
Great tools. Don't forget that 'top' is a way into the information
'ps' shows. You might find that 'ps' shows you more useful
information. Or you might not.
I do not know how to
On Tue, Sep 29, 2009 at 9:38 AM, Petite Abeille
petite.abei...@gmail.com wrote:
On Sep 29, 2009, at 6:32 PM, Joe Bennett wrote:
Have two tables structured exactly the same. Want to compare both of
them and get the delta. Been Googling for about an hour now and I see
tools that do this (maybe
Hi Folks,
I need to know what columns of my virtual table implementation are used for a
particular query or not. The computation of the columns is expensive and cannot
be deferred until the call to xColumn(). Thus I need to know before the first
row is fetched so that I can be efficient in my
That's a good start. Don't forget iostat. On top of that,
Simon Slavin already told you how to measure time taken in
SQLite with the .timer ON command.
I can't find the .timer feature in the SQLite command line utility.
SQLite version 3.6.18
Enter .help for instructions
Enter SQL statements
Huh. Do a .help in that version. Should be there. See
http://www.sqlite.org/sqlite.html
Simon.
I tried it in 3.6.10 and went, huh as well. So I upgraded to the
latest (3.6.18) and still no .timer command.
RW
Ron Wilson, Engineering Project Lead
(o) 434.455.6453, (m) 434.851.1612,
At 14:04 29.09.2009, Dan Kennedy wrote:
On Sep 29, 2009, at 4:30 PM, Ralf Junker wrote:
My memory manager reports that the SQL below results in memory being
reused after it has already been freed when it is RUN FOR A SECOND
TIME on the same database connection.
Hi Ralf,
Thanks for this
At 14:04 29.09.2009, Dan Kennedy wrote:
On Sep 29, 2009, at 4:30 PM, Ralf Junker wrote:
My memory manager reports that the SQL below results in memory being
reused after it has already been freed when it is RUN FOR A SECOND
TIME on the same database connection.
Hi Ralf,
Thanks for this
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Nicolas Williams wrote:
If you move the cast to the left the warning should go away:
((sqlite3_int64)(1L63))
And this is why making warnings go away leads to bugs. The replacement
above will only work if sizeof(long)==sizeof(long long) which is
On Sep 30, 2009, at 1:09 AM, Ralf Junker wrote:
At 14:04 29.09.2009, Dan Kennedy wrote:
On Sep 29, 2009, at 4:30 PM, Ralf Junker wrote:
My memory manager reports that the SQL below results in memory being
reused after it has already been freed when it is RUN FOR A SECOND
TIME on the same
On Sep 29, 2009, at 6:50 PM, Cory Nelson wrote:
i believe he means except, not minus.
Correct. Got my SQL dialects intermingled :)
If all you need is differing
rows, this will work like a charm. Otherwise if you need a more
fine-grained delta like only returning columns that changed, you
On Sep 29, 2009, at 7:19 PM, Wilson, Ronald wrote:
I can't find the .timer feature in the SQLite command line utility.
sqlite .timer on
sqlite select 1;
1
CPU Time: user 0.000295 sys 0.000269
sqlite
___
sqlite-users mailing list
I believe one must enable the .TIMER option when compiling sqlite3. I
think the pre-compiled versions have this disabled by default (at least
for the Windows binaries).
Donald
___
sqlite-users mailing list
sqlite-users@sqlite.org
On Sep 29, 2009, at 2:21 PM, Roger Binns wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Nicolas Williams wrote:
If you move the cast to the left the warning should go away:
((sqlite3_int64)(1L63))
And this is why making warnings go away leads to bugs. The
replacement
above
On Sep 30, 2009, at 1:41 AM, Griggs, Donald wrote:
I believe one must enable the .TIMER option when compiling
sqlite3. I
think the pre-compiled versions have this disabled by default (at
least
for the Windows binaries).
The .timer command is only available on unix and unix-like
sqlite .timer on
sqlite select 1;
1
CPU Time: user 0.000295 sys 0.000269
sqlite
What version are you using?
RW
Ron Wilson, Engineering Project Lead
(o) 434.455.6453, (m) 434.851.1612, www.harris.com
HARRIS CORPORATION | RF Communications Division
assuredcommunications(tm)
On Tue, Sep 29, 2009 at 11:21:30AM -0700, Roger Binns wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Nicolas Williams wrote:
If you move the cast to the left the warning should go away:
((sqlite3_int64)(1L63))
And this is why making warnings go away leads to bugs. The
The .timer command is only available on unix and unix-like platforms
at present. Not on win32.
D'Oh!
Ron Wilson, Engineering Project Lead
(o) 434.455.6453, (m) 434.851.1612, www.harris.com
HARRIS CORPORATION | RF Communications Division
assuredcommunications(tm)
On Tue, Sep 29, 2009 at 12:05:21PM -0700, Jim Showalter wrote:
Warnings are never harmless--they clutter the build output and
introduce cognitive dissonance when trying to see if a build is clean
or not.
I worked on a project where they hadn't enabled warnings during
development because
Hi,
I would like to highlight the following SQLite benchmark results posted
by Phoronix via Phoronix Test Suite (http://www.phoronix-test-suite.com/)
In particular
http://www.phoronix.com/scan.php?page=articleitem=linux_2631_kvmnum=3
On 29 Sep 2009, at 8:22pm, Wilson, Ronald wrote:
The .timer command is only available on unix and unix-like platforms
at present. Not on win32.
D'Oh!
Ah. Okay, I have it because I'm using a Mac. The OP must be running
Windows.
Simon.
___
On 29 Sep 2009, at 8:57pm, Matthew Tippett wrote:
In particular
http://www.phoronix.com/scan.php?page=articleitem=linux_2631_kvmnum=3
http://www.phoronix.com/scan.php?page=articleitem=freebsd8_ubuntu910num=7
In both of these cases, there are configurations where there is an
order
of
I cannot find any sign of BEGIN;COMMIT; .
And as a result of that, Matthew, you're right, on OS (or OS + file
system) where fsync() doesn't do physical write test getting huge
boost in performance.
Just take the second test: 12,500 transactions in 771.13 seconds
giving about 16 transactions per
If there is anyone who is interested in assisting in improving the
quality/value/functional interest of the benchmarks, then please
advise.
PTS can handle direct numerical, average or gemetric means at
individual test case or aggregate test suites.
Regards... Matthew
On 9/29/09, Simon Slavin
At the bottom of mutex.h there is an:
#ifdef SQLITE_MUTEX_OMIT
...
#endif /* defined(SQLITE_OMIT_MUTEX)
Either the comments or the define should be changed. This occurs in mutex.c as
well.
The pattern for all other OMIT definitions is SQLITE_OMIT_% so it would be
nice if this one could be
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Nicolas Williams wrote:
On Tue, Sep 29, 2009 at 11:21:30AM -0700, Roger Binns wrote:
Nicolas Williams wrote:
If you move the cast to the left the warning should go away:
((sqlite3_int64)(1L63))
And this is why making warnings go away leads to
On 29 Sep 2009, at 10:29pm, Matthew Tippett wrote:
If there is anyone who is interested in assisting in improving the
quality/value/functional interest of the benchmarks, then please
advise.
In SQLite, when you know you are making many changes and don't need to
consult the data until
Hello-
Im trying to figure out why I cannot get spanish characters
into my sqlite DB properly. Im using a C program to read
a text file that is already translated into spanish. When I
look at this file the spanish characters (tilde n, acentos etc)
are correct. When I run the C program and open
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Matthew Tippett wrote:
I would like to highlight the following SQLite benchmark results posted
by Phoronix via Phoronix Test Suite (http://www.phoronix-test-suite.com/)
An earlier test showed massive differences for Linux filesystems but those
Relabling to provide focus on this thread the KVM/FreeBSD specific
issues - I'll deal with that the main thread.
So, if I could put forward to you a few suggestions.
1) Review the existing tests (which you have done somewhat already)
2) Define a clear and relevant intent for benchmarking
Sam Carleton wrote:
Is it possible to have two different prepare statements at one time
Yes. As many as you need.
Igor Tandetnik
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Bible Trivia Extreme wrote:
Im trying to figure out why I cannot get spanish characters
into my sqlite DB properly.
Start here:
http://www.joelonsoftware.com/articles/Unicode.html
Igor Tandetnik
___
sqlite-users mailing list
On Tue, Sep 29, 2009 at 9:48 PM, Simon Slavin
slav...@hearsay.demon.co.ukwrote:
On 30 Sep 2009, at 2:25am, Bible Trivia Extreme wrote:
Is there something special I need to do in the C/Sqlite
code to make this work properly?
Which SQLite function calls are you using to run your INSERT
Bible Trivia Extreme wrote:
On Tue, Sep 29, 2009 at 9:48 PM, Simon Slavin
slav...@hearsay.demon.co.ukwrote:
On 30 Sep 2009, at 2:25am, Bible Trivia Extreme wrote:
Is there something special I need to do in the C/Sqlite
code to make this work properly?
Which SQLite
Open your spanish.txt file in a hex editor. The letter 'ñ' should be
encoded as C3 B1. If you see F1 instead, it means your file is in
ISO-8859-1 or something similar.
___
Thanks Dan, it seems to be F1. So what do I do exactly?
Im assuming I
On Sep 30, 2009, at 5:29 AM, Schrum, Allan wrote:
At the bottom of mutex.h there is an:
#ifdef SQLITE_MUTEX_OMIT
...
#endif /* defined(SQLITE_OMIT_MUTEX)
Either the comments or the define should be changed. This occurs in
mutex.c as well.
The pattern for all other OMIT definitions is
Bible Trivia Extreme wrote:
Open your spanish.txt file in a hex editor. The letter 'ñ' should be
encoded as C3 B1. If you see F1 instead, it means your file is in
ISO-8859-1 or something similar.Thanks Dan, it seems to be F1. So what do I
do exactly?
Im assuming I need to fix the
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Bible Trivia Extreme wrote:
(loop over spanish .txt file here while inserting)
sprintf(query, INSERT INTO questions VALUES('%s', '%s'), question,
answer);
That is a *really* bad way of doing things, both from a performance point of
view and
54 matches
Mail list logo