Skip to content

Instantly share code, notes, and snippets.

@selenamarie

selenamarie/schema liberation.md

Last active December 17, 2015 17:39
Show Gist options
  • Save selenamarie/5647554 to your computer and use it in GitHub Desktop.
Save selenamarie/5647554 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
schema liberation.md

Title: Schema liberation with JSON and PLV8

JSON is the lingua franca of the web. Postgres supports JSON natively and the PLV8 Javascript engine as an extension. Full Javascript is supported inside the database, including direct access to tables and important database features.

And, developer-friendly features make it incredibly easy to transform your existing, normalized schemas into liberated JSON ones!

Tour of what putting a document store inside of Postgres looks like, including a look at a production use-case from Mozilla. crash-stats.mozilla.com is backed by a 2 TB Postgres database cluster that's adding about about 5 GB of JSON per week.

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