Title: Web-Scale PostgreSQL: The Best of the JSON and Relational Worlds

 

Description:

All data is relational and can be represented through relational algebra, right?  Perhaps, but there are other ways to represent data, and the PostgreSQL team continues to work on making it easier and more efficient to do so!

 

With the 9.4 release, PostgreSQL is introduced the "JSONB" data type which allows for fast, compressed, storage of JSON formatted data, and for quick retrieval.  And JSONB comes with all the benefits of PostgreSQL, like its data durability, MVCC, and of course, access to all the other data types and features in PostgreSQL.

 

How fast is JSONB?  How do we access data stored with this type?  What can it do with the rest of PostgreSQL?  What can't it do?  What other nonrelational data types does PostgreSQL employ?

 

We will take a look at the features surrounding JSONB and see how web-scale PostgreSQL is.

 

[Note: This will be an adaptation of a previously given version of this talk - http://www.slideshare.net/jkatz05/webscale-postgresql-jsonb]

 

Bio:

Jonathan S. Katz is CTO of VenueBook, one of the co-organizers of the New York City PostgreSQL User Group, a Director of the United States PostgreSQL Association, and co-chair of the PGConf US series. In addition to advocacy for the PostgreSQL community, he focuses on building data-driven web applications from all parts of the software-cycle, though he tends to work on architecting and implementing the data-related features from a management and analytical standpoint. Jonathan has used PostgreSQL as his primary database software since 2003 and tries to help developers better leverage the features available in PostgreSQL. Jonathan graduated from Tufts University with degrees in Computer Science and Mathematics.

 

References: Provided in the bio attached to the account as the Mollom "spam blocker" is blocking me.