On Mon, 1 Jan 2024 13:44:59 -0600
"Karl O. Pinc" <kop@karlpinc.com> wrote:
> instead of coming up with wording describing
> functionality, workloads, etc., to simply say "PostgrSQL does lots
> more stuff." on the home page and link that to a page with nothing
> but keywords.
> To extend this idea, just a list of keywords is not engaging.
> Categorizing the keywords by attaching one or more tags to each opens
> up possibilities for interaction and alternate ways to view the
> keywords.
-- A back of the envelope schema for tagged technology keywords
CREATE TABLE keywords (
keyword TEXT PRIMARY KEY,
url TEXT,
cantag BOOLEAN);
CREATE TABLE taggings (
tag TEXT REFERENCES keywords,
keyword TEXT REFERENCES keywords);
-- And a trigger is needed to ensure that taggings.tag
-- is related to a keywords row having a keywords.cantag value of true.
Regards,
Karl <kop@karlpinc.com>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein