PostgreSQL Maximalism - Extensions for Every Use Case - Part 4 скачать в хорошем качестве

PostgreSQL Maximalism - Extensions for Every Use Case - Part 4

Unlock the full power of PostgreSQL with cutting-edge extensions built for the modern data stack. This series covers everything from document stores, to high-performance analytics using columnar backends and open table formats, to seamless integration with large language models via external tools like Ollama—all tightly integrated into your database workflows. ► In part 1, we cover the full list of identified use cases, and present the GitHub repo that we created, and our general approach to testing the extensions. ► In part 2, we cover documents storage and how to use open table formats to support your analytics tasks directly on Postgres. ► In part 3, we cover time series, with a cool example based on anomaly detection, and we also vectors & AI, with another fun example based on movie recommendation. ► In part 4, we cover full-text search and string similarity, graph analytics, and message queues. I hope you enjoy this series! If have you have any questions or suggestions, please comment below. 🔗 Resources: 💻 GitHub repo: https://github.com/DataLabTechTV/post... 📝 Blog post: https://datalabtechtv.com/posts/postg... 📺 Watch the full PostgreSQL series here ►    • PostgreSQL Maximalism - Extensions for Eve...   🔔 Subscribe for more deep dives data science, data engineering, and all things data! ☁️ Follow the channel on Bluesky: https://bsky.app/profile/datalabtecht... 🎧 Join our community's Discord:   / discord   👽 Join our subreddit:   / datalabtechtv   💻 Check out the channel's GitHub: https://github.com/DataLabTechTV 🌐 Visit our website for unedited research notes: https://datalabtechtv.com #dataengineering #databases #postgres #extensions 00:00:00 Intro 00:00:43 Search Extensions 00:03:50 Search Demo 00:04:40 Built-In Full-Text Search 00:09:42 pg_search (ParadeDB) 00:19:32 Graph Extensions 00:22:01 Graphs Demo 00:26:54 Nested String Quotes 00:28:30 Graphs Demo 00:31:42 Small World Test 00:32:04 Avg. Shortest Path 00:35:10 Clustering Coefficient 00:38:53 Is it a small world? 00:40:55 Null Model Computation 00:42:22 Small World Decision 00:43:39 Message Queue Extensions 00:45:26 Message Queue Libraries 00:47:43 Message Queues SQL Demo 00:55:31 Message Queues Python Demo 00:58:18 Pros and Cons 01:01:26 PIGSTY 01:02:37 Outro