Live data from Hacker News

Mastering PostgreSQL in Application Development

masteringpostgresql.com

81–90 of 101 posts

Re: Mastering PostgreSQL in Application Development

#81
post #60

I like the idea of it targeting developers but aren't most developers going to end up using an ORM in the end? For example SQLALchemy in Python and ActiveRecord in Rails. Is the book a ton of SQL examples or general theory? Most of my day to day database activities as a web developer are creating good indexes, data modeling and setting up queries with an ORM.

I spent years in all sorts of ORMs and have sworn off them in favor of pure-SQL patterns like yesql (for Clojure) and massive-js (for Node.js). For me, the boilerplate of writing SQL queries is trivial compared to the productivity and performance inefficiencies of trying to understand and work around the magic of ORMs. Writing pure queries also encourages good practices like writing field lists in your SELECT statements and using more of Postgres' built-in functions.

Re: Mastering PostgreSQL in Application Development

#82
post #69

I've setup an Offer Code for the next 48h guys. Feel free to use it! http://masteringpostgresql.com/#packages

FYI. My attempt to use your gracious Offer Code on the payment form of the Full Edition, did not apply...

Fixed now!

Re: Mastering PostgreSQL in Application Development

#83
post #69

I've setup an Offer Code for the next 48h guys. Feel free to use it! http://masteringpostgresql.com/#packages

Thanks! That's awesome of you, but when I try to use it (as "hackernews") on the Enterprise Edition, the payment form's telling me it is invalid. What's up?

Went to fast and fat-fingered it. Works now!

Re: Mastering PostgreSQL in Application Development

#84
post #74
post #68

Earlier quoted context omitted.

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!

Is it aimed at developers from ground 0, or someone with 10+ years of experience? I've been working with both raw SQL and ORMs for a pretty long time. I'm definitely not at the DBA-tier and really complex queries scare the shit out of me but I haven't ever hit a complete roadblock when it came to modeling and querying data in a reasonably efficient way. With that said, an ideal book for me would be one that just show…

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 ;-)

Re: Mastering PostgreSQL in Application Development

#85
post #82

Earlier quoted context omitted.

FYI. My attempt to use your gracious Offer Code on the payment form of the Full Edition, did not apply...

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

#86

I've been wondering for a while about the practicalities of using postgres as a replacement or near-replacement for a traditional backend - does anyone have any opinions on how far it's wise to go with this (postgres-only? authentication? direct connections from the client?) and/or how feasible that kind of thing is?

A postgres backend is traditional isn't it ?

Am I that old that a relational database no longer traditinol, everything has come back round again now document stores are tradtional, and relational is new and trendy ?

Re: Mastering PostgreSQL in Application Development

#87
post #41

I've been wondering for a while about the practicalities of using postgres as a replacement or near-replacement for a traditional backend - does anyone have any opinions on how far it's wise to go with this (postgres-only? authentication? direct connections from the client?) and/or how feasible that kind of thing is?

Not sure that I would do authentication directly in PG (although it has many different methods [0]), I think it's still doable. You could move whole oAuth to PG through PL/SQL (maybe there is an extension for it?). I would also encourage to introduce a proxy in between (e.g. pgbouncer [1]) to help you to handle connections and deal with the authentication. We're using PG as "the brain" of our service since 2014 and i…

[deleted]

Re: Mastering PostgreSQL in Application Development

#88
post #83

Earlier quoted context omitted.

Thanks! That's awesome of you, but when I try to use it (as "hackernews") on the Enterprise Edition, the payment form's telling me it is invalid. What's up?

Went to fast and fat-fingered it. Works now!

Great, thanks again!

Re: Mastering PostgreSQL in Application Development

#89
post #60

I like the idea of it targeting developers but aren't most developers going to end up using an ORM in the end? For example SQLALchemy in Python and ActiveRecord in Rails. Is the book a ton of SQL examples or general theory? Most of my day to day database activities as a web developer are creating good indexes, data modeling and setting up queries with an ORM.

I have used PostgreSQL for 12 years. Early on I tried a few ORMs and I found them to be just something else to learn. If I had any issues, I had to figure out how it was all working on the SQL back end anyway.

My recommendation is to just directly learn SQL instead.

Post reply on HN