PG Orbit
PG Orbit is a PostgreSQL client for your desktop and your phone. Browse databases, schemas, and tables, run SQL with highlighting and autocomplete, and edit rows in place.
- Schema browser for tables, views, materialized views, functions, and sequences
- SQL editor with syntax highlighting, autocomplete, query parameters, history, and saved queries
- Results grid with filtering, sorting, inline editing, and CSV export
- Connections over SSL, SSH tunnels, and Kubernetes port forwarding
- Passwords and SSH keys stay in your system keyring
- On Omarchy, the app follows your desktop theme and changes with it
Browsing and read-only queries are free. Premium, a one-time purchase, unlocks writes, table design, and CSV export. An optional subscription syncs connections and saved queries across your devices.
Compatibility: Uses the C library of the system (may need glibc 2.34 or later)
GitHub Download PG_Orbit Website PG_Orbit Help
Usage
PG_Orbit is available as an AppImage which means "one app = one file", which you can download and run on your Linux system while you don't need a package manager and nothing gets changed in your system. Awesome!
AppImages are single-file applications that run on most Linux distributions. Download an application, make it executable, and run! No need to install. No system libraries or system preferences are altered. Most AppImages run on recent versions of Arch Linux, CentOS, Debian, Fedora, openSUSE, Red Hat, Ubuntu, and other common desktop distributions.
This AppImage uses the C library of the system and may need glibc 2.34 or later. It does not run on distributions that use a different C library (such as musl on Alpine Linux) or an older glibc.
Running PG_Orbit on Linux without installation
Unlike other applications, AppImages do not need to be installed before they can be used. However, they need to be marked as executable before they can be run. This is a Linux security feature.Beware! AppImages are usually not verified by others. Follow these instructions only if you trust the developer of the software. Use at your own risk!
Download the PG_Orbit AppImage and make it executable using your file manager or by entering the following commands in a terminal:
chmod +x ./*.AppImageThen double-click the AppImage in the file manager to open it.
Sandboxing PG_Orbit
If you want to restrict what PG_Orbit can do on your system, you can run the AppImage in a sandbox like Firejail. This is entirely optional and currently needs to be configured by the user.
Updating PG_Orbit
If you would like to update to a new version, simply download the new PG_Orbit AppImage.
Integrating AppImages into the system
If you would like to have the executable bit set automatically, and would like to see PG_Orbit and other AppImages integrated into the system (menus, icons, file type associations, etc.), then you may want to check the optional appimaged daemon.
Note for application authors
Thanks for distributing PG_Orbit in the AppImage format for all common Linux distributions. Great! Here are some ideas on how to make it even better.
Pro Tips for further enhancing the PG_Orbit AppImage
Please consider to add update information to the PG_Orbit AppImage and ship a .zsync file so that it can be updated using AppImageUpdate. Tools like appimagetool and linuxdeployqt can do this for you easily.
Please consider making the PG_Orbit AppImage self-contained, so that it does not depend on the C library of the system and runs on more distributions: ship the C library including its loader (ld-linux-*.so.*) and use it to launch the application, or link statically.
Thanks for shipping AppStream metainfo inside your AppImage. Please open a pull request on https://github.com/AppImage/appimage.github.io/blob/master/data/PG_Orbit if you have changed it and would like to see this page updated accordingly.
If you would like to see a donation link for the application here, please include one in the AppStream data.