Re: List of all* PostgreSQL EXTENSIONs in the world

2022-02-23 Thread Joel Jacobson
On Wed, Feb 23, 2022, at 15:23, Andrew Dunstan wrote: > Yeah, I have several others on bitbucket that might be of interest (in > varying states of doneness): Thanks, added. /Joel

Re: List of all* PostgreSQL EXTENSIONs in the world

2022-02-23 Thread Joe Conway
On 2/23/22 09:52, Aleksander Alekseev wrote: > What about scanning for "PG_MODULE_MAGIC"? An extension can be written without using C at all. BTW some extensions [1] are written in Rust these days. Sure, but scanning for PG_MODULE_MAGIC may well pick up repos that would otherwise have been

Re: List of all* PostgreSQL EXTENSIONs in the world

2022-02-23 Thread Aleksander Alekseev
Hi Joe, > What about scanning for "PG_MODULE_MAGIC"? An extension can be written without using C at all. BTW some extensions [1] are written in Rust these days. [1]: https://github.com/timescale/timescaledb-toolkit -- Best regards, Aleksander Alekseev

Re: List of all* PostgreSQL EXTENSIONs in the world

2022-02-23 Thread Joe Conway
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 re

Re: List of all* PostgreSQL EXTENSIONs in the world

2022-02-23 Thread Euler Taveira
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

Re: List of all* PostgreSQL EXTENSIONs in the world

2022-02-23 Thread Andrew Dunstan
On 2/23/22 03:52, Joel Jacobson wrote: > >> (e.g. I see three >> instances of >> blackhole_fdw listed, but not the original repo, which is not even on >> GitHub) etc.. > Thanks, I've fixed blackhole_fdw manually: > > - https://bitbucket.org/adunstan/blackhole_fdw > - https://github.com/chenqu

Re: List of all* PostgreSQL EXTENSIONs in the world

2022-02-23 Thread Joel Jacobson
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 Hmm, now that you say

Re: List of all* PostgreSQL EXTENSIONs in the world

2022-02-23 Thread Joel Jacobson
On Fri, Feb 11, 2022, at 01:22, Ian Lawrence Barwick wrote: > More precisely it's a list of all? the repositories with PostgreSQL > extensions on > GitHub? Yes, the ambition is to list all repos at GitHub, and to manually add repos hosted at GitLab and other places. > OTOH not everything is on G

Re: List of all* PostgreSQL EXTENSIONs in the world

2022-02-23 Thread Joel Jacobson
On Tue, Feb 22, 2022, at 09:13, Aleksander Alekseev wrote: > Hi Joel, > >> I've compiled a list of all* PostgreSQL EXTENSIONs in the world: > > The list is great. Thanks for doing this! Glad to hear! > Just curious, is it a one-time experiment or you are going to keep the > list in an actual stat

Re: List of all* PostgreSQL EXTENSIONs in the world

2022-02-22 Thread Aleksander Alekseev
Hi Joel, > I've compiled a list of all* PostgreSQL EXTENSIONs in the world: The list is great. Thanks for doing this! Just curious, is it a one-time experiment or you are going to keep the list in an actual state similarly to awesome-* lists on GitHub, or ... ? -- Best regards, Aleksander Alek

Re: List of all* PostgreSQL EXTENSIONs in the world

2022-02-21 Thread Joel Jacobson
On Mon, Feb 21, 2022, at 21:16, Joel Jacobson wrote: > As a first attempt, I've added the description from the Github-repos, and two > categories to start the discussion: > > - Uncategorized > - Foreign Data Wrappers Some more categories added: - Access Methods - Aggregate Functions - Data Types

Re: List of all* PostgreSQL EXTENSIONs in the world

2022-02-21 Thread Joel Jacobson
On Thu, Feb 10, 2022, at 21:35, Robert Haas wrote: > I think a list like this is probably not useful without at least a > brief description of each one, and maybe some attempt at > categorization. +1 As a first attempt, I've added the description from the Github-repos, and two categories to star

Re: List of all* PostgreSQL EXTENSIONs in the world

2022-02-10 Thread Noah Misch
On Thu, Feb 10, 2022 at 04:04:17PM -0500, Joe Conway wrote: > On 2/10/22 15:35, Robert Haas wrote: > >On Thu, Feb 10, 2022 at 3:19 PM Joel Jacobson wrote: > >>I've compiled a list of all* PostgreSQL EXTENSIONs in the world: > >> > >>https://gist.github.com/joelonsql/e5aa27f8cc9bd22b8999b7de8aee9d4

Re: List of all* PostgreSQL EXTENSIONs in the world

2022-02-10 Thread Julien Rouhaud
Hi, On Fri, Feb 11, 2022 at 09:22:01AM +0900, Ian Lawrence Barwick wrote: > 2022年2月11日(金) 5:19 Joel Jacobson : > > > > Hi hackers, > > > > I've compiled a list of all* PostgreSQL EXTENSIONs in the world: > > > > https://gist.github.com/joelonsql/e5aa27f8cc9bd22b8999b7de8aee9d47 > > > > *) It's not

Re: List of all* PostgreSQL EXTENSIONs in the world

2022-02-10 Thread Ian Lawrence Barwick
2022年2月11日(金) 5:19 Joel Jacobson : > > Hi hackers, > > I've compiled a list of all* PostgreSQL EXTENSIONs in the world: > > https://gist.github.com/joelonsql/e5aa27f8cc9bd22b8999b7de8aee9d47 > > *) It's not all, but 1041, compared to the 338 found on PGXN. More precisely it's a list of all? the re

Re: List of all* PostgreSQL EXTENSIONs in the world

2022-02-10 Thread Joe Conway
On 2/10/22 15:35, Robert Haas wrote: On Thu, Feb 10, 2022 at 3:19 PM Joel Jacobson wrote: I've compiled a list of all* PostgreSQL EXTENSIONs in the world: https://gist.github.com/joelonsql/e5aa27f8cc9bd22b8999b7de8aee9d47 *) It's not all, but 1041, compared to the 338 found on PGXN. Maybe it

Re: List of all* PostgreSQL EXTENSIONs in the world

2022-02-10 Thread Robert Haas
On Thu, Feb 10, 2022 at 3:19 PM Joel Jacobson wrote: > I've compiled a list of all* PostgreSQL EXTENSIONs in the world: > > https://gist.github.com/joelonsql/e5aa27f8cc9bd22b8999b7de8aee9d47 > > *) It's not all, but 1041, compared to the 338 found on PGXN. > > Maybe it would be an idea to provide