Just Use Postgres All the database you need (Denis Magda) (Z-Library)

You probably don’t need a collection of specialty databases. Just use Postgres instead! Need a fast, reliable SQL-compliant RDBMS? Just use Postgres! Need to work with geospatial data? Just use Postgres! Handling semi- or non-structured documents? Just use Postgres! Generative AI embeddings? You’ve got it—just use Postgres! Written for software engineers and database pros, Just Use Postgres! shows you how to get the most out of the powerful PostgresSQL database. In Just Use Postgres! you’ll learn how to • Develop generative AI, geospatial, and time-series applications • Everything from transactional RDBMS services to specialized workloads • Modern SQL including window functions, CTEs, and JSON data • Implement full-text search • B-trees, GIN, HNSW, expression, and more • Postgres extensions Since its initial release in 1996, PostgreSQL, aka Postgres, has grown into the most popular and powerful full-featured open source RDBMS available. Just Use Postgres! takes a modern look at Postgres, exploring the database’s most up-to-date features for AI, time-series, full-text search, geospatial, and other application workloads. About the book Just Use Postgres! uses relevant concrete examples to show you how to interact with Postgres as a software developer. Each chapter focuses on a different use case, including an eCommerce application, a music streaming service, and other interesting challenges. You’ll explore the Postgres techniques, features, and capabilities you need to streamline each app’s unique data management issues. From fundamental RDBMS features to an ecosystem of extensions for generative AI and more, you’ll learn how to get the absolute best out of Postgres. What's inside • Generative AI, geospatial, and time-series applications • Modern SQL including window functions and CTEs • Full-text search and JSON • B-trees, GIN, GiST, HNSW, and more About the reader For software developers who know the basics of SQL and relational databases.