Flexible Document Storage with Postgres | Bruce Momjian | Meetup Document Database Community

#postgresql has always had strong support for relational storage. However, there are many cases where relational storage is either inefficient or overly restrictive. Postgres is a flexible relational database, designed to be extensible from its inception. One aspect of this extensibility is document storage.

Postgres has many features designed to manage document data effortlessly, including full text search, #json , trigrams, and specialized indexing methods to allow efficient data access. This talk will cover all of these features.

Agenda:
✅ Why non-relational storage?
✅ XML: Storing and working with XML documents in Postgres.
✅ JSON: Native support for storing, querying, and manipulating JSON data in Postgres.
✅ JSONB: Taking JSON handling to the next level with binary JSON in Postgres.
✅ Character strings: Managing and optimizing document text data.
✅ Document-optimized indexing: Leveraging specialized indexing methods like trigrams, GIN, and GiST for efficient searching and retrieval.

About thе Speaker
BRUCE MOMJIAN - Vice President at EnterpriseDB

Bruce Momjian is co-founder and core team member of the PostgreSQL Global Development Group, and has worked on PostgreSQL since 1996. He has been employed by EDB since 2006. He has spoken at many international open-source conferences and is the author of PostgreSQL: Introduction and Concepts, published by Addison-Wesley. Prior to his involvement with PostgreSQL, Bruce worked as a consultant, developing custom database applications for some of the world’s largest law firms. As an academic, Bruce holds a Masters in Education, an honorary doctorate, was a high school computer science teacher, and lectures internationally.

00:00 Introduction
00:50 Agenda 📋
05:02 Relational Limitations
07:17 Loading XML Query
08:37 JSON Data Type
11:06 Efficiency of JSONB
14:20 Questions from Alexi
16:28 Optimising Character Strings
25:48 Non-B-Tree Index Types
33:23 Data Type Support for Index Types
38:48 Conclusion Q&A

What is #DocumentDatabaseCommunity ?
We are a global network of passionate developers who work in the NoSQL Document Database environment. We talk about technology challenges, assist in the emergence and development of techniques, and popularize solutions in the document database space, no matter whether they are open-source or proprietary. The goals of the DDC are to present new technologies, highlight alternatives and unite Document Database developers and users. We are just getting started but we have big plans for the future.

Connect with Us on Our Social Networks