Rails, Angular, Postgres, and Bootstrap

Unlocking More of Postgres’s Power

For most of my career, I viewed SQL databases as dumb stores for simplistic data. Postgres has shattered that view, and this section will do the same for you. We’ll talk about many advanced column types, like JSON, arrays, and enumerated types. We’ll then see that Postgres supports full-text search out of the box before finishing up with the most mundane yet frequently needed tasks: CSV export.

Modeling Your Data with Advanced Column Types

Most databases store numbers and strings. For storing more advanced structures, like arrays or maps, you typically have to create them using tables. Postgres provides more advanced types to avoid doing that, and they can be a huge time-saver. Let’s go over a few of them ...