README.txt

Simple tags system with a notion of parents. May be used for file paths, I guess.

Licensed as CC-0

tags.psql

create table tags (
  id text not null check (id <> ''),
  parent text generated always as ((regexp_match(id, '^(.*)/[0-9a-z_]+$'))[1]) stored,

  foreign key (parent) references tags,
  primary key (id)
);

insert into tags values ('game');
insert into tags values ('game/rpg');
insert into tags values ('game/action');
insert into tags values ('game/arcade');
insert into tags values ('game/arcade/2d');