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 on

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

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 pavelivol...@gmail.com 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.

Re: [sqlite] Multi thread questions

2013-01-05 Thread Richard Hipp
On Sat, Jan 5, 2013 at 7:14 AM, Krzysztof dib...@wp.pl 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 as you

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

[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