[sqlite] Need help with SQL query

Hi All, I need some help in figuring our right query syntax for querying items from two tables. We have two tables. One of the table has list of items. And Second table has additional attributes. CREATE TABLE ITEM ( ID INTEGER, FIELD0 TEXT FIELD1 TEXT, FIELD3 TEXT, FIELD4 TEXT ); CREATE TABLE

Re: [sqlite] Massively multithreaded SQLite queries

Hi Andrew, This is a great use case for SQLite. Did you have to use any special flags or settings for SQLite to achieve this e.g. cache size, page size Read only etc? Thanks, Vikas > On Jun 7, 2017, at 10:07 AM, Andrew Brown > wrote: > > Wanted to just

Re: [sqlite] Copying from one table to another

Hi Ryan, Thanks for the transaction suggestion. We will do that. I provided a simplistic example for constraints, but I think I have an answer now. Thanks, Vikas On Nov 21, 2016, at 12:24 PM, R Smith <rsm...@rsweb.co.za> wrote: > > > On 2016/11/21 9:57 PM, Vikas Adit

Re: [sqlite] Copying from one table to another

Thank You! Vikas On Nov 21, 2016, at 12:09 PM, Richard Hipp <d...@sqlite.org> wrote: > On 11/21/16, Vikas Aditya <vikas.adi...@quikfynd.com> wrote: >> >> Currently we are using: >> >> sql = "INSERT INTO {} SELECT * FROM {}".format(totable, f

[sqlite] Copying from one table to another

Hi everyone, I have a DB migration question. I have a table called "employees" and it has a UNIQUE constraint on "employee_email". With some new features being requested, I need to relax the constraint and have a new constraint on "employee_email" + "employee_number". Since SQLite ALTER table