Re: [sqlite] delete the extra row from 2 similar tables with 2 key

On 9/28/2013 7:12 PM, ChingChang Hsiao wrote: I have 2 similar tables. If_idx and dest_addr_idx are the keys. I am trying to synchronize the rows. Is there one sql statement to delete the extra row or 2 statements to get the result for the extra if_idx, 69 and dest_addr_idx ,1 and then

[sqlite] SQLite4 release data and how to compile on windows platform

Does anyone know if any release date has been announced for SQLite4? Secondly where can I find the instructions to compile SQLite4 on windows platform. Thanks. ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] delete the extra row from 2 similar tables with 2 key

I have 2 similar tables. If_idx and dest_addr_idx are the keys. I am trying to synchronize the rows. Is there one sql statement to delete the extra row or 2 statements to get the result for the extra if_idx, 69 and dest_addr_idx ,1 and then delete it from the table

Re: [sqlite] Using an sqlite db as a mutex?

On Sat, Sep 28, 2013 at 1:04 AM, Simon Slavin wrote: > Frankly, if you're using SQLite as a mutex base you'd do better using the > presence or absence of a file instead. To signal that your database is > locked, create a file. If, when you create the file, you get an

Re: [sqlite] Using an sqlite db as a mutex?

On Thu, Sep 26, 2013 at 5:31 PM, Dan Kennedy wrote: > It does. Both open a write transaction on the database. In the\ > parent posts case either would work. > Follow-up: i implemented this yesterday and it seems to do the job nicely. Actually triggering the race condition