There are cases when classical relational structures are not enough. In Chapter 9, Beyond Conventional Data Types, we explain how to make a PostgreSQL database multidimensional via use of arrays, and how to use the features that are usually offered by NoSQL databases, such as storing and indexing JSON data. In this chapter, we talked about the PostgreSQL full-text search—a powerful feature often used by web applications.
Still, PostgreSQL is a relational database. It's designed to work with relations and relationships. These NoSQL features are provided on top of the relational basement. For this reason, PostgreSQL cannot be a perfect choice as a storage component for data that is not relational in nature. A developer working ...
