[sqlite] Putting an index on a boolean

[Cecil Westerhof]

I am playing with SQLite. I am thinking about writing an application for
projects. At the moment I have the following:

CREATE TABLE `projects` (
    `projectID`     TEXT    PRIMARY KEY,
    `groupID`       TEXT,
    `isPersonal`    INTEGER NOT NULL CHECK(isPersonal in (0, 1)),
    `name`          TEXT,
    `description`   TEXT,
    `outcome`       TEXT
);
CREATE INDEX projects_groupID_idx
ON projects(groupID);
CREATE INDEX projects_isPersonal_idx
ON projects(isPersonal);

?I like to differentiate between personal and non personal projects. Is it
a good idea to put a index on isPersonal?


By the way: I am thinking about using UUID for projectID and groupID, but I
heard somewhere that it was a bad idea to use UUID for an indexed field. Is
this true??

-- 
Cecil Westerhof