Web-Scale PostgreSQL: The New JSONB Data Type and the Relational World

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 upcoming 9.4 release, PostgreSQL is introducing 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? Join Jonathan S. Katz as he takes a look at the new features surrounding JSONB and how web-scale PostgreSQL is.

About Jonathon:

Jonathan S. Katz is CTO of VenueBook (http://venuebook.com), one of the co-organizers of the New York City PostgreSQL User Group (http://www.nycpug.org), a Director of the United States PostgreSQL Association (http://www.postgresql.us), and co-chair of the PGConf NYC series (http://nyc.pgconf.us).

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 a B.S. in Computer Science and a B.A. in Mathematics.