NoSQL Best Practices for PostgreSQL

Wednesday 3:20PM-4:10PM

@ Swift Suite 2

Open Source Databases

50 minutes conference

Intermediate

Tracks:
Security

Everyone already knows the Jsonb data type: one of PostgreSQL's most attractive features that allows efficient work with semi-structured data without sacrificing strong consistency and ability to use all the power of proven relational technology. But what exactly is inside Jsonb? Are there any caveats, and how can you accidentally bring down performance?

We will discuss all these questions together with advantages and disadvantages of using Jsonb in different situations in comparison with other solutions and existing standards. I'll show some important best practices about how to write compact queries to work with Jsonb, and avoid common mistakes/performance problems.


Speakers

Dmitry Dolgov

Dmitry Dolgov (Zalando SE)

Software Engineer

Biography:

Software engineer at Zalando SE. An author of PGXN extension jsonbx, involved in development and improvement of document-oriented features of PostgreSQL.


Slides



  Download Slides  

Percona Live

Stay Connected on:

Percona Live Conferences

The Percona Live Open Source Database Conferences are the premier event for the diverse and active open source database community, as well as businesses that develop and use open source database software.
 

Contact Us

For general information about the event/expo/conference, including registration, please contact us at:

  • info(@) percona.com
  • +1-888-401-3401
  • +1-919-948-2863
  • 8081 Arco Corporate Drive - Suite 330 - Raleigh, NC 27617, USA