tapoueh
tapoueh on Hacker News
Posted by
tapoueh on Tuesday February 02, 2021 @04:10PM
from the info.crunchydata.com dept.
Posted by
tapoueh on Thursday September 27, 2018 @01:43PM
from the citusdata.com dept.
Posted by
tapoueh on Tuesday December 05, 2017 @11:35AM
from the julien.danjou.info dept.
The payment forms were in HTTPS from the beginning, but the webpages (hosted at GitHub Pages). Now it's all HTTPS with a proper domain certificate, thanks to CloudFlare. Enjoy!
That's a good idea, unfortunately the providers don't know each other and don't make it as easy as it sounds. Given interest into that, I will see about making something happen, if possible. Thanks!
You know what? Just buy the book and if you don't like it, tell me. I'll refund you. My guess is that you will like it ;-)
Went to fast and fat-fingered it. Works now!
The book covers some theory when it's needed and comes with lots of practical examples, all using real world data sets to make them easier to understand and relate to.
Using an ORM and how to best integrate “raw SQL” in your code is also discussed, and data modelling gets its own chapter too. I think you will like it!
Fixed now. I really should have had my reviewer work on the website too, not just the book itself. Thanks guys!
The book contains references for every data source it uses, all of them are available as Open Data. So you can load all the data, and copy/paste all the SQL queries with just the Book Edition.
The Full Edition isn't so much about the code contained in the book (SQL queries) as it is about having the very database used in the book handy to replay the queries.
I understand that the Full Edition doesn't make the same value for everyone, and it's fine. That's why it's not the only option. Given how many are sold compared to the other options, I'm confident it still is a solid option though.
The e-mail address is easily found in the paperback version, and I just added it to the FAQ as well, thanks for reporting the bug!
Yes the book targets more the SQL beginners, which are in my experience developers of all levels, from beginners to experts.
The title is inspired to a great deal by an idea of how to best learn new things, which is very nicely covered in the following Ted Talk: https://www.ted.com/talks/sal_khan_let_s_teach_for_mastery_n...
Mastering PostgreSQL in Application Development is meant to target any development environment, yet it does target some ecosystems: Python, PHP, Java and Go receive a special treatment, and I must confess Python is covered way more than the other choices.
The book definitely go into advanced usage. If you're already fluent in LATERAL joins, GROUPING SETS, Arrays, and JSON techniques, you might get bored to some degree.
Every single chapter has some beginner, then intermediate, then advanced topics covered, so I think everybody should have some of the right content, really. I tried and paid attention!
No, I don't address that point in this book.
It gives you plenty SQL techniques to avoid ever having to LOOP in a PL/pgSQL function, and show how to use PL/SQL rather than PL/pgSQL each time it is possible, though.