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
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
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",
>> 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
-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
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
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
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
8 matches
Mail list logo