On Wed, Aug 6, 2014 at 2:57 AM, Richard Hipp d...@sqlite.org wrote:
Please review the change log and speak up if you see anything amiss.
The new doc mentioned by http://www.sqlite.org/draft/lang_expr.html#hexint
may have a 1-char typo:
However, for backwards compatibility, the Ox
src/func.c: The comment on top refers to sqliteRegisterBuildinFunctions()
but the actual call seems to have been renamed to
sqliteRegisterGlobalFunctions()
___
sqlite-users mailing list
sqlite-users@sqlite.org
Richard Hipp wrote...
Version 3.8.6 was originally scheduled for September. But the change log
(
http://www.sqlite.org/draft/releaselog/current.html) is getting rather
long
and there are a number of important bug fixes. So we might try to get
3.8.6 out the door sooner rather than
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
boun...@sqlite.org] On Behalf Of Richard Hipp
Sent: 06 August 2014 01:58
To: General Discussion of SQLite Database; sqlite-dev
Subject: [sqlite] SQLite version 3.8.6 coming soon
Version 3.8.6 was
Unless I'm misusing it, I believe the shell readfile() function reads a file
as text, not binary. I haven't checked writefile() for the same problem on
writing.
This is how I use it, is this not correct?
create table t1(a blob);
insert into t1 values(readfile('binfile'));
select * from t1;
On Wed, Aug 6, 2014 at 6:34 AM, Tony Papadimitriou to...@acm.org wrote:
Unless I'm misusing it, I believe the shell readfile() function reads a
file as text, not binary. I haven't checked writefile() for the same
problem on writing.
This is how I use it, is this not correct?
create table
On Wed, Aug 6, 2014 at 3:26 AM, Dominique Devienne ddevie...@gmail.com
wrote:
PS: backward compatibility, no s, no?
A google search shows that you see it both ways - with and without the
s. I've always used the s.
--
D. Richard Hipp
d...@sqlite.org
Hi Team,
We are using SQLite as a Client DB which is Local and Oracle
Db as a Server. We are trying to Copy SQLite DB to Oracle DB 11g Server
(Replication).Is this Possible?
If so Can we get the right steps for Replication.
how to replicate SQLite?
Thanks
Suvathi
Hello,
I am developing an .NET Framework 3.5 application for a Windows CE x32 PC. Can
I get a Library of SQLite for that System?
Best regards,
Tobias Stüker
Beckhoff Automation GmbH | Managing Director: Dipl. Phys. Hans Beckhoff, Arnold
Beckhoff
Registered office: Verl, Germany | Register
Hello,
I am developing a .NET Framework 3.5 application for a Windows CE 32bit (x86)
PC.
Can I get a Library of SQLite for that System?
Best regards,
Tobias
Beckhoff Automation GmbH | Managing Director: Dipl. Phys. Hans Beckhoff, Arnold
Beckhoff
Registered office: Verl, Germany | Register
On 4 August 2014 16:39, Edward Lau elau1...@aim.com wrote:
Specifically, if you are going to use SQL Server Integration Services (SSIS)
you can specify LF as the record delimiter. It defaults to {CR}{LF} but you
can change it in the FlatFile Connection Manager under the Advance tab.
Thanks
Did you already read
https://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki#sqlite-netFx35-binary-PocketPC-ARM-2008
?
On Tue, Aug 5, 2014 at 10:32 AM, Tobias Stüker t.stue...@beckhoff.com
wrote:
Hello,
I am developing an .NET Framework 3.5 application for a Windows CE x32 PC.
32-bit and 64-bit DLLs are the latest 3.8.6 beta are now available on the
download page. http://www.sqlite.org/download.html
On Tue, Aug 5, 2014 at 11:11 PM, jose isaias cabrera
jic...@cinops.xerox.com wrote:
Richard Hipp wrote...
Version 3.8.6 was originally scheduled for September.
Richard Hipp wrote...
32-bit and 64-bit DLLs are the latest 3.8.6 beta are now available on the
download page. http://www.sqlite.org/download.html
Thank you very much, Dr. Hipp.
josé
On Tue, Aug 5, 2014 at 11:11 PM, jose isaias cabrera
jic...@cinops.xerox.com wrote:
Richard Hipp
Hello List,
I have a strange problem with a statement like
select id from some_table where coalesce(some_col, 1) = :1
where :1 is a bind variable which i bind in my program using
sqlite3_bind_text.
I get no records, even if there are no null values anywhere in some_col.
I get the
On Wed, Aug 6, 2014 at 11:29 AM, Martin Engelschalk
engelsch...@codeswift.com wrote:
Hello List,
I have a strange problem with a statement like
select id from some_table where coalesce(some_col, 1) = :1
where :1 is a bind variable which i bind in my program using
sqlite3_bind_text.
On Wed, Aug 6, 2014 at 5:29 PM, Martin Engelschalk
engelsch...@codeswift.com wrote:
Hello List,
I have a strange problem with a statement like
select id from some_table where coalesce(some_col, 1) = :1
where :1 is a bind variable which i bind in my program using
sqlite3_bind_text.
*bump*
Anyone?
-Vern
Vern Jensen
Software Engineer
Artificial Intelligence in Medicine (AIM) Program
jens...@cshs.orgmailto:jens...@cshs.org
Office: 310-423-8148 :: Fax: 310-423-0173
On Aug 4, 2014, at 12:02 PM, Jensen, Vern
On 8/6/2014 11:51 AM, Jensen, Vern wrote:
*bump*
Anyone?
Not sure if this is your problem, but this kind of load puts a lot of
stress on SQLite's page cache, which might well perform worse than your
OS'es page cache (used for real disk IO) does, especially under high
contention.
Also,
On Wed, Aug 6, 2014 at 2:51 PM, Jensen, Vern vern.jen...@cshs.org wrote:
*bump*
Anyone?
I don't think anybody has any information for you Vern. So much depends on
the details of your setup that it is hard to speculate what might be going
wrong.
--
D. Richard Hipp
d...@sqlite.org
Thanks for the replies, Fabian and Richard.
It’s definitely ‘good enough’ performance as-is, I mainly wanted to see if I
was doing something clearly wrong, or if my results were surprising. Given that
they’re not, I’m happy to move on. Thanks again,
-Vern
IMPORTANT WARNING: This message is
Hello Sqlite team,
My specific need relies on a rather complex combination of in, and with
the new beta I go from 50 seconds down to 10 seconds.
(a 5x improvement)
== Is that sort of gain possible with the recent in omtimisation, or
shall look deeper if result is still right ?
Regards,
Hi,
I too noticed disappointing improvements by going :memory:.
But, it seems also very dependent of the compilation options and the
version of SQLite you use.
sometimes, gain is roughly 0%
sometimes, gain can be 40%.
== You may try with a more recent version of SQLite than 3.7.15.2.
On Wed, Aug 6, 2014 at 5:35 PM, big stone stonebi...@gmail.com wrote:
Hello Sqlite team,
My specific need relies on a rather complex combination of in, and with
the new beta I go from 50 seconds down to 10 seconds.
(a 5x improvement)
== Is that sort of gain possible with the recent in
On 6 Aug 2014, at 11:00pm, big stone stonebi...@gmail.com wrote:
I too noticed disappointing improvements by going :memory:.
But, it seems also very dependent of the compilation options and the
version of SQLite you use.
sometimes, gain is roughly 0%
sometimes, gain can be 40%.
Pagesize
On Wed, 6 Aug 2014 07:40:43 -0400
Richard Hipp d...@sqlite.org wrote:
PS: backward compatibility, no s, no?
A google search shows that you see it both ways - with and without the
s. I've always used the s.
http://www.perfectyourenglish.com/vocabulary/backward-backwards.htm
Two
On Wed, Aug 6, 2014 at 8:33 PM, James K. Lowden jklow...@schemamania.org
wrote:
On Wed, 6 Aug 2014 07:40:43 -0400
Richard Hipp d...@sqlite.org wrote:
PS: backward compatibility, no s, no?
A google search shows that you see it both ways - with and without the
s. I've always used
On Wed, Aug 6, 2014 at 6:56 PM, Richard Hipp d...@sqlite.org wrote:
On Wed, Aug 6, 2014 at 8:33 PM, James K. Lowden jklow...@schemamania.org
wrote:
On Wed, 6 Aug 2014 07:40:43 -0400
Richard Hipp d...@sqlite.org wrote:
PS: backward compatibility, no s, no?
A google
What is the system memory utilization?
If the in-memory database overloads the real memory
the frantic os virtual memory paging (thrashing) could slow
everything down.
From your use scenario it sounds like your database shouldn't be that large,
but how large is the database? and how large is the
ok,
output comparison
Size is different :
- before28 488 559
- now with beta 28 711 111
== delta = 222 552 ... which is my number of ouput lines
The change in Newline Output policy (from CR to CR+LF) did generate a
suspens.
WinMerge says output is identical otherwise.
So my 5x
30 matches
Mail list logo