Flexible Document Storage with Postgres | Bruce Momjian | Meetup Document Database Community скачать в хорошем качестве

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 Register for other #onlinemeetup https://documentdatabase.org 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. Subscribe to Document Database Community channel for new videos about document-oriented databases    / @docdatabasecom   Connect with Us on Our Social Networks Follow Open Source Renegades on Twitter:   / docdatabasecom   Follow Open Source Renegades on LinkedIn:   / docdatabasecom