Paul Cantrell @inthehands@hachyderm.io
Public

Dang it, PostgreSQL is so good.

I did a data export thing. The options I needed were there. Then I needed more options, and then they were also there. They worked the way I guessed. It was fast. It was reliable. Then I thought “oh, what about sequences?!?”, but they already had that covered. My seemingly easy task turned out to be…easy.

Jenniferplusplus @jenniferplusplus@hachyderm.io
Public

@inthehandsPaul Cantrell there's a whole book about this phenomenon
manning.com/books/just-use-pos

The cover for Just Use Postgres!

Just Use Postgres! - Denis Magda

You probably don’t need a collection of specialty databases. Just use Postgres instead! Written for application developers and database pros, Just Use Postgres! shows you how to get the most out of the powerful Postgres database. In Just Use Postgres! you’ll learn how to: Use Postgres as an RDBMS for transactional workloads Develop generative AI, geospatial, and time-series applications Take advantage of modern SQL including window functions and CTEs Perform full-text search and process JSON documents Use Postgres as a message queue Optimize performance with various index types including B-trees, GIN, GiST, HNSW, and more Over the decades, PostgreSQL, aka Postgres, has grown into the most powerful general-purpose database and has become the de facto standard for developers worldwide. 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.

www.manning.com · Manning Publications

1
0
0

If you have a fediverse account, you can quote this note from your own instance. Search https://hachyderm.io/users/jenniferplusplus/statuses/115568885568095544 on your instance and quote it. (Note that quoting is not supported in Mastodon.)