Live data from Hacker News

Mastering PostgreSQL in Application Development

masteringpostgresql.com

91–100 of 101 posts

Re: Mastering PostgreSQL in Application Development

#92
post #80

I 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

#93
post #82

Earlier 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!

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!

Re: Mastering PostgreSQL in Application Development

#94
post #92
post #80

I 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.

Thank you kind sir. You dfinitely made me move forward with a purchase.

Re: Mastering PostgreSQL in Application Development

#95
post #77

tapoueh 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

#96
post #28

The “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…

It feels good!

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

#97
post #95
post #77

tapoueh 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!

Chrome still complains that the payment form is using non secure elements on the page but anyway I bought the book.

Re: Mastering PostgreSQL in Application Development

#98
post #56

It would be nice if I could buy it on Amazon.

I agree, I was disappointed not to find this on Amazon, would have bought if there, found another book with the same name though! I do ALL my reading on iPad Kindle app, thousands of books, I can’t be arsed to fill out forms to buy a book also other book or pdf readers I’ve tried have always been crap compared to kindle app.

Re: Mastering PostgreSQL in Application Development

#99
post #65

Earlier 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...

Or Sybase Open Server.
Post reply on HN