Re: [sqlite] Tags / keywords support?

2014-12-05 Thread Keith Medcalf
You probably want your "name" fields in each table to be declared name TEXT COLLATE NOCASE UNIQUE Your ImageTags should also have an index UNIQUE (TagID, ImageID) The AUTOINCREMENT keyword in each of the Images and Tags table is unnecessary. You also want fields containing the same thing to have

Re: [sqlite] Tags / keywords support?

2014-12-05 Thread Constantine Yannakopoulos
On Fri, Dec 5, 2014 at 10:49 PM, Krzysztof wrote: > Hi, > > I need extra field which contain tags / keywords describing such > record. Then I want to find record ID by using tags. I know that it is > easy with TEXT field and LIKE condition but I have issue with update > speed. Let say that you ha

[sqlite] Tags / keywords support?

2014-12-05 Thread Krzysztof
Hi, I need extra field which contain tags / keywords describing such record. Then I want to find record ID by using tags. I know that it is easy with TEXT field and LIKE condition but I have issue with update speed. Let say that you have collection of photos and you want to add tags like "summer",

Re: [sqlite] Search for text in all tables

2014-12-05 Thread Max Vlasov
>> I once implemented a virtual table "allvalues" that outputs all >> database values with (hope self-explaining) fields >> >> TableName, TableRowId, FieldName, Value > > Could you expand on how you coped with the underlying database > changing, and how you mapped virtual table rowids to the actual

Re: [sqlite] Search for text in all tables

2014-12-05 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 12/05/2014 01:24 AM, Max Vlasov wrote: > I once implemented a virtual table "allvalues" that outputs all > database values with (hope self-explaining) fields > > TableName, TableRowId, FieldName, Value Could you expand on how you coped with the u

[sqlite] Where sqlite vtables are used? (was: Search for text in all tables)

2014-12-05 Thread Alek Paunov
On 05.12.2014 12:32, Dominique Devienne wrote: On Fri, Dec 5, 2014 at 10:24 AM, Max Vlasov wrote: Not particularity the answer to your question, but rather a method you or others might use. I once implemented a virtual table "allvalues" that outputs all database values with (hope self-explaini

Re: [sqlite] Search for text in all tables

2014-12-05 Thread Dominique Devienne
On Fri, Dec 5, 2014 at 10:24 AM, Max Vlasov wrote: > Not particularity the answer to your question, but rather a method you > or others might use. > I once implemented a virtual table "allvalues" that outputs all > database values with (hope self-explaining) fields > > TableName, TableRowId, Fi

Re: [sqlite] Search for text in all tables

2014-12-05 Thread Max Vlasov
On Thu, Dec 4, 2014 at 10:44 AM, Baruch Burstein wrote: > > Is it possible to somehow search for/replace a string in all columns of all > tables? > Not particularity the answer to your question, but rather a method you or others might use. I once implemented a virtual table "allvalues" that outpu