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.
Mastering PostgreSQL in Application Development
81–90 of 101 posts
Re: Mastering PostgreSQL in Application Development
#82Re: Mastering PostgreSQL in Application Development
#83I'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?
Re: Mastering PostgreSQL in Application Development
#84Earlier 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…
Re: Mastering PostgreSQL in Application Development
#85Earlier 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!
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
#86I'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?
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
#87I'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…
Re: Mastering PostgreSQL in Application Development
#88Re: Mastering PostgreSQL in Application Development
#89I 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.
My recommendation is to just directly learn SQL instead.
Re: Mastering PostgreSQL in Application Development
#90Why do you need my email to see the table of contents?