Re: [sqlite] [sqlite-dev] sqlite3 db is locked

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 > 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

Re: [sqlite] Web application with SQLite

On Tue, Dec 31, 2013 at 6:17 PM, Tim Johnson wrote: > * Eduardo [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

Re: [sqlite] Happy New Year

Happy New Year to you as well. Sent from my iPad > On Dec 31, 2013, at 7:46 PM, "Igor Korot" 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

Re: [sqlite] unable to use function MATCH in requested context

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 wrote: > Hi, as a sanity check,

Re: [sqlite] Web application with SQLite

* Eduardo [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!

[sqlite] unable to use function MATCH in requested context

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

Re: [sqlite] "Common Table Expression"

On 31 Dec 2013, at 10:05pm, James K. Lowden 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);

Re: [sqlite] "Common Table Expression"

On Tue, 31 Dec 2013 20:43:20 +0100 big stone 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

Re: [sqlite] Windows Embedded Handheld 6.5

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

Re: [sqlite] SQLite 2013 retrospective

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

Re: [sqlite] SQLite 2013 retrospective

On 31 Dec 2013, at 7:36pm, jose isaias cabrera 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

Re: [sqlite] "Common Table Expression"

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 :

Re: [sqlite] "Common Table Expression"

On Thu, 26 Dec 2013 20:23:33 +0100 big stone 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

Re: [sqlite] Using SQLite by Jay Kreibich (2010 paperback edition)

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 wrote: > On Tue, Dec 31, 2013 at 2:33 PM, Jay Kreibich wrote: > >> Using SQLite covers up to the

Re: [sqlite] SQLite 2013 retrospective

2013/12/31 Richard Hipp : > 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

[sqlite] SQLite 2013 retrospective

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

[sqlite] SQLite3 temporary filename collision in worker processes

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,

Re: [sqlite] Using SQLite by Jay Kreibich (2010 paperback edition)

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

Re: [sqlite] Using SQLite by Jay Kreibich (2010 paperback edition)

On Tue, Dec 31, 2013 at 2:33 PM, 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. Certainly you intended 3.x instead of 2.x? To quote the preface: "The first edition

Re: [sqlite] Using SQLite by Jay Kreibich (2010 paperback edition)

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

Re: [sqlite] Using SQLite by Jay Kreibich (2010 paperback edition)

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.

Re: [sqlite] Web application with SQLite

> 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.

Re: [sqlite] Error 11 after doing a lot of simple insert/update operations!

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

Re: [sqlite] Error 11 after doing a lot of simple insert/update operations!

On 31 Dec 2013, at 8:41am, Woody Wu 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

[sqlite] Error 11 after doing a lot of simple insert/update operations!

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