how does dbdev compare to pgxn?

Open Beginner friendly
#56 2 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Assessment

Difficulty
1/5
Estimated time
1-3 hours
Newbie friendliness
68/100
Issue type
Documentation
Clarity
Clearly specified
Activity status
Quiet
Tech stack
postgresql
Domain
documentation

Research direction

Start with README.md and review the existing description of dbdev, then compare it with the issue's stated understanding of pgxn. Update the page to explain how the tools differ, which use cases each supports, and the relevant source, compilation, shell-access, and privilege expectations. Done means a PostgreSQL user can understand when to choose either tool.

Written by the indexing model from the issue text.

Description

documentation

Improve documentation by explaining the difference with pgxn.

Link

Page which needs improvement: README.md.

Describe the problem

When I hear npm for pg, I immediately think about pgxn. I think It'd be useful to explain how these tools differ, what different use case they help with.

Describe the improvement

From my perspective, pgxn seems oriented towards extensions, while dbdev is more about regular piece of sql? Pgxn ships source code and gives an easy way to compile them. You'd need a shell access to the machine, and probably be superuser. Dbdev seems to be usable by user with less privilege?

Dominant language
TypeScript
Stars
443
Forks
31
Avg merge
1h 12m
Merged PRs (30d)
10

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

More from supabase/dbdev

All issues in supabase/dbdev

Similar issues

More TypeScript issues

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.