Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add psql and pgcli to ov tooling #4637

Open
AetherUnbound opened this issue Jul 19, 2024 · 2 comments
Open

Add psql and pgcli to ov tooling #4637

AetherUnbound opened this issue Jul 19, 2024 · 2 comments
Labels
🤖 aspect: dx Concerns developers' experience with the codebase ✨ goal: improvement Improvement to an existing user-facing feature good first issue New-contributor friendly help wanted Open to participation from the community 🟩 priority: low Low priority and doesn't need to be rushed 🧱 stack: mgmt Related to repo management and automations 🐳 tech: docker Involves Docker 💾 tech: postgres Involves PostgreSQL

Comments

@AetherUnbound
Copy link
Contributor

AetherUnbound commented Jul 19, 2024

Description

We recently encountered a case where it would be useful to have psql and pgcli available in the ov environment for interacting with the stack. It seems like the perfect candidate to add to the list of tooling available in ov!

We'll need to touch the following places for this:

  1. Adding whatever's necessary to install for the psql utility and pipx to the Docker image

&& dnf -y install \
git \
g++ \
just \
jq \
which \
nodejs npm \
python3.12 pipx \
docker-ce docker-ce-cli containerd.io docker-buildx-plugin docker-compose-plugin \
unzip \

  1. Adding psql (or the dependency involved) to the list of dependency explanations

# Dependency explanations:

  1. Adding pgcli to the list of pipx dependencies:

# pipx dependencies:

  1. Adding documentation for it to the included tools

### Included tools
The containerised `ov` environment includes some excellent general purpose tools
to interact with Openverse's development environment. Here are some important
ones you might see used throughout the documentation:

Additional context

Initially came up here: #4610 (review)

@AetherUnbound AetherUnbound added good first issue New-contributor friendly help wanted Open to participation from the community ✨ goal: improvement Improvement to an existing user-facing feature 🐳 tech: docker Involves Docker 💾 tech: postgres Involves PostgreSQL 🟩 priority: low Low priority and doesn't need to be rushed 🤖 aspect: dx Concerns developers' experience with the codebase 🧱 stack: mgmt Related to repo management and automations labels Jul 19, 2024
@dhruvkb
Copy link
Member

dhruvkb commented Jul 20, 2024

Would pgcli be a better alternative? It might also be easier to install via pipx.

@AetherUnbound
Copy link
Contributor Author

Yea that works! We'll still need to have the libraries required for psql, per the install documentation:

Pgcli uses psycopg to talk to postgres database. In order to install psycopg, you will need libpq and python-dev installed on your system. Since psycopg is a C extension for Python, a C compiler is needed to install it on your system.

@AetherUnbound AetherUnbound changed the title Add psql to ov tooling Add psql and pgcli to ov tooling Jul 22, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
🤖 aspect: dx Concerns developers' experience with the codebase ✨ goal: improvement Improvement to an existing user-facing feature good first issue New-contributor friendly help wanted Open to participation from the community 🟩 priority: low Low priority and doesn't need to be rushed 🧱 stack: mgmt Related to repo management and automations 🐳 tech: docker Involves Docker 💾 tech: postgres Involves PostgreSQL
Projects
Status: 📋 Backlog
Development

No branches or pull requests

2 participants