Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rKOh5-002UKm-I2 for pgsql-www@arkaria.postgresql.org; Mon, 01 Jan 2024 20:15:27 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rKOh3-00DEcC-Jk for pgsql-www@arkaria.postgresql.org; Mon, 01 Jan 2024 20:15:25 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rKOh3-00DEbk-CW for pgsql-www@lists.postgresql.org; Mon, 01 Jan 2024 20:15:25 +0000 Received: from janus.karlpinc.com ([173.161.46.12] helo=smtp.karlpinc.com) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rKOgy-00F2K1-Jm for pgsql-www@lists.postgresql.org; Mon, 01 Jan 2024 20:15:22 +0000 Received: from slate.karlpinc.com (unknown [192.168.1.14]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (2048 bits)) (No client certificate requested) by smtp.karlpinc.com (Postfix) with ESMTPS id C6067A126; Mon, 1 Jan 2024 14:15:17 -0600 (CST) Received: from slate.karlpinc.com (localhost [IPv6:::1]) by slate.karlpinc.com (Postfix) with ESMTPS id 935343FD53; Mon, 1 Jan 2024 14:15:17 -0600 (CST) Date: Mon, 1 Jan 2024 14:15:16 -0600 From: "Karl O. Pinc" To: "Jonathan S. Katz" Cc: Benjamin Scherrey , pgsql-www@lists.postgresql.org, Vik Fearing , Bruce Momjian , Tom Lane Subject: Re: Describing Postgres as "object-relational" on the home page Message-ID: <20240101141516.5a9274ee@slate.karlpinc.com> In-Reply-To: <20240101134459.0d23672b@slate.karlpinc.com> References: <20231226131047.493259f8@slate.karlpinc.com> <20231228135446.3ba508d5@slate.karlpinc.com> <20231231114052.30eccee6@slate.karlpinc.com> <20240101134459.0d23672b@slate.karlpinc.com> X-Mailer: Claws Mail 3.17.8 (GTK+ 2.24.33; x86_64-pc-linux-gnu) MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, 1 Jan 2024 13:44:59 -0600 "Karl O. Pinc" 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 Free Software: "You don't pay back, you pay forward." -- Robert A. Heinlein