pgxman – npm for Postgres extensions

Hacker News

pgxman is npm for Postgres extensions, simplifying the discovery and use of extensions so you can easily enhance your applications. Installing and updating Postgres extensions is an uphill battle. You're left searching for the right build tools and grappling with often unclear and incomplete compiling instructions to even try one out. But with pgxman, we've streamlined the process to one simple step: pgxman install [extension name]. For example, to build parquet_s3_fdw manually, you'd need to: 1. Download the parquet_s3_fdw source code; 2. Figure out how to build it by looking at README. When unclear, look at the source code how to build it. The README of parquet_s3_fdw says it needs libarrow, libparquet & aws_sdk. Readme doesn’t say where to get them. 3. Make sure all dependencies are available to build the project. Either install them from apt, if available, or build them manually if not. For parquet_s3_fdw aws_sdk has to be built manually — it’s not available in any apt repos 4. Build the extension targeting the correct OS, CPU architecture and Postgres version. 5. Determine and build to the right path /usr/lib/postgresql/15/lib - otherwise, Postgres wouldn’t be able to find them. 6. Repeat across all relevant Postgres instances. Hopefully, these Postgres versions are recent or else you’ll have to update postgres, set maintenance window, etc. * Added friction: Since parquet_s3_fdw is not designed to use in a cloud environment, and we forked it to make changes to make it possible to use. Using pgxman, you can just do: pgxman install s3_parquet_fdw pgxman integrates with your system package manager, ensuring the correct versions are installed without extra packages from any shared dependencies between extensions. pgxman’s automated build system creates [APT] packages for each Postgres version, platform, and OS supported by the extension. Extensions are built from a “buildkit” formula, written in YAML, and are contributed through GitHub. To install pgxman, you can do brew install pgxman/tap/pgxman or, if you don't mind pipe-to-shell, curl -sfl https://install.pgx.sh | sh - If you'd like to learn more, we have an extensive blog post here: https://www.hydra.so/blog-posts/the-design-of-postgres-exten... .

Visit product View on Hacker NewsNov 29, 2023

Share card

Actual performance

81points

21comments

Made the leaderboard

Launch Intel predictions

Analyze your own launch →

Indie HackersFits the IH revenue-focused audience · Missing: supports, reddit linkedin, podcasting

83%83% predicted probability of success on Indie Hackers, based on ML models trained on real launch data.

best fitHighest predicted score across all platforms for this description.

Product HuntOn track for Day 1 leaderboard · Strong signals: using, code · Missing: mac, agents, macos

79%79% predicted probability of success on Product Hunt, based on ML models trained on real launch data.

Hacker NewsStrong engagement from HN community · Strong signals: pipe, io · Missing: https docs, excited, just released

68%68% predicted probability of success on Hacker News, based on ML models trained on real launch data.

nativeThis product was originally launched on this platform.

AppSumoStrong fit for a featured deal · Strong signals: platform · Missing: plus, intuitive, reviews

59%59% predicted probability of success on AppSumo, based on ML models trained on real launch data.

TrustMRRLess likely to generate early MRR · Missing: mobile apps, ios, personal

34%34% predicted probability of success on TrustMRR, based on ML models trained on real launch data.

Acquire.comPre-revenue stage for this audience · Strong signals: arr · Missing: mrr, revenue, profit

11%11% predicted probability of success on Acquire.com, based on ML models trained on real launch data.

BetaListMay not resonate with beta-testers · Missing: web3, chat, crypto

0%0% predicted probability of success on BetaList, based on ML models trained on real launch data.

Correct prediction on native model

Similar products

Cookiecutter for Postgres Extensions51%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Cookiecutter for Postgres Extensions

Hacker News1

PgDog – Shard Postgres without extensions81%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

PgDog – Shard Postgres without extensions

Hacker News307

Dynamically loaded extensions in Postgres in the browser68%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Dynamically loaded extensions in Postgres in the browser

Hacker News9

Dynamically loaded extensions in Postgres in the browser66%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Dynamically loaded extensions in Postgres in the browser

Hacker News2

FOSS Okapi BM25 search for Postgres without extensions66%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

FOSS Okapi BM25 search for Postgres without extensions

Hacker News3

Scaling NPM in VMs with Npmserve53%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Scaling NPM in VMs with Npmserve

Hacker News49

Now supporting MySQL, Postgres, Redis, Mongo60%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Now supporting MySQL, Postgres, Redis, Mongo

Hacker News3

npm spaceship32%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

npm spaceship

Hacker News3

GraphQL for Postgres83%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

GraphQL for Postgres

Hacker News195

JQuery Guillotine on npm38%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

JQuery Guillotine on npm

Hacker News2

Browse all products Analyze your launch