Hi,
I found sqlite (3.8.2 as well as 3.7.17) cannot stand reliably with some
simple insert/update operations on a single table with primary
key. I found this problem on ARM platform with varities of filesystems
including UBIFS, Yafss on NAND, and Ext4 on SDCARD.
Attached is the test program
On 31 Dec 2013, at 8:41am, Woody Wu narkewo...@gmail.com wrote:
Attached is the test program writting in C.
Sorry, but attachments don't work here. If your program is short, please post
it as text. If not, please put it on a web site somewhere.
Anyway, all above errors looks so strange.
Hi, Simon
I upload the source code onto my dropbox:
https://www.dropbox.com/s/9shhshi0wn3e717/downloadfile.c Please have a
look at it.
The same test program run without a problem on my pc Linux after complied
natively. But I think I should not dout my cross-compiler, which is
CodeBench ARM
Understood. Thanks
Sorry if I'm late.
There's no difference between developing a formal application and a Web
application from the Sqlite point of view.
You can check mongoose webserver. It uses LUA for scripting web pages
(similar to PHP but with LUA) and Sqlite for db access from LUA.
Thank you, I will look more closely at the node-sqlite3 documentation.
Bob
On 12/31/13, 12:25 AM, Navaneeth K N wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA512
Hello,
On 12/31/13 8:18 AM, Bob Cochran wrote:
I'm working on a tough project that requires me to use Node.js and
SQLite.
Using SQLite covers up to the very last 2.6 version of SQLite. The book went
to press about the same time that SQLite 2.7.0 came out. As such, the book
does not cover WAL or any of the more resent features. The book only covers
the C/C++ APIs, since everything else is based off those.
The
On Tue, Dec 31, 2013 at 2:33 PM, Jay Kreibich j...@kreibi.ch wrote:
Using SQLite covers up to the very last 2.6 version of SQLite. The book
went to press about the same time that SQLite 2.7.0 came out.
Certainly you intended 3.x instead of 2.x?
To quote the preface:
The first edition of
Thank you, Jay!
Bob
On 12/31/13, 8:33 AM, Jay Kreibich wrote:
Using SQLite covers up to the very last 2.6 version of SQLite. The book went
to press about the same time that SQLite 2.7.0 came out. As such, the book
does not cover WAL or any of the more resent features. The book only
Hi,
I am using SQLite 3.8.1 compiled from the amalgamation on Debian GNU/Linux
wheezy, amd64.
I have set a logging callback with sqlite3_config(SQLITE_CONFIG_LOG, qlog,
NULL), and I see the following error sometimes:
Query INSERT INTO topush (block, size, node, expires_at) VALUES (:b, :s, :n,
Here is a quick summary of the changes and enhancements to SQLite during
2013. The comparison is between trunk versions,
http://www.sqlite.org/src/info/a611c75 versus
http://www.sqlite.org/src/info/cc72c5aec7
The amalgamation source file grew in side from 137619 lines to 145010
lines, or 4868834
2013/12/31 Richard Hipp d...@sqlite.org:
Here is a quick summary of the changes and enhancements to SQLite during
2013. The comparison is between trunk versions,
http://www.sqlite.org/src/info/a611c75 versus
http://www.sqlite.org/src/info/cc72c5aec7
...
Major new features added in 2013
Yes, of course. Sorry. It would seem I shouldn't answer email that early in
the morning on a day off.
-j
On Dec 31, 2013, at 7:48 AM, Stephan Beal sgb...@googlemail.com wrote:
On Tue, Dec 31, 2013 at 2:33 PM, Jay Kreibich j...@kreibi.ch wrote:
Using SQLite covers up to the very last
On Thu, 26 Dec 2013 20:23:33 +0100
big stone stonebi...@gmail.com wrote:
Indeed, '1' CTE can be replaced by the creation of 'N' temporary
views (or tables), and their deletion after the CTE request.
CTE is :
- a syntaxic simplification :
. the SQL creator don't have to care about those
Hello CTE in SQLite fans,
To get CTE in SQLite, I guess we must answer by the example the fears
expressed by Simon and Rsmith.
I propose the following method :
- unproven-demand :
== publish on this mailing list external CTE for SQLite
implementations,
== if there is demand :
On 31 Dec 2013, at 7:36pm, jose isaias cabrera cabr...@wrc.xerox.com wrote:
It would be nice to know also if you have any major idea(s) for enhancements
for sqlite3 in 2014.
You might consider SQLite4 to be major ideas for SQLite3
http://sqlite.org/src4/doc/trunk/www/design.wiki
though as
Wanted to thank the team for all there great work and wish everyone a Happy New
Year! And all the best in 2014.
Cheers
Ryan
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Richard Hipp
Sent: Tuesday, December 31, 2013
I did see the System.Data.SQLite binaries for PocketPC I was not shore they
were the ones to use. It has been a very long time since I have done any
Windows Mobile development and within Visual Studio 2008 I see a development
template and separate SDK for PocketPC and Windows Mobile 6.0
On Tue, 31 Dec 2013 20:43:20 +0100
big stone stonebi...@gmail.com wrote:
To get CTE in SQLite, I guess we must answer by the example the fears
expressed by Simon and Rsmith.
I propose the following method :
- unproven-demand :
...
- code size + performance increase fear :
It seems to
On 31 Dec 2013, at 10:05pm, James K. Lowden jklow...@schemamania.org wrote:
Meanwhile, here's a much more important failing that cannot be worked
around within SQL without a temporary table:
sqlite create table i ( i int primary key );
sqlite insert into i values (1);
Hi, as a sanity check, did something change in the use of MATCH with JOINs?
I used to do
SELECT ...
FROM Entries e
INNER JOIN Combos c ON e.Entries MATCH c.combo
INNER JOIN Entries_content ec ON ec.docid = e.docid
but now I get unable to use function MATCH in the requested context. I
can pull
* Eduardo emorr...@yahoo.es [131231 07:11]:
You can check mongoose webserver. It uses LUA for scripting web pages
(similar to PHP but with LUA) and Sqlite for db access from LUA.
I found what I believe is the mongoose page at
https://code.google.com/p/mongoose/
Very interesting!
In fact, it does not work in a nested query - the issue is actually
multiple inner joins. When I LEFT JOIN the rest of the tables, it works
fine. This must have been a change in the last year or so.
On Tue, Dec 31, 2013 at 3:15 PM, E. Timothy Uy t...@loqu8.com wrote:
Hi, as a sanity check, did
Happy New Year to you as well.
Sent from my iPad
On Dec 31, 2013, at 7:46 PM, Igor Korot ikoro...@gmail.com wrote:
Hi, ALL,
I want to wish everybody who is reading and involved with the list
Happy and oyful New Year!
Let's have a great time in it and lets make a lot of good products and
On Tue, Dec 31, 2013 at 6:17 PM, Tim Johnson t...@akwebsoft.com wrote:
* Eduardo emorr...@yahoo.es [131231 07:11]:
You can check mongoose webserver. It uses LUA for scripting web pages
(similar to PHP but with LUA) and Sqlite for db access from LUA.
I found what I believe is the
The code in function from the 1st e-mail is used before exiting, so the
sqlite3_close is called in fact.
2013/12/30 Dan Kennedy danielk1...@gmail.com
On 12/29/2013 11:43 PM, Alexander Syvak wrote:
Hello,
there's a LabView app. which is calling C++ function from a DLL.
In the DLL the
25 matches
Mail list logo
