-
Book Overview & Buying
-
Table Of Contents
Full-Stack React, TypeScript, and Node - Second Edition
By :
PostgreSQL (often called "Postgres") is an open-source relational database whose roots go back to 1986, when it began as a research project at UC Berkeley, and it has been under continuous development ever since. It is used by companies like Apple, Instagram, Spotify, and Twitch, and it consistently ranks high in developer surveys. But popularity alone is not a good reason to choose something. So why PostgreSQL specifically?
PostgreSQL has a wide feature set. Beyond standard SQL, it supports JSON and JSONB columns for semi-structured data, full-text search, array columns, custom types, multiple index types for different query patterns, and an extension system that lets you add capabilities like PostGIS (geographic queries) or pgvector (AI embeddings).
It also has first-class support from Prisma and the broader TypeScript ecosystem. Every Prisma feature we will use in this chapter works fully with PostgreSQL, and many PostgreSQL-specific features (like native...
Change the font size
Change margin width
Change background colour