CREATE TABLE IF NOT EXISTS pages(
  id INTEGER PRIMARY KEY,
  name TEXT,
  popularity INTEGER
);

.mode csv
.separator "\t"
.import /dev/stdin pages

CREATE INDEX pages_name_popularity_index ON pages(name, popularity DESC);

CREATE TABLE IF NOT EXISTS pages(
  id INTEGER PRIMARY KEY,
  name TEXT,
  popularity INTEGER
);

.mode csv
.separator "\t"
.import /dev/stdin pages

CREATE INDEX pages_name_popularity_index ON pages(name COLLATE NOCASE, popularity DESC);

Add COLLATE NOCASE to pages name index
Add COLLATE NOCASE to pages name index
