PG Orbit

@pgorbit

Postgres in your pocket. A real PostgreSQL client for iOS, Android, Mac & Linux.

5432

Pinned
PG Orbit
@pgorbit
Nov 8
Now on Windows. That's every platform. 🪟 apps.microsoft.com/detail/9p5hmwz…
Adrian Rangel
@acrogenesis
Nov 8
PG Orbit is now on Windows 🪟 That makes every platform: iPhone, iPad, Android, Mac, Linux, and Windows. Your connections and saved queries sync across all of them. Free for read-only. Get it in the Microsoft Store 👇 pgorbit.com/windows
PG Orbit
@pgorbit
8h
MD5 or SCRAM-SHA-256 for password logins? The interesting answer is the oldest app you still run. Do you actually know which one it uses?
PG Orbit
@pgorbit
14h
PG Orbit opens an SSH tunnel to a bastion you can reach. The database can stay on a private port. Generate an RSA key on the device, or import RSA or Ed25519.
PG Orbit
@pgorbit
21h
PostgreSQL 19 RC adds pg_plan_advice to guide scan methods and join order. pg_stash_advice can apply saved advice when a query is planned again. Useful when the planner gets it wrong. Also a reason to retest when the data changes.
PG Orbit
@pgorbit
Nov 9
PostgreSQL 19 RC adds REPACK to reclaim space and optionally reorder a table by an index. CONCURRENTLY lets reads and writes continue during most of the work. The final swap still takes an ACCESS EXCLUSIVE lock. Test the lock wait on a copy first.

PG Orbit’s posts