PostgreSQL-Browser

A PostgreSQL Browser, similar to SQLiteBrowser with far less features (for now).

Installation

# Append --force to update
pipx install "git+https://github.com/RyanGreenup/PostgreSQL-Browser"

Usage

For testing purposes, consider the attached docker-compose.yml file to spin up a PostgreSQL instance.

cd $(mktemp -d)
git clone https://github.com/RyanGreenup/PostgreSQL-Browser"
cd PostgreSQL-Browser
docker-compose up -d
docker-compose logs -f
# C-c
curl https://github.com/lerocha/chinook-database/releases/download/v1.4.5/Chinook_PostgreSql.sql > Chinook_PostgreSql.sql
PGPASSWORD=postgres psql -h localhost -p 5432 -U postgres -f ~/Downloads/Chinook_PostgreSql.sql

pg_browser postgres --host localhost --password postgres --username postgres --port 5432

Motivation

I wanted to browse my linkwarden database, and I didn't want to use the command line, now I can simply:

alias lw_db="pg_browser  --host localhost --password ${LW_DB_PASS} --username postgres --port 37194"
lw_db

I was also hoping to move my notetaking app to PostgreSQL, and I wanted a simple way to browse the database.

Usage

Importing Parquets

Import a directory of parquets into a PostgreSQL database by pointing to a directory, all parquet files will be read into a new database with the same table names as the files.