Looking at patch I do not understand, why we add
n += 4;
in case of 'y' ?
I would do:
case 'W':
+ case 'y':
n++;
...
+case 'y': {
+ sqlite3_snprintf(3,&z[j],"%02d",x.Y % 100); j+=2;
+ break;
+}
> See "2-digit year patch" here: http:/
>> > change this code:
>> > typedef struct NiuRoutingStruct {
>> > sqlite3_vtab vtab;
>> > } NiuRouting;
>> > to this:
>> > struct NiuRouting : public sqlite3_vtab vtab {
>> > ... // your implementation, eventually
>> > };
>> >
>> > This way, the casting is un
I was test about insert sqlite library to mfc project.
I used amalgamaion files of version 3.7.10.
It was fail with Visual C++ 2005. but success with Visual C++ 2010.
The error occured on 35393 line of sqlite3.c when It call the
sqlite3_open().
Why Visual C++ 2005 is different from 2010.
What I
See "2-digit year patch" here: http://sqlite.mobigroup.ru/wiki?name=patches
I did write this becouse 2-digit year number is needed very often for me.
Thanks Alexey,
As this patch is easy and adds only few lines of source code (but as I think
very useful),
can it be accepted (merged) into mai
On 02/06/2012 05:54 AM, Hamish Allan wrote:
On 5 February 2012 21:20, Roger Binns wrote:
SQLite doesn't work on rows - it works on pages. A row will be contained
within one or more pages.
FWIW, I inspected the source for OP_Concat and found that it can
sometimes avoid a memcpy (but presumab
Watching Windows 7 Resource Monitor (launched from a button on Windows Task
Manager) - I see that sqlite - directly - or through Windows - generates
quite a bit of activity on a temp file located on
C:\users\owner\AppData\Local\Temp - especially when running large joins,
etc. There are large read a
On 5 February 2012 21:20, Roger Binns wrote:
> SQLite doesn't work on rows - it works on pages. A row will be contained
> within one or more pages.
FWIW, I inspected the source for OP_Concat and found that it can
sometimes avoid a memcpy (but presumably not if there isn't enough
space in contig
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 05/02/12 12:09, Hamish Allan wrote:
> Sure, but a row can be re-written by copying each byte to memory and
> back out again,
SQLite doesn't work on rows - it works on pages. A row will be contained
within one or more pages.
> WRT premature optim
On 5 Feb 2012, at 8:08pm, Sherief Farouk wrote:
> On Feb 5, 2012, at 2:52 PM, Simon Slavin wrote:
>
>> Can you show us the CREATE statement for the table ?
>
> CREATE TABLE Tweets(TweetID INTEGER PRIMARY KEY, UserID INTEGER, Text TEXT)
> CREATE TABLE Users(UserID INTEGER PRIMARY KEY, UserName
On 5 February 2012 19:11, Roger Binns wrote:
> The values for a row are stored sequentially. Changing the size of a
> value will at least require rewriting the row.
Sure, but a row can be re-written by copying each byte to memory and
back out again, or by copying the whole row into memory and t
On Feb 5, 2012, at 2:52 PM, Simon Slavin wrote:
> Can you show us the CREATE statement for the table ?
CREATE TABLE Tweets(TweetID INTEGER PRIMARY KEY, UserID INTEGER, Text TEXT)
CREATE TABLE Users(UserID INTEGER PRIMARY KEY, UserName TEXT)
___
sqlite
On 5 Feb 2012, at 7:48pm, Sherief Farouk wrote:
> Just like the title says, a query on my database returns almost instantly as
> soon as I remove the ORDER BY primary key column clause
> SELECT TweetID, UserID, Text FROM Tweets WHERE UserID IN (SELECT UserID FROM
> Users) AND TweetID <= 1234
Just like the title says, a query on my database returns almost instantly as
soon as I remove the ORDER BY primary key column clause, but takes a
significantly longer time with the order by. Is there anything I can do about
it? Here are the two queries (with and without ORDER BY) and their SQLit
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 05/02/12 10:13, Hamish Allan wrote:
> 1) Is concatenation on UPDATE performed in-place?
The values for a row are stored sequentially. Changing the size of a
value will at least require rewriting the row.
I suggest reading the documentation on the
On 05.02.2012 19:18 Fabio Spadaro said the following:
2012/1/31 John Elrick
On Tue, Jan 31, 2012 at 6:01 AM, Fabio Spadaro
wrote:
Hi
2012/1/30 Bart Smissaert
How do you make it open database files that have an extension other
than
.slt?
RBS
Tonight I will see to create a new version
On 05.02.2012 19:18 Fabio Spadaro said the following:
2012/1/31 John Elrick
On Tue, Jan 31, 2012 at 6:01 AM, Fabio Spadaro
wrote:
Hi
2012/1/30 Bart Smissaert
How do you make it open database files that have an extension other
than
.slt?
RBS
Tonight I will see to create a new version
2012/1/31 John Elrick
> On Tue, Jan 31, 2012 at 6:01 AM, Fabio Spadaro >wrote:
>
> > Hi
> >
> > 2012/1/30 Bart Smissaert
> >
> > > How do you make it open database files that have an extension other
> than
> > > .slt?
> > >
> > > RBS
> >
> >
> > Tonight I will see to create a new version with b
1) Is concatenation on UPDATE performed in-place?
For example, with the following:
CREATE TABLE example (content TEXT);
INSERT INTO example(content) VALUES ('Hello, world!');
UPDATE example SET content = content || ' How are you?' WHERE rowid = 1;
Is the old value copied out to memory before bei
Re:
http://sqlite.org:8080/cgi-bin/mailman/private/sqlite-users/2012-January/036
538.html
download (modified sqlite3.c, posix wrapper, test app, IAR project ) from
http://dl.dropbox.com/u/49916007/SQlite.zip
___
sqlite-users mailing list
sqlit
19 matches
Mail list logo
