HNHacker News
TopNewBestAskShowJobs

tapoueh

27 karma · joined November 6, 2017

Author of Mastering PostgreSQL in Application Development, see https://masteringpostgresql.com.

[ my public key: https://keybase.io/dimitri; my proof: https://keybase.io/dimitri/sigs/qBZ9xN7HIF69c-DpAjyscCnxzC1RdD4_3bpiHS6Mlo0 ]

submissionscomments
tapoueh··on Mastering PostgreSQL in Application Development
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!
tapoueh··on Mastering PostgreSQL in Application Development
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!
tapoueh··on Mastering PostgreSQL in Application Development
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 ;-)
tapoueh··on Mastering PostgreSQL in Application Development
Went to fast and fat-fingered it. Works now!
tapoueh··on Mastering PostgreSQL in Application Development
Fixed now!
tapoueh··on Mastering PostgreSQL in Application Development
I've setup an Offer Code for the next 48h guys. Feel free to use it! http://masteringpostgresql.com/#packages
tapoueh··on Mastering PostgreSQL in Application Development
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!

tapoueh··on Mastering PostgreSQL in Application Development
Fixed now. I really should have had my reviewer work on the website too, not just the book itself. Thanks guys!
tapoueh··on Mastering PostgreSQL in Application Development
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.

tapoueh··on Mastering PostgreSQL in Application Development
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!
tapoueh··on Mastering PostgreSQL in Application Development
Thanks, fixed now!
tapoueh··on Mastering PostgreSQL in Application Development
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...

tapoueh··on Mastering PostgreSQL in Application Development
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.
tapoueh··on Mastering PostgreSQL in Application Development
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!

tapoueh··on Mastering PostgreSQL in Application Development
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.

tapoueh··on Mastering PostgreSQL in Application Development
So that you can receive updates if I make some. You don't have to, though, read http://tapoueh.org/blog/2017/11/mastering-postgresql-in-appl... where you will find the full Table of Contents, or just buy the book ;-)