[sqlite] lemon problem with two versions of lempar.c

2015-04-15 Thread Richard Hipp
On 4/15/15, Neo Anderson wrote: > I am utilizing lemon in one of my Apple Store Apps. My parser works fine > with the 'old' lempar.c found in source tree TRUNK/tool/.I also > found a newer version in TRUNK/src, but when I compile myparser.c generated > using this lempar.c, I got compilation

[sqlite] Best way to temporarily store data before processing

2015-04-15 Thread Petite Abeille
> On Apr 14, 2015, at 11:40 AM, Jonathan Moules > wrote: > > Options that have come to mind (probably missed a lot): I personally use temp tables, e.g. 'create temporary table if not exists foo?, coupled with 'pragma temp_store = memory?, and drop/create them as necessary, e.g. 'drop table

[sqlite] Request: Metadata about C API constants and functions

2015-04-15 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 04/10/2015 07:11 AM, Richard Hipp wrote: > On 4/9/15, Roger Binns wrote: >> >> So the URL for this SQLite database is? :-) >> > > https://www.sqlite.org/toc.db Thank you for this. I've now updated my doc build tools, and even added some more

[sqlite] SQLite to SQL Server

2015-04-15 Thread Erik Ejlskov Jensen
If you have VS, you can use my free SQLite Toolbox add-in, just added feature to migrate to and from SQL Server with "a single click". http://erikej.blogspot.dk/2015/03/sql-server-compact-sqlite-toolbox-42.html

[sqlite] Getting a crash on 32-bit Linux

2015-04-15 Thread Ron Aaron
Astonishingly, the problem went away when I switched from using "clang" to using "gcc", on Linux 32 bit. The actual problem was a 'memcpy' crash, due to incorrect stack alignment. Normally, this is a gcc problem on 64-bit, but here it turned up on Linux 32 bit. Perhaps something to do with

[sqlite] Best way to temporarily store data before processing

2015-04-15 Thread Scott Hess
On Tue, Apr 14, 2015 at 1:10 PM, David Cotter wrote: > does this awesome sounding temp table then merge instantly when you commit it > even if it?s huge? Since I have no idea what "merge" means in this context, it's hard to answer your question. -scott

[sqlite] how to realize md5 function

2015-04-15 Thread Simon Slavin
On 15 Apr 2015, at 2:19am, YAN HONG YE wrote: > sqlite> select md5('mm1234'); > Error: no such function: md5 http://www.swhistlesoft.com/blog/2011/01/07/54-sqlite-hashing-functions-library http://stackoverflow.com/questions/3179021/sha1-hashing-in-sqlite-how/3179047#3179047 Simon.

[sqlite] how to realize md5 function

2015-04-15 Thread YAN HONG YE
sqlite> select md5('mm1234'); Error: no such function: md5