I see Microsoft is already offering a patch for Windows XP to handle the new
U.S. DST rules.
-Clark
- Original Message
From: Joe Wilson <[EMAIL PROTECTED]>
To: sqlite-users@sqlite.org
Sent: Saturday, December 23, 2006 9:52:02 AM
Subject: Re: [sqlite] calculate age
Holiday
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
[EMAIL PROTECTED] wrote:
| I was thinking the same thing earlier today.
| Perhaps sometime next week.
With the new prepare_v2 api, step returns the error directly. If I
ignore that and then call finalize, will finalize also return the same
Thanks. :-)
--- Jay Sprenkle <[EMAIL PROTECTED]> wrote:
> On 12/22/06, Artem Yankovskiy
> <[EMAIL PROTECTED]> wrote:
> > Thanks!
> > Can at whom is small sample on C/С ++?
>
>
> some example code here:
>
> SqliteImporter and SqliteReplicator: Command line
> utilities for Sqlite
>
--- Fred Williams <[EMAIL PROTECTED]> wrote:
> If it ain't broke, don't "fix" it?
A list of the fixes and enhancements since the last release:
http://www.sqlite.org/cvstrac/timeline?d=100=2006-Dec-23=2==0=1=1=1
The 3.3.8 shell .dump bug alone is serious enough to warrant a release, IMO.
> PRAGMA cache_size
> PRAGMA default_cache_size
Thanks, will experiment with those.
My bytes per row are small, but the number of rows to insert can be large,
up to a few million, although typically up to a few 100.000.
RBS
-Original Message-
From: Kees Nuyt [mailto:[EMAIL PROTECTED]
If it ain't broke, don't "fix" it?
> -Original Message-
> From: Joe Wilson [mailto:[EMAIL PROTECTED]
> Sent: Saturday, December 23, 2006 12:33 PM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] ETA for SQLite 3.3.9 ?
>
>
> it's been a while since 3.3.8.
>
>
Unfortunately our Congress seems to have a short memory, on top of
constantly appearing embarrassingly stupid and crooked as a snake. I
remember the last time they messed with DST. Seems little Yankee school
munchkins were being squashed by school buses in the resulting early
morning darkness.
tOn Sat, 23 Dec 2006 20:55:16 -, you wrote:
>Have come to the conclusion that the only thing that is
>really important in speeding up SQLite inserts is to wrap
>it in a transaction.
Yes, it is.
>Things like:
>PRAGMA synchronous = OFF;
>PRAGMA encoding='UTF-8';
>PRAGMA page_size=4096 or
At 03:41 22/12/2006, you wrote:
There has been discussion about extending Sqlite to have more
functions, but the risk is creating Sqlite-Bloat and losing the most
endearing feature of the product, its light weight and simplicity.
Here is an interesting and thought provoking discussion on the
Have come to the conclusion that the only thing that is really import in
speeding up SQLite inserts is to wrap it in a transaction. Things like:
PRAGMA synchronous = OFF;
PRAGMA encoding='UTF-8';
PRAGMA page_size=4096 or whatever number
Don't seem to make a difference.
Are there any other things
Found this site:
http://www.tannertech.net/sqlite3vb/index.htm#make_dll_vb_compat
which looks like a nice tutorial about making a VB compatible wrapper.
Had a go with the ready made dll and it all looks to be working nicely and
Perhaps slightly faster than the commercial wrapper from
I've been too busy with the holidays to run any of the changes. I won't be
able to do anything with the code until after the 1st.
Robert
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Saturday, December 23, 2006 12:40 PM
> To: sqlite-users@sqlite.org
>
Joe Wilson <[EMAIL PROTECTED]> wrote:
> it's been a while since 3.3.8.
>
I was thinking the same thing earlier today.
Perhaps sometime next week.
There have been a lot of changes lately that
impact win95 and wince. I sent out email asking
people to test those changes but have not gotten
back a
it's been a while since 3.3.8.
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
-
To unsubscribe, send email to
This mailing list thread may be helpful:
http://www.mail-archive.com/sqlite-users@sqlite.org/msg15902.html
--- PY <[EMAIL PROTECTED]> wrote:
> I am using a memory database in an embedded device with sqlite_3.3.5.
> For performance consideration, all the database access are running in the
> SDRAM.
Holiday determination per country (or even per state/city) via an algorithm
can only get you so far because it is at the whim of constantly changing
local laws. You basically need a database of all the dates for the exceptions.
Even getting a reliable source of such information for various
* w. wg:
> The following is from ibm developerworks site:
>
> Its creator conservatively estimates that it can handle a Web site
> with a load of up to 100,00 hits a day, and there have been cases
> where SQLite has handled a load 10 times that.
>
> origin link:
>
Hi All,
I am using a memory database in an embedded device with sqlite_3.3.5.
For performance consideration, all the database access are running in the
SDRAM.
I need to perform both CopyFileDBToMemDB and CopyMemDBToFileDB with high
performace and less memory used.
My current solution is create
On 12/22/06, Artem Yankovskiy <[EMAIL PROTECTED]> wrote:
Thanks!
Can at whom is small sample on C/С ++?
some example code here:
SqliteImporter and SqliteReplicator: Command line utilities for Sqlite
http://www.reddawn.net/~jsprenkl/Sqlite
On 12/23/06, Joe Wilson <[EMAIL PROTECTED]> wrote:
Warning - Thar Be Dragons Here!
The definition of a month is more or less arbitrary depending on the situation.
Trying to define what exactly is the duration of a "month" is a bottomless
pit of endless bickering best decided by druids, popes
On 12/21/06, E Tse <[EMAIL PROTECTED]> wrote:
Hi guys,
I ran into a strange problem. I have 2 prepared sqlite3_stmt, each inserting
to different tables in a sqlite database:
sqlite3_stmt* insertA;
std::string sql = "insert into tablea(col1) values(?)";
int rc = sqlite3_prepare(db_, sql.c_str(),
Warning - Thar Be Dragons Here!
The definition of a month is more or less arbitrary depending on the situation.
Trying to define what exactly is the duration of a "month" is a bottomless
pit of endless bickering best decided by druids, popes and historians -
certainly
beyond the scope of
The following is from ibm developerworks site:
Its creator conservatively estimates that it can handle a Web site
with a load of up to 100,00 hits a day, and there have been cases
where SQLite has handled a load 10 times that.
origin link:
AY> Can at whom is small sample on C/С ++?
It seems, there are quite good examples in the sqlite's documentation. Do you
have any problems with it?
--
Slava Tutushkin, http://aloner.ru
mailto:[EMAIL PROTECTED]
ICQ: 55463183
24 matches
Mail list logo