[sqlite] super

Hey, There is something super interesting for you, just take a look, you'll never regret. Please, read more here Sent from my iPhone, ronny.dier...@telenet.be ___ sqlite-users mailing list

[sqlite] Possibly missing feature in json1 extension

I'm working with SQLite 3.13.0, and am the process of adding a new table to a database: CREATE TABLE settings(key TEXT PRIMARY KEY NOT NULL, value TEXT) This table will hold arbitrarily named application defined settings. For the value column I’d like to use JSON for every row, as some of the

Re: [sqlite] Trouble coding conditional UNIQUE

On Thu, Jun 16, 2016 at 9:40 PM, Drago, William @ CSG - NARDA-MITEQ < william.dr...@l-3com.com> wrote: > > On Behalf Of James K. Lowden > > > > create view vParts as > > select 1 as Matched, * from Parts > > UNION > > select 0, * from UnmatchedParts > Why UNION instead of

Re: [sqlite] Correct, best, or generally accepted database structure for groups of things

On 16 Jun 2016, at 9:53pm, Drago, William @ CSG - NARDA-MITEQ wrote: > Should that function insert its results into a table that looks like the one > below, or is there a better way? > > CREATE TABLE Groups ( > ID INTEGER PRIMARY KEY, > AppleID1 INTEGER > AppleID2

Re: [sqlite] Correct, best, or generally accepted database structure for groups of things

On 6/16/2016 4:53 PM, Drago, William @ CSG - NARDA-MITEQ wrote: Say I had a table of apples: CREATE TABLE Apples ( ID INTEGER PRIMARY KEY, Color TEXT COLLATE NOCASE, --Could be Red, Green, or Yellow Height REAL, --Measured in cm Width REAL --Measured in cm Weight REAL --Measured in grams );

[sqlite] Correct, best, or generally accepted database structure for groups of things

All, Say I had a table of apples: CREATE TABLE Apples ( ID INTEGER PRIMARY KEY, Color TEXT COLLATE NOCASE, --Could be Red, Green, or Yellow Height REAL, --Measured in cm Width REAL --Measured in cm Weight REAL --Measured in grams ); And say I had a function that looks at the Apples table and

Re: [sqlite] Trouble coding conditional UNIQUE

> -Original Message- > From: sqlite-users-boun...@mailinglists.sqlite.org [mailto:sqlite-users- > boun...@mailinglists.sqlite.org] On Behalf Of James K. Lowden > Sent: Tuesday, June 14, 2016 8:55 PM > To: sqlite-users@mailinglists.sqlite.org > Subject: Re: [sqlite] Trouble coding

Re: [sqlite] Sync journal's directory per transaction? or until database closed? in PERSIST mode

1. the directory must sync per transaction? Directory synchronization is necessary. For example, If current file system uses EXT3 or EXT4 on linux, files can be lost if directory sync is not called. AFAIK, new created journal file may not be linked at that time. To get more detailed information

[sqlite] Sync journal's directory per transaction? or until database closed? in PERSIST mode

First of all, my English skill is not good. So please forgive me if my sentences are rude. My name is Byungeun Park.I am a Computer Science Master student in South Korea. I'm doing a research to enhance the SQLite performance. = static