Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Mastering PostgreSQL in Application Development

masteringpostgresql.com

Post reply on HN
Print view View original

71–80 of 101 posts

Re: Mastering PostgreSQL in Application Development

#72

Post by throwanem »

tapoueh wrote: 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?

Re: Mastering PostgreSQL in Application Development

#73

Post by throwanem »

ako wrote: post #65
pritambaral wrote: post #42

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

Why not? There's only so many use cases for a relational database - "everything old is new again", and all that.

Re: Mastering PostgreSQL in Application Development

#74

Post by nickjj »

tapoueh wrote: post #68
nickjj wrote: 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.

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 showed 100+ real world data modeling examples and how to query it in a bunch of real ways. Ideally an expert's thought process would be explained every step of the way. It'd happily pay $100+ for that just because I'm sure using it as a reference guide would save me enough hours in dev time to make it worth it.

Re: Mastering PostgreSQL in Application Development

#75

Post by Nican »

I have a curiosity: Some new SQL technologies, such as NuoDB, or MemSQL, chose to implement horizontal scaling by separating the data storage and transaction processing machines. I find this awesome because the data storage can scale independently from the heavy lifting of maintaining transactions and running big queries.

Additional machines can be added or removed from processing queries without having to scale the storage, and not have to worry about the complexities of data sharding, and data rebalancing.

Does anyone have experience with this kind of paradigm? Can PostgreSQL do something similar?

Re: Mastering PostgreSQL in Application Development

#76

Post by pvh »

Nican wrote: post #75

I have a curiosity: Some new SQL technologies, such as NuoDB, or MemSQL, chose to implement horizontal scaling by separating the data storage and transaction processing machines. I find this awesome because the data storage can scale independently from the heavy lifting of maintaining transactions and running big queries. Additional machines can be added or removed from processing queries without having to scale the…

Postgres doesn't have anything built in today, though a single node will comfortably scale to ... let's say somewhere between 100GB and 10TB depending on your use-case. Beyond that you can do read scaling with replicas, implement something with Foreign Data Wrappers, or hand-roll a sharding solution and stay on vanilla.

Alternatives to the DIY approach include open-source things like Postgres-BDR, CitusData, TimeScaleDB or closed-source single-vendor things Amazon Aurora, and RedShift.

Re: Mastering PostgreSQL in Application Development

#79

Post by kidfiji »

sumedh wrote: 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?

If you click through the links to purchase, you'll be able to see that purchasing his books are through third-party distributors which are all secure.
Post reply on HN