Postgres management tools

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?