- This event has passed.
Flexible Document Storage with Postgres
28 June 2023 : 5:00 pm - 6:00 pm
Postgres 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.
This webinar will cover a new topic (from Bruce Momjian) exclusively for our subscribers. Don’t miss this opportunity to enhance your knowledge of Postgres and discover its powerful capabilities for document management 💡
❗ Also, webinar recording will only be available for registered users, so be sure to register – it takes less than a minute.