PostgreSQL 艺术

Hacker News 上怎么说

• throwawake · 2021 年

  除了这里已经被推荐过的马丁·克莱普曼（Martin Kleppmann）的《设计数据密集型应用》（Designing Data-Intensive Applications），我的其他最爱是：- 布兰登·伯恩斯（Brendan Burns）的《设计分布式系统》（Designing Distributed Systems）- 迪米特里·方丹（Dimitri Fontaine）的《PostgreSQL 的艺术》（The Art of PostgreSQL）- 斯蒂芬·斯基耶纳（Steven S. Skiena）的《算法设计手册》（The Algorithm Design Manual）

  Apart from Designing Data-Intensive Applications by Martin Kleppmann, which is already suggested here, my other favorites are - - Designing Distributed Systems by Brendan Burns - The Art of PostgreSQL by Dimitri Fontaine - The Algorithm Design Manual by Steven S. Skiena

• dmfay · 2022 年

  ……先从逻辑和离散数学看起。Ralph Kimball 和 Margy Ross 的《The Data Warehouse Toolkit》——就算你做的是 OLTP 场景，了解数仓技术也很有用。Dmitri Fontaine 的《The Art of PostgreSQL》——用 cookbook（烹饪书）的形式讲现代 SQL，解释非常详尽。虽然不是书，但 Heinz Klein 和 Kalle Lyytinen 在《Software Development and Reality》里的论文《Towards a New Understanding of Data Modeling》……

  …starting with logic & discrete math Ralph Kimball and Margy Ross, The Data Warehouse Toolkit -- even if you're in an OLTP context, it's useful to know about warehousing techniques Dmitri Fontaine, The Art of PostgreSQL -- cookbook approach to modern SQL with plenty of explanations Not a book but Heinz Klein and Kalle Lyytinen's paper "Towards a New Understanding of Data Modeling" in the Software Development and Reality…

• blowski · 2021 年

  我最喜欢的学习 SQL 的书是《The Art of PostgreSQL》。https://theartofpostgresql.com/ 我发现这本书结合了现实世界的问题、通用的 SQL 建议以及广泛的主题，真的是一本非常好的书。它让我的 SQL 水平从“数据库不过是持久化应用程序数据的地方”提升到了“应用程序不过是将命令匹配到数据库的一种方式”。它

  My favorite book for learning SQL is “The Art of PostgreSQL”. https://theartofpostgresql.com/ I found the combination of real-world problems, general SQL advice, and the broad range of topics to be a really good book. It took my SQL from “the database is not much more than a place to persist application data” to “the application is not much more than a way to match commands to the database”. It’s

• purerandomness · 2019 年

  我觉得 Dimitri Fontaine 的 https://theartofpostgresql.com/ 挺高级的。从中学到了很多新技巧。

  I found Dimitri Fontaine's https://theartofpostgresql.com/ advanced. Learned lots of new tricks out of it.

• blowski · 2021 年

  我懂那种痛苦！我对 MySQL 太熟悉了，以至于使用不同的数据库感觉有风险，但如果我在一个不严肃的项目中使用它，我怎么能获得现实世界的经验呢？ 我从 Postgres 核心贡献者之一的一本书中学到了很多——https://theartofpostgresql.com/。它有实际现实世界的例子和真实的数据集可以实验。

  I feel that pain! I knew MySQL so well that it felt risky to use a different database, yet if I used it on a non-serious project, how would I get real-world experience? I learned a lot from a book from one of the core contributors to Postgres - https://theartofpostgresql.com/. It has actual real world examples with realistic datasets to experiment with.

• VWWHFSfQ · 2023 年

  我不知道算不算 _令人大开眼界_，但《The Art of PostgreSQL》确实让我的工作方式变得更好了。像很多人一样，我以前会把所有数据拉到 Python 里处理，Pandas 风格。一旦我学会了直接在 PG 里完成所有事情，一切都变得微不足道了。 [0] https://theartofpostgresql.com/

  I don't know about _eye opening_, but The Art of PostgreSQL really changed the way I work for the better. Like a lot of people, I used to be one that would pull all my data into Python for processing, Pandas-style. Once I learned how to do it all directly in PG everything became trivial. [0] https://theartofpostgresql.com/

正在加载完整评论……