[sqlite] (Lemon) (Patch) adding a -f option to Lemon to emit function prototypes

2013-01-05 Thread Tiago Rodrigues
Hello, all, First, forgive me if this is the wrong medium for submitting this, but I'm rather new at this patch submission business. Anyway, I was using Lemon to generate a few parsers for a program I'm writing (which uses SQLite, too, for storage), and I noticed that the files I used to call

Re: [sqlite] Multi thread questions

2013-01-05 Thread Krzysztof
Thanks :) ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Multi thread questions

2013-01-05 Thread Richard Hipp
On Sat, Jan 5, 2013 at 7:14 AM, Krzysztof wrote: > Hi, > > I'm reading documentation about multi threading. I just want to be sure: > 1. I can safely create another thread (with new handle / connection) in my > application and modify SAME database at the same time > Yes, as long

Re: [sqlite] Don't passes next tests on FreeBSD: atof1-*

2013-01-05 Thread Richard Hipp
On Sat, Jan 5, 2013 at 1:40 AM, Pavel Volkov wrote: > Hello. Excuse me. > I found the following errors when running tests in the operating > system FreeBSD x32: (this is an example) > Please send the output of the following command: cpp -dM /dev/null | sort -- D.

[sqlite] Multi thread questions

2013-01-05 Thread Krzysztof
Hi, I'm reading documentation about multi threading. I just want to be sure: 1. I can safely create another thread (with new handle / connection) in my application and modify SAME database at the same time 2. I want use second connection in thread for importing while main thread working

Re: [sqlite] INSERT OR IGNORE - returning new or existing rowid

2013-01-05 Thread BareFeetWare
This kind of question often results in answers along the lines of application logic such as: "If the row exists get the ID else create it and then get the ID". But the SQL way of doing things is subtly different: "insert a new row where it doesn't already exist. Get the ID of the row". Based