From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from lists.gentoo.org (pigeon.gentoo.org [208.92.234.80]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits)) (No client certificate requested) by finch.gentoo.org (Postfix) with ESMTPS id 54C14158042 for ; Mon, 28 Oct 2024 13:57:18 +0000 (UTC) Received: from pigeon.gentoo.org (localhost [127.0.0.1]) by pigeon.gentoo.org (Postfix) with SMTP id 10A6AE0819; Mon, 28 Oct 2024 13:57:14 +0000 (UTC) Received: from beast.visionsuite.biz (beast.visionsuite.biz [85.163.23.103]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256) (No client certificate requested) by pigeon.gentoo.org (Postfix) with ESMTPS id C1EAAE07C9 for ; Mon, 28 Oct 2024 13:57:13 +0000 (UTC) Received: from localhost (beast.visionsuite.biz [127.0.0.1]) by beast.visionsuite.biz (Postfix) with ESMTP id 90EE254C3188; Mon, 28 Oct 2024 14:57:11 +0100 (CET) X-Virus-Scanned: amavisd-new at visionsuite.biz Received: from beast.visionsuite.biz ([127.0.0.1]) by localhost (beast.visionsuite.biz [127.0.0.1]) (amavisd-new, port 10026) with LMTP id m4YAbfHXEJdx; Mon, 28 Oct 2024 14:57:09 +0100 (CET) Received: from roundcube.visionsuite.biz (beast.visionsuite.biz [127.0.0.1]) by beast.visionsuite.biz (Postfix) with ESMTPA id 8E47554C3174; Mon, 28 Oct 2024 14:57:09 +0100 (CET) Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Subscribe: List-Id: Gentoo Linux mail X-BeenThere: gentoo-dev@lists.gentoo.org Reply-to: gentoo-dev@lists.gentoo.org X-Auto-Response-Suppress: DR, RN, NRN, OOF, AutoReply MIME-Version: 1.0 Date: Mon, 28 Oct 2024 14:57:09 +0100 From: =?UTF-8?Q?Miroslav_=C5=A0ulc_=28fordfrog=29?= To: gentoo-dev@lists.gentoo.org Cc: Patrick Lauer Subject: Re: [gentoo-dev] RFC: New PostgreSQL categories In-Reply-To: <7eb6a37e-bd6a-434b-b97a-21eacdbed981@gentoo.org> References: <7eb6a37e-bd6a-434b-b97a-21eacdbed981@gentoo.org> Message-ID: <1c00d0e4f449e078ecd7d6ae2e7111d6@gentoo.org> X-Sender: fordfrog@gentoo.org Content-Type: text/plain; charset=US-ASCII; format=flowed Content-Transfer-Encoding: 7bit X-Archives-Salt: 2078090a-6b87-4243-a37b-1ee09760d44d X-Archives-Hash: ffa1afb859cc40be34f4683dea6c0778 just a sidenote, dev-db/apgdiff is also a tool specific to postgresql (i authored it long time ago). Dne 2024-10-28 14:49, Patrick Lauer napsal: > Hello everyone, > > I've just returned from the pgconf.eu conference, and this has > motivated me to try to improve the packaging situation for all things > PostgreSQL in Gentoo. > > Right now everything just goes into dev-db/ category. That's not > inherently wrong, but it feels a bit overloaded to me. So I'd like to > add two new categories. I'm relatively indifferent about the naming, > good suggestions welcome, but locally I ended up naming them "pg-tools" > and "pg-extensions". As the name suggests, one category is tools around > PostgreSQL, and the other is extensions. (Or maybe it makes sense to > put all of it into a dev-postgres category?) > > A good amount of things are in-tree already, a lot of other things I've > accumulated in a local repository. Most of it is very boring (i.e. most > extensions 'just' use a plain Makefile) and has low rate of change. > > The packages involved are: > > - extensions, in-tree: > dev-db/plr > dev-db/pgrouting > dev-db/citus > dev-db/pgtap > dev-db/postgis > dev-db/slony1 > dev-db/pglogical > dev-db/timescaledb > > - extensions, new packages: > pg-extensions/clickhouse_fdw | Clickhouse ForeignDataWrapper for > PostgreSQL > pg-extensions/icu_ext | An extension to expose functionality from ICU > to PostgreSQL applications. > pg-extensions/lantern | Vector similarity search for Postgresql > pg-extensions/mongo_fdw | MongoDB foreign data wrapper for Postgresql > pg-extensions/mysql_fdw | MySQL/MariaDB foreign data wrapper for > Postgresql > pg-extensions/odbc_fdw | ODBC FDW for PostgreSQL > pg-extensions/pg_auto_failover | Monitors and manage automated > failover for Postgres clusters > pg-extensions/pg_crash | Reliably crash PostgreSQL > pg-extensions/pg_cron | simple cron-based job scheduler for PostgreSQL > pg-extensions/pg_embedding | Hierarchical Navigable Small World (HNSW) > for vector similarity search > pg-extensions/pg_failover_slots | Failover for replication slots > pg-extensions/pg_globalxact | tools for distributed transactions > within PostgreSQL > pg-extensions/pg_hint_plan | tweak PostgreSQL execution plans with > hints > pg-extensions/pg_ivm | Incremental View Maintenance for PostgreSQL > pg-extensions/pg_jobmon | Autonomous logging capabilities for > PostgreSQL transactions/functions > pg-extensions/pg_partman | PostgreSQL Partition Manager > pg-extensions/pg_profile | find the most resource intensive activities > in PostgreSQL > pg-extensions/pg_qualstats | statistics on predicates found in WHERE > statements and JOIN clauses > pg-extensions/pg_stat_kcache | Gathers statistics about real reads and > writes done by the filesystem layer > pg-extensions/pg_wait_sampling | sampling based statistics of wait > events in PostgreSQL > pg-extensions/pgfaceting | Vector similarity search for Postgresql > pg-extensions/pgroonga | Fast FullTextSearch for PostgreSQL > pg-extensions/pgsphere | PostgreSQL extension for spherical geometry > pg-extensions/pgsql-ogr-fdw | OGR FDW for PostgreSQL > pg-extensions/pgvector | Vector similarity search for Postgresql > pg-extensions/pgvectorscale | enhanced ML/vector extension > pg-extensions/pllua | Embeds Lua into PostgreSQL as a procedural > language module. > pg-extensions/postgres-tde-ext | experimental encrypted access method > pg-extensions/postgresql-unit | SI Units for PostgreSQL > pg-extensions/rum | RUM access method > pg-extensions/tds_fdw | TabularDataStream foreign data wrapper > > The tools are: > - in tree: > dev-db/barman > dev-db/pg_top > dev-db/pgagent > dev-db/pgbouncer > dev-db/pgcli > dev-db/pgmodeler > dev-db/pgpool2 > dev-db/pgxnclient > dev-db/phppgadmin > dev-db/pspg > dev-db/psqlodbc > dev-db/repmgr > dev-db/slony1 > > - new packages: > pg-tools/patroni | PostgreSQL HA with ZooKeeper, etcd or Consul > pg-tools/pg_catcheck | Postgres system catalog check tool > pg-tools/pg_checksums_ext | Postgres data checksum tool > pg-tools/pg_timetable | Advanced scheduling for PostgreSQL > pg-tools/pgbackrest | Simple, reliable, scalable backup solution to > postgres > pg-tools/pgcopydb | Postgres DB copy tool > pg-tools/pgloader | loads data into PostgreSQL > pg-tools/pgroll | Zero-downtime, reversible, schema migrations for > Postgres > pg-tools/sqlpage | A SQL-only web application framework. Takes .sql > files and formats the query result using pre-made configurable > professional-looking components. > pg-tools/vip-manager | Manages a virtual IP based on state kept in > etcd or Consul > pg-tools/wal-g | archival restoration tool for PostgreSQL, > MySQL/MariaDB, and MS SQL Server > > > Have fun, > > Patrick