benschwarz/pg.md

Last active October 16, 2024 23:15

Star (42) You must be signed in to star a gist
Fork (5) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/benschwarz/c3dbd73c4cf7d763fba3d5b3564e790c.js"></script>
Save benschwarz/c3dbd73c4cf7d763fba3d5b3564e790c to your computer and use it in GitHub Desktop.

Download ZIP

Awesome postgres

Raw

pg.md

Apps

Postico client for mac
pgcli - Postgres CLI with autocompletion and syntax highlighting
pghero - Server and query performance dashboard

Tools

PEV - Query planning / Explain analyze visualisation
PostgreSQL's explain analyze made readable

Tutorials and Guides

Articles

Anything by Craig Kerstiens, Postgres guide by Craig
Unique partial indexes used for a toggle button
The FILTER clause
Citus Data's blog is full of gold
Hash rocket's postgresql section is golden
Bones Moses

More as I find things…

97-109-107 commented Feb 9, 2017

Easy postgres codebase injection - aka postgres non data live reload - https://github.com/oelmekki/pgrebase

gane5h commented Feb 11, 2017

Advanced SQL Recipes: http://silota.com/docs/recipes/

jstn commented Feb 21, 2017

As a newcomer, this PGCon presentation on overlooked data types was super valuable: https://www.youtube.com/watch?v=BLX8N3HB8sQ

I nearly used the money type : O

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment