PostgreSQL is much more than a place to store neat rows and columns. This module explores three features that make it flexible enough to handle semi-structured data, search text, and even take on jobs normally left to separate systems.
You'll start with JSONB, PostgreSQL's binary JSON type, and learn to store JSON documents and pull values out of them with SQL. Next comes full-text search, using tsvector and tsquery to search large amounts of text far better than a simple LIKE can. Finally, you'll see how extensions such as pgvector add whole new capabilities with a single CREATE EXTENSION command.
After that, you'll be ready for the next module, Views, Functions & Triggers, where you package logic inside the database itself.
Understand what JSONB is and how to insert JSON objects into a PostgreSQL table. Follow along in your own database and try each step.
If you have JSON or JSONB data in PostgreSQL, this video shows the different methods for pulling values out of it with SQL.
Explore PostgreSQL full-text search, including the tsvector and tsquery data types, indexing text documents, and building search on top of them.
See how a PostgreSQL extension, pgvector, turns the database into a vector database. It is a practical example of how extensions add new abilities.