Re: List of all* PostgreSQL EXTENSIONs in the world - Mailing list pgsql-hackers

From Joe Conway
Subject Re: List of all* PostgreSQL EXTENSIONs in the world
Date
Msg-id 9d56ed80-9b06-28c2-9214-5718fc7e08e4@joeconway.com
Whole thread Raw
In response to Re: List of all* PostgreSQL EXTENSIONs in the world  ("Euler Taveira" <euler@eulerto.com>)
Responses Re: List of all* PostgreSQL EXTENSIONs in the world  (Aleksander Alekseev <aleksander@timescale.com>)
List pgsql-hackers
On 2/23/22 09:33, Euler Taveira wrote:
> On Wed, Feb 23, 2022, at 6:00 AM, Joel Jacobson wrote:
>> On Fri, Feb 11, 2022, at 04:46, Noah Misch wrote:
>> > How did you make the list?  (I'd imagine doing it by searching for
>> > repositories containing evidence like \bpgxs\b matches.)
>>
>> Searching Github for repos with a *.control file in the root dir and a 
>> Makefile containing ^PGXS
> Interesting. What's an extension? It is something that contains user-defined
> objects. It would be good if your list was expanded to contain addons 
> (modules)
> that are basically plugins that don't create additional objects in the 
> database
> e.g. an output plugin or a module that uses any hooks (such as auth_delay).
> They generally don't provide control file (for example, wal2json). I 
> don't know
> if can only rely on PGXS check because there are client programs that 
> uses the
> PGXS infrastructure to build it.
> 
>> Hmm, now that you say it, maybe the ^PGXS regex should be 
>> case-insensitive,
>> if pgxs can be written in e.g. lower case?
> Makefile variable names are case-sensitive. You cannot write pgxs or 
> PgXs; it
> should be PGXS.


What about scanning for "PG_MODULE_MAGIC"?

Joe
-- 
Crunchy Data - http://crunchydata.com
PostgreSQL Support for Secure Enterprises
Consulting, Training, & Open Source Development



pgsql-hackers by date:

Previous
From: "Euler Taveira"
Date:
Subject: Re: List of all* PostgreSQL EXTENSIONs in the world
Next
From: Aleksander Alekseev
Date:
Subject: Re: List of all* PostgreSQL EXTENSIONs in the world