I've setup an Offer Code for the next 48h guys. Feel free to use it! http://masteringpostgresql.com/#packages
Mastering PostgreSQL in Application Development
91–100 of 101 posts
Re: Mastering PostgreSQL in Application Development
#92I wish there was a discount code for the Dead Tree Edition. I have a lot of trouble focusing on reading PDFs on my computer versus having a physical book in front of me. And I don't have a tablet, unfortunately.
Re: Mastering PostgreSQL in Application Development
#93Earlier quoted context omitted.
Fixed now!
One request :) Please consider a Fully Dead Edition. It would give access to all the digital content, but include a paper version of the book. Thanks!
Re: Mastering PostgreSQL in Application Development
#94I wish there was a discount code for the Dead Tree Edition. I have a lot of trouble focusing on reading PDFs on my computer versus having a physical book in front of me. And I don't have a tablet, unfortunately.
FWD15 gets 15% off, which basically negated the price of shipping for me.
Re: Mastering PostgreSQL in Application Development
#95tapoueh why are you not using https on your site? I want to buy the book but not sure if I should enter my card details on a non https site?
Re: Mastering PostgreSQL in Application Development
#96The “dead tree edition.” Good play, sirs. I’m going have to get that one though. I can’t seem to focus/finish when reading educational books on my kindle or in PDF form. I like the “turn thousands of lines of code into queries”... I can’t count the number of times I’ve seen application code doing something a query could do either to appease an ORM or because a backend engineer wasn’t fluent in intermediate SQL.
Yeah... i'm totally guilty of abusing the 'python can do it' hammer instead of leveraging the DB. Just last week i looked at an old snippet of code that was essentially a 'query data, load in python, process, shove back in postgres' workflow. I was like, AHA i know better. spent 15 mins figuring out how do accomplish the same thing in the database. Now that shitty code is gone, replaced with 1 SQL statement that runs…
I had a rails/ar based report that I "fixed" at my last job that when it ran it generated 1100 reads (not even N+1, a lot of other crazy aggregates, etc).
It was complicated, but I got it into one query, subquery and a partition.
Went from 45s of app time to process to a <1s query!
Re: Mastering PostgreSQL in Application Development
#97tapoueh why are you not using https on your site? I want to buy the book but not sure if I should enter my card details on a non https site?
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!
Re: Mastering PostgreSQL in Application Development
#98It would be nice if I could buy it on Amazon.
Re: Mastering PostgreSQL in Application Development
#99Earlier quoted context omitted.
This depends a lot on the usecase. You have to consider things beyond the simple serving of requests, things like rate-limiting, caching, logging, event tracking, for example. About a year ago I designed a system for a client that was just Postgres with a Go http frontend. Go was used to handle http requests and responses, to translate the API from http to postgres functions/views, and serve the response straight fro…
Sounds like client-server development on oracle 20 years ago...
Re: Mastering PostgreSQL in Application Development
#100Launched today, and already has the best sellers package.