喜欢这篇内容的人大概也会喜欢 Joe Celko 的《SQL for Smarties》(智能时代的 SQL / SQL 编程艺术)。ISBN: 0123693799。遗憾的是,许多新手程序员过度依赖框架自带的 ORM 来把 SQL 抽象屏蔽掉,反而削弱了他们对 SQL 的理解。
Fans of this will probably also like Joe Celko's SQL for Smarties. ISBN: 0123693799 It's unfortunate that a lot of new programmers are relying on their framework's ORM to abstract the SQL away from them, weakening their understanding of it.
…people admittedly may have little experience with Hadoop or other non-relational processing and storage, sounds like some HN folks have actually had little experience with the SQL they are disparaging. Joe Celko's SQL for Smarties is full of great explanations of how to really use SQL, and is worth picking up if you want to see what SQL can really do and work around it's (many) warts. http://www.amazon.com/Joe-Celkos-SQL-Smarties-Programming/dp...
……Windows 那套环境。以后有需要再去碰 MySQL 吧。自从被 Oracle 收购后,它在一些圈子里已经失宠了,而且功能确实没有 PostgreSQL 强大,虽然也能应付差事。另外去买一本《Joe Celko's SQL for Smarties》[1](以及他写的所有关于 SQL 的书……),去真正搞懂 SQL 和 DDL 的本质,以及到底该如何正确进行数据建模。在开始折腾像 Rails Active 这种 ORM 之前,先学点 SQL 和 DDL 吧……
…Windows land. MySQL later if you have to. It's fallen out of favor in some communities since Oracle bought it and it's just not as powerful as PostgreSQL though it does the job. Also go buy the book "Joe Celko's SQL for Smarties" [1] (And everything else he wrote on SQL...) and actually learn what SQL and DDL is really all about how to properly model data. Lean some SQL and DDL before you start messing with ORMs like Rails Active…
(先声明:我有超过十年的 SQL 开发经验)我想推荐 Joe Celko 先生的《SQL for Smarties》(以及他写过的几乎所有东西,大家可以搜他当参考)……我曾有幸和 Celko 先生交流过,当时我问他心目中最好的数据库书籍是哪本,他补充道……
(disclamer: I have more than a decade experiences in doing SQL) I would say Mr. Joe Celko's "SQL for smarties" (and basically anything he has written (look him up for references).... I have had the opportunity to talk to mr. Celko, and he added (as I asked him what he thought was the best database-book) the…
……平台。《Optimizing Oracle Performance》https://books.google.com/books?id=D7ElCwAAQBAJ&printsec=fron... 另一本解释分析和解决性能问题全过程的好书。Joe Celko 的《SQL For Smarties》https://books.google.com/books?id=i-19BAAAQBAJ&printsec=fron... 每一个写 SQL 的人都该读读 Joe 的书。
…platform. Optimizing Oracle Performance https://books.google.com/books?id=D7ElCwAAQBAJ&printsec=fron... Another great book that explains the process of approaching and solving performance problems. Joe Celko's SQL For Smarties https://books.google.com/books?id=i-19BAAAQBAJ&printsec=fron... Everyone writing SQL should read Joe.
喜欢这篇内容的人大概也会喜欢 Joe Celko 的《SQL for Smarties》(智能时代的 SQL / SQL 编程艺术)。ISBN: 0123693799。遗憾的是,许多新手程序员过度依赖框架自带的 ORM 来把 SQL 抽象屏蔽掉,反而削弱了他们对 SQL 的理解。
Fans of this will probably also like Joe Celko's SQL for Smarties. ISBN: 0123693799 It's unfortunate that a lot of new programmers are relying on their framework's ORM to abstract the SQL away from them, weakening their understanding of it.
……虽然有人承认自己可能对 Hadoop 或其他非关系型数据处理与存储缺乏经验,但听起来某些 HN 网友对自己贬低的 SQL 实际上也没多少实际经验。Joe Celko 的《SQL for Smarties》里充满了关于如何真正用好 SQL 的精彩讲解;如果你想见识 SQL 的真正威力并绕过它(诸多)坑点的话,非常值得一读。http://www.amazon.com/Joe-Celkos-SQL-Smarties-Programming/dp...
…people admittedly may have little experience with Hadoop or other non-relational processing and storage, sounds like some HN folks have actually had little experience with the SQL they are disparaging. Joe Celko's SQL for Smarties is full of great explanations of how to really use SQL, and is worth picking up if you want to see what SQL can really do and work around it's (many) warts. http://www.amazon.com/Joe-Celkos-SQL-Smarties-Programming/dp...
……Windows 那套环境。以后有需要再去碰 MySQL 吧。自从被 Oracle 收购后,它在一些圈子里已经失宠了,而且功能确实没有 PostgreSQL 强大,虽然也能应付差事。另外去买一本《Joe Celko's SQL for Smarties》[1](以及他写的所有关于 SQL 的书……),去真正搞懂 SQL 和 DDL 的本质,以及到底该如何正确进行数据建模。在开始折腾像 Rails Active 这种 ORM 之前,先学点 SQL 和 DDL 吧……
…Windows land. MySQL later if you have to. It's fallen out of favor in some communities since Oracle bought it and it's just not as powerful as PostgreSQL though it does the job. Also go buy the book "Joe Celko's SQL for Smarties" [1] (And everything else he wrote on SQL...) and actually learn what SQL and DDL is really all about how to properly model data. Lean some SQL and DDL before you start messing with ORMs like Rails Active…
Joe Celko 的《SQL for Smarties》。塔夫特的《定量信息的视觉展示》。唐纳德·诺曼的《设计心理学(身边物件的设计)》。
Joe Celko's SQL for Smarties. Tufte's Visual Display of Quantitive Information. Donald Norman's Design of Everyday Things.
(先声明:我有超过十年的 SQL 开发经验)我想推荐 Joe Celko 先生的《SQL for Smarties》(以及他写过的几乎所有东西,大家可以搜他当参考)……我曾有幸和 Celko 先生交流过,当时我问他心目中最好的数据库书籍是哪本,他补充道……
(disclamer: I have more than a decade experiences in doing SQL) I would say Mr. Joe Celko's "SQL for smarties" (and basically anything he has written (look him up for references).... I have had the opportunity to talk to mr. Celko, and he added (as I asked him what he thought was the best database-book) the…
……平台。《Optimizing Oracle Performance》https://books.google.com/books?id=D7ElCwAAQBAJ&printsec=fron... 另一本解释分析和解决性能问题全过程的好书。Joe Celko 的《SQL For Smarties》https://books.google.com/books?id=i-19BAAAQBAJ&printsec=fron... 每一个写 SQL 的人都该读读 Joe 的书。
…platform. Optimizing Oracle Performance https://books.google.com/books?id=D7ElCwAAQBAJ&printsec=fron... Another great book that explains the process of approaching and solving performance problems. Joe Celko's SQL For Smarties https://books.google.com/books?id=i-19BAAAQBAJ&printsec=fron... Everyone writing SQL should read Joe.