Testing only finds bugs, it does not guarantee accuracy. Careful design
however can establish accuracy, and to verify that methodology requires
examination of the source code.
James Steward wrote:
steveweick wrote:
Do you need to read the code to verify reliability as your next few
Hello,
is it possible (how?) to insert into 2 different fields (date) the following
values:
09:30:00(only a time value...)
14/07/07 (only year value, 14th of december 2007)
sorry, I am not be able at all to do that. Many thanks in advance for
helping,
Giuliano
steveweick wrote:
Do you need to read the code to verify reliability as your next few
sentences seems to imply? For that to be true, the reader would have to be
able to spot bugs through inspection. While that is certainly one way to
spot bugs, I seriously doubt that any shop would rely on code
I unfortunately missed the Encirq webinar thanks to a project commitment
but have taken the time to download the Encirq demo and try to make good
the loss. It has some user examples in source code which give an idea
of how it functions, but the information on the product is sparse so it
was
Joe Wilson <[EMAIL PROTECTED]> wrote:
> The reason why I asked is that I haven't had much luck with sqlite3
> performance for databases larger than the size of RAM on my machine
> regardless of PRAGMA settings.
>
This is probably do to the cache locality problem. We know how
to fix this, Joe.
My question first is can this fix be rolled into a group of related
fixes thus creating a service patch? If not then my opinion is 3.5.4.
If you can roll it in with 3 - 10 easy fixes call it 3.6.0.
Just an opinion though. I am waiting for 4.0, like it is Xmas Eve...
On Dec 13, 2007, at
Good idea... I'll pass it along to the right folks. Meanwhile, if anyone has
further questions or comments, please feel free to write me here (if they
think the group would be interested) or at [EMAIL PROTECTED]
Steve
I would like to recommend that Encriq create a forum or mailing list of
Trey Mack wrote:
3.6.0 in the next release? Or can we call the change
a "bug fix" and number the next release 3.5.4?
I guess I'm in the minority, but I'd find a change in the meaning of
my queries surprising in a bug fix release. That sounds like a 3.6
to me.
You may be in the
3.6.0 in the next release? Or can we call the change
a "bug fix" and number the next release 3.5.4?
I guess I'm in the minority, but I'd find a change in the meaning of
my queries surprising in a bug fix release. That sounds like a 3.6 to
me.
You may be in the minority, but you're not
I concur. Quite an interesting marketing strategy; Join you competitors'
mailing lists and trash talk them. LOL
-Original Message-
From: dcharno [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 13, 2007 8:30 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] DeviceSQL
I would like
Tom Parke <[EMAIL PROTECTED]> wrote:
By a "regular update statement", I assume you mean a SQL update tab
set
col = value, but I don't understand how to apply a SQL update
statement
to a ROWID.
update tableName set col = value where ROWID = ?;
How can I get the ROWID in the call back?
"Tom Parke" <[EMAIL PROTECTED]> wrote:
> Using sqlite3_prepare and then sqlite3_step() ing through the records,
> is there a way to update or replace the current record in a table while
> sqlite3_step() is on that record without a reselecting that record and
> sqlite3_exec() update table where?
By a "regular update statement", I assume you mean a SQL update tab set
col = value, but I don't understand how to apply a SQL update statement
to a ROWID. How can I get the ROWID in the call back?
Can you point me to some sample code that could help me understand?
Tom
-Original
I would like to recommend that Encriq create a forum or mailing list of
their own for those who are interesting in learning more. For me, what
might be an interesting product is quickly being overshadowed by this
thread.
You raise some interesting points. There is nothing secret about
On Mon, 10 Dec 2007 16:35:48 +0100, Kees Nuyt <[EMAIL PROTECTED]> wrote:
>So I activated php_pdo_sqlite_external instead and copied
>sqlite3.dll v3.5.3 to %serverroot%/bin .
Thanks for the infos.
So the options are:
1. use the old SQLite2 sqlite_() functions (or some class that turns this
Hi James,
You raise some interesting points. There is nothing secret about the
benchmarks. We will make the code that was used to run benchmarks available
to anyone who wants to see it and verify results. If you want to find a
third party to verify, be my guest. The benchmark report goes into
Kalyani Phadke
wrote:
Yes , It worked.
Could you pls tell me whats the difference between adLongVarWChar and
adLongVarChar? Does SQLite support Unicode encoding(UTF-8)?
SQLite does support UTF-8. But I suspect ADO actually converts the data
to Windows current code page when adLongVarChar is
Tom Parke <[EMAIL PROTECTED]> wrote:
Using sqlite3_prepare and then sqlite3_step() ing through the records,
is there a way to update or replace the current record in a table
while sqlite3_step() is on that record without a reselecting that
record and sqlite3_exec() update table where? Something
steveweick wrote:
Richard has it right this time. Today DeviceSQL uses no SQLite code. One of
the things we might consider is bolting the SQLite parser/front end to our
table engine, in theory to get the both worlds. Just an idea at the moment.
Such an interesting discussion to be
On Dec 14, 2007 12:35 AM, Steven Fisher <[EMAIL PROTECTED]> wrote:
> On 13-Dec-2007, at 8:40 AM, [EMAIL PROTECTED] wrote:
>
> > My question to the community is this: Are these
> > differences sufficient to justify going with version
> > 3.6.0 in the next release? Or can we call the change
> > a
At 7:59 AM -0500 12/13/07, Tom Briggs wrote:
> Something I will say about this, for people who don't know, is that
this columnar thing is strictly an implementation detail. While
I think that this is an oversimplification. That's somewhat like
saying that the way you use a sledge
Yes , It worked.
Could you pls tell me whats the difference between adLongVarWChar and
adLongVarChar? Does SQLite support Unicode encoding(UTF-8)?
-Original Message-
From: Igor Tandetnik [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 13, 2007 4:13 PM
To: SQLite
Subject: [sqlite]
On 14/12/2007, at 3:40 AM, [EMAIL PROTECTED] wrote:
Ticket number #2822
http://www.sqlite.org/cvstrac/tktview?tn=2822
(2) If an ORDER BY term is a simple identifer
(like "x", not "x.y" and not "x.y.z") and if
there if the k-th column uses that same identifer
as an AS
Using sqlite3_prepare and then sqlite3_step() ing through the records,
is there a way to update or replace the current record in a table while
sqlite3_step() is on that record without a reselecting that record and
sqlite3_exec() update table where? Something like a dynamic cursor in
MS SQL?
Kalyani Phadke
wrote:
The following query inserts into the database
Cmd1 .Parameters.Append(Cmd1 .CreateParameter("ipaddress",
adLongVarChar, adParamInput, 50, ipaddress))
Try adLongVarWChar for parameter type.
Igor Tandetnik
Table
CREATE TABLE [Test2]
(
[ipaddress] INTEGER,
[Name] text
)
The following query works fine
Set Cmd1 = Server.CreateObject("ADODB.Command")
Cmd1 .ActiveConnection = AuditLogConnection
Cmd1 .CommandText = "INSERT INTO Test2(ipaddress, name) VALUES ('192.168.1.1' ,
Richard has it right this time. Today DeviceSQL uses no SQLite code. One of
the things we might consider is bolting the SQLite parser/front end to our
table engine, in theory to get the both worlds. Just an idea at the moment.
Steve
D. Richard Hipp wrote:
>
> Joe Wilson <[EMAIL PROTECTED]>
As shown another thread, Richard has his facts wrong. See
http://www.nabble.com/Improving-performance-of-SQLite.-Anyone-heard-of-DeviceSQL--to14280006.html#a14317195
Steve
A. Pagaltzis wrote:
>
> * John Stanton <[EMAIL PROTECTED]> [2007-12-12 17:55]:
>> In general claims of "20x" or even "5x"
I hope this is not a double post, but this was answered in another thread.
See
http://www.nabble.com/Improving-performance-of-SQLite.-Anyone-heard-of-DeviceSQL--to14280006.html#a14317195
D. Richard Hipp wrote:
>
> John Stanton <[EMAIL PROTECTED]> wrote:
>> I received an email promoting a
The type DATE is a declared type, not an actual type and has no effect u
nless your code specifically picks it out as a declared type.
To do what you want use a trigger on insert and update the date field
with datetime('now');
Joanne Pham wrote:
Hi All,
I create the table as :
create
Hi All,
I create the table as :
create table test (name varchar(30), createDate DATE default
DATETIME('NOW'));
but I got the error message. I want to have the default as now if it is not
specify.
Thanks in advance,
Joanne
oops, fingers are moving faster than the brain :-) of course, you are right,
Dennis.
Steve
Dennis Cote wrote:
>
> steveweick wrote:
>> the tests were done
>> using Windows XP SP2 and Linux FC5 on a 3GHz P4 with 1MB
>>
>
> That must be very slow. ;-)
>
> I'm sure you meant 1GB for windows
Ah, I just figured out why I thought I've not got the tests. I've been
using the pre-processed C code version of SQLite (as I'm working in
Visual Studio on Windows), I guess I'll need to get the full SQLite
package building with make then to get the test functionality instead of
using the
Dennis Cote <[EMAIL PROTECTED]> wrote:
>
> Richard,
>
> How was the current default page size of 1K determined? Was there any
> testing to see if larger page sizes would be beneficial for general use?
> Or is it just a historical circumstance (i.e. an arbitrarily chosen
> value that has been
>From what I think I have learned so far, if I call sqlite3_exec() giving
it a call back function and a select * from tbl, I do not have any
direct access to the column values other that the text representation in
the values char array from within the callback()?
This leads me to the question,
[Has also been posted to the pysqlite-users mailing list]
I have a sqlite database in a readonly file.
Is it possible to create a :memory: database and quickly initialize it
from the file?
Thanks,
Thomas
-
To
steveweick wrote:
the tests were done
using Windows XP SP2 and Linux FC5 on a 3GHz P4 with 1MB
That must be very slow. ;-)
I'm sure you meant 1GB for windows XP.
Dennis Cote
-
To unsubscribe, send email to [EMAIL
[EMAIL PROTECTED] wrote:
Whenever you start a new transaction, SQLite has to
allocate and clear a bitmap used to record which
pages have changes in the database file. The size
of this bitmap is proportional to the size of the
database file. The size of the bitmap is 256 bytes
per megabyte of
Samuel R. Neff wrote:
That also brings up the simple solution in that if you know you're db is
going to be in the 200GiB range, declare a larger page size before creating
the DB.
My thoughts exactly.
Dennis Cote
[EMAIL PROTECTED] wrote:
T <[EMAIL PROTECTED]> wrote:
select cast( 141.70 * 100 as integer)
gives the incorrect 14169
14169 is the correct answer, believe it or not. There is
no such thing as the number 141.70 in a 64-bit IEEE float.
The closest you can get is
[EMAIL PROTECTED] wrote:
The current algorithm goes like this:
(1) If an ORDER BY term is a constant integer k
then sort by the k-th column of the result set.
(2) If an ORDER BY term is a simple identifer
(like "x", not "x.y" and not "x.y.z") and if
there if
3.5.4
---
We're Hiring! Seeking a passionate developer to join our team building Flex
based products. Position is in the Washington D.C. metro area. If interested
contact [EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL
Seems like a 3.5.4 to me
Mike
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
That also brings up the simple solution in that if you know you're db is
going to be in the 200GiB range, declare a larger page size before creating
the DB.
Sam
---
We're Hiring! Seeking a passionate developer to join our team building Flex
based
"Brown, Daniel" <[EMAIL PROTECTED]> wrote:
> Morning List,
>
> I've just started experimenting with SQLite to see if I can replace our
> current custom embedded database solution with it and trying to port
> SQLite to some of our embedded platforms. Are there are any testing
> frameworks (unit
The reason why I asked is that I haven't had much luck with sqlite3
performance for databases larger than the size of RAM on my machine
regardless of PRAGMA settings.
Maybe querying speed is fine for multi gigabyte database files, but
INSERT speed into tables with multiple indexes is slow when
Morning List,
I've just started experimenting with SQLite to see if I can replace our
current custom embedded database solution with it and trying to port
SQLite to some of our embedded platforms. Are there are any testing
frameworks (unit tests would be great) for SQLite? I'd like to be able
to
Joe Wilson <[EMAIL PROTECTED]> wrote:
> --- Tom Briggs <[EMAIL PROTECTED]> wrote:
> >For clarity, my definition of small is about 200GB, so I'm not
> > selling SQLite short here...
>
> Are you able to get decent performance out of sqlite3 for a 200GB database?
>
> How much RAM do you have
Heh, no, I've never tried, but I don't see much reason why I
couldn't. I was just trying to make the point that labeling SQLite as
"good ... for smaller databases" was not a slight.
-T
> -Original Message-
> From: Joe Wilson [mailto:[EMAIL PROTECTED]
> Sent: Thursday, December
Hi Everyone,
We are seeing the following strange behaviour with SQLite.
Our environment is as follows
1. SQLite 3.5.3
2. Using MEMORY DB
3. Many databases
4. Sun Solaris machine T2000 (32 cores and 16G memory)
5. A single DB table with only 2 entries (so size is not an issue here!)
6. A
If you suspect "Group By" also may be broken, why not to an interim "bug
fix" release and then do the version number change when both "Order By"
and "Group By" are fixed? I seem to remember instances where both Order
BY and Group By have given me "unexpected" results. But then again, my
logical
I'd vote 3.5.4 as well.
[EMAIL PROTECTED] wrote:
Ticket number #2822
http://www.sqlite.org/cvstrac/tktview?tn=2822
has provoked extensive changes to the way SQLite handles
ORDER BY clauses. The current algorithm goes like this:
(1) If an ORDER BY term is a constant integer k
--- Tom Briggs <[EMAIL PROTECTED]> wrote:
>For clarity, my definition of small is about 200GB, so I'm not
> selling SQLite short here...
Are you able to get decent performance out of sqlite3 for a 200GB database?
How much RAM do you have on such a machine?
[EMAIL PROTECTED] wrote:
Ion Silvestru <[EMAIL PROTECTED]> wrote:
SW: Richard, We have written to you directly before to ask you to stop the
FUD and incorrect statements, and you have chosen to continue. I suggest you
not waste everyone's time by circulating deliberately misleading
T <[EMAIL PROTECTED]> wrote:
>
> >> select cast( 141.70 * 100 as integer)
>
> gives the incorrect 14169
14169 is the correct answer, believe it or not. There is
no such thing as the number 141.70 in a 64-bit IEEE float.
The closest you can get is
T wrote:
I shouldn't have complicated my question by using the word "round".
It's not the rounding that I'm trying to do. The input values are
already rounded to two decimal places (cents of the dollar).
Realize that floating point numbers are stored by computers in binary,
not in decimal.
My vote is for 3.5.4.
-Jeff
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
Thanks, that makes sense.
Tom
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 13, 2007 7:50 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] How to get number of records in record set
"Tom Parke" <[EMAIL PROTECTED]> wrote:
> If I
Ticket number #2822
http://www.sqlite.org/cvstrac/tktview?tn=2822
has provoked extensive changes to the way SQLite handles
ORDER BY clauses. The current algorithm goes like this:
(1) If an ORDER BY term is a constant integer k
then sort by the k-th column of the result set.
Hi Sam,
re your points below:
1. I think I said "innovative", not "revolutionary". The scheme involves
using "dirty bits" rather than a log to record the transactional state of a
page.
2. We plan on publishing all the details of the benchmarks in a few days.
But to answer your question about
Hi Mike,
well, first of all you must have a typo, since the sql you show will
return 14170, not 0.69 or anything like it.
Yes, typo, sorry. The short version returns 14169 but should give
14170, as per my correction a minute ago.
however, one thing springs out:
Total * 100 + 100 is
oops, sorry, slight correction:
When I try:
select cast( 141.70 * 100 as integer)
I get 14169, but should get 14170
Tom
-
To unsubscribe, send email to [EMAIL PROTECTED]
Thank you, it now works.
2007/12/13, Dennis Cote <[EMAIL PROTECTED]>:
>
> CAVALO SCHMIDT wrote:
> > In the following simple C code (in Console program):
> >
> > sqlite3 *db;
> > int ret = sqlite3_open("dict.db", );
> > sqlite3_stmt *stmt;
> > char sql[256];
> > sprintf(sql,
"Tom Parke" <[EMAIL PROTECTED]> wrote:
> If I prepare() a sql stmt SELECT * FROM tbl WHERE col = n:
>
> How do I find out how many records were selected before calling step()?
>
The technically correct response to your question is that the
answer is always zero. Nothing gets selected - the
Cariotoglou Mike wrote:
Total * 100 + 100 is wrong IMHO, unless you are looking for CEILING
functionallity.
"round" would need : total * 100 +50 (which rounds to nearest integer at
two decimal points, not to the nearest LARGER integer,
which is what your sample does)
Shouldn't that be
If I prepare() a sql stmt SELECT * FROM tbl WHERE col = n:
How do I find out how many records were selected before calling step()?
Tom
CAVALO SCHMIDT wrote:
In the following simple C code (in Console program):
sqlite3 *db;
int ret = sqlite3_open("dict.db", );
sqlite3_stmt *stmt;
char sql[256];
sprintf(sql, "%s", "select * from a where a = 'key1'");
int rc = sqlite3_prepare(db, sql, 0, , 0);
Ion Silvestru <[EMAIL PROTECTED]> wrote:
> >We wrote Richard back in August to correct his misstatements then. He chose
> >to ignore the letter.
>
> August? We start to discuss about DeviceSQL some days ago, or
> I am wrong?
>
I have several support customer in Europe who have been
visited by
well, first of all you must have a typo, since the sql you show will
return 14170, not 0.69 or anything like it.
however, one thing springs out:
Total * 100 + 100 is wrong IMHO, unless you are looking for CEILING
functionallity.
"round" would need : total * 100 +50 (which rounds to nearest
T wrote:
When I try:
select cast( 141.70 * 100 as integer)
I get 0.69, but should get 0.70
Assuming you mean you got 14169, maybe you should look at
http://sqlite.org/faq.html#q16
HTH,
Gerry
-
To unsubscribe,
>We wrote Richard back in August to correct his misstatements then. He chose
>to ignore the letter.
August? We start to discuss about DeviceSQL some days ago, or
I am wrong?
-
To unsubscribe, send email to [EMAIL
When I try:
select cast( 141.70 * 100 as integer)
I get 0.69, but should get 0.70
What's the problem? Seems like a bug.
I tried some other numbers in place of 141.70, and they worked OK,
though I imagine there are others that have the bug that I just
haven't tried.
The above is the
Steve,
I found the information you posted to be a good contrast and would love to
learn more, but you didn't include any technical details. You said you have
atomic commits without a rollback journal and instead use some revolutionary
new way of doing commits. You said DeviceSQL performs
steveweick <[EMAIL PROTECTED]> wrote:
> D. Richard Hipp wrote:
> >
> > Unfortunately, Steve Weick might not see your comment
> > since he appears to have unsubscribed from the mailing list
> > immediately after sending his inflammatory missive.
> >
Hmmm... Further digging prompted by the
oops, I guess I need to get used to this message list protocol.
First let me apologize for letting Richard get me mad. Most of my friends
would describe me as one of the most laid back people they know. Why am I
mad you ask?
We wrote Richard back in August to correct his misstatements then. He
D. Richard Hipp wrote:
>
> Ion Silvestru <[EMAIL PROTECTED]> wrote:
>> >SW: Richard, We have written to you directly before to ask you to stop
>> the
>> >FUD and incorrect statements, and you have chosen to continue. I suggest
>> you
>> >not waste everyone's time by circulating deliberately
Ion Silvestru <[EMAIL PROTECTED]> wrote:
> >SW: Richard, We have written to you directly before to ask you to stop the
> >FUD and incorrect statements, and you have chosen to continue. I suggest you
> >not waste everyone's time by circulating deliberately misleading
> >information.
>
> I think
Based on my experience with SQLite, it would be a huge undertaking to
re-work it to use column-oriented storage. And I don't think it would
really fit with SQLite's goal, either; column oriented databases are
best suited to aggregate queries against large amounts of data, while
SQLite is best
> Something I will say about this, for people who don't know, is that
> this columnar thing is strictly an implementation detail. While
I think that this is an oversimplification. That's somewhat like
saying that the way you use a sledge hammer is no different than how you
use a claw
Salutations,
In the following simple C code (in Console program):
sqlite3 *db;
int ret = sqlite3_open("dict.db", );
sqlite3_stmt *stmt;
char sql[256];
sprintf(sql, "%s", "select * from a where a = 'key1'");
int rc = sqlite3_prepare(db, sql, 0, , 0);
Hi!
SQL Maestro Group announces the release of SQLite Maestro 7.12, a powerful
Windows GUI solution for SQLite administration and database development.
http://www.sqlmaestro.com/products/sqlite/maestro/
Please note that before December 31 you can purchase SQLite Maestro and our
other
I think Joanne's example may be simplified, and the question was
really more general...
On 12/12/07, Joanne Pham <[EMAIL PROTECTED]> wrote:
> Basiclly there is no SQL logic in SQLite.
Right, there's nothing like T-SQL. Even in other databases, most
procedural logic along IF..THEN lines is done
Hi Joanne,
On Wed, 12 Dec 2007 16:20:17 -0800 (PST), Joanne Pham
<[EMAIL PROTECTED]> wrote:
>Hi Igor,
>Thanks for the response.
>Basiclly there is no SQL logic in SQLite.
I'm not sure what you mean here.
>I would like to check if the database version is xyz
>then I will have different action
83 matches
Mail list logo