Created
March 1, 2013 18:12
-
-
Save gthomas/5066574 to your computer and use it in GitHub Desktop.
Postgres: The Bits You Haven't Found notes from Waza 2013
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Postgres: The Bits you haven't found | |
| ==================================== | |
| Postgres has a ton of really great features that you _probably_ don't know about yet. | |
| Peter van Hardenberg works on Heroku Postgres and has used a lot of them. | |
| You can get the slides here, along with links to further reading on each feature: | |
| http://postgres-bits.herokuapp.com/ | |
| Among the more mindblowing features were: | |
| * LISTEN/NOTIFY | |
| ** You can send pubsub style broadcasts from Postgres | |
| ** I found an example implementation here https://gist.github.com/fcurella/3490031 | |
| * REGEX | |
| ** Postgres has first-class regex support, so you're not just stuck with LIKE anymore | |
| ** You can even split text into a new table. WHOA! | |
| My wild, unedited notes are here: https://gist.github.com/gthomas/5066558 | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Nice: Postgres has first-class regex support