Skip to content

Instantly share code, notes, and snippets.

@jczaplew

jczaplew/readme.md

Last active August 29, 2015 14:16
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jczaplew/55acfcdbf569e0885527 to your computer and use it in GitHub Desktop.
Save jczaplew/55acfcdbf569e0885527 to your computer and use it in GitHub Desktop.
Download ZIP
Postgres management tools
Raw
readme.md

Follow up on https://twitter.com/johnjcz/status/570227819709493249

Overall both are great, but have different deficiencies

pgweb

Pros:

  • Fast
  • Hackable
  • Free
  • Keyboard shortcuts

Cons:

  • Doesn't show schemas other than public
  • Requires starting a web server
  • Can't cancel queries
  • No query stats (row count, execution time, etc...)
  • Switching databases requires creating a new connection

Postico

Pros:

  • Fast
  • Native OS X app
  • Keyboard shortcuts

Cons:

  • Doesn't show indexes
  • Not free (but only $40)
  • Has bug where sometimes highlighting text in query throws error
  • No syntax highlighting?
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment