RE: Is there a good discussion of optimizations?

From Guyren Howe >Actually, I’m mostly going to talk about the relational model, rather than >SQL. Our industry seems to always settle for third-best, and SQL is the worst >of all the examples of this. The world desperately needs a good relational >database based on a better query language — dat

Re: Is there a good discussion of optimizations?

On 1/7/21 2:48 PM, Guyren Howe wrote: On Jan 7, 2021, 13:42 -0800, Florents Tselai , wrote: Apologies for the shameless self-promotion :) Around a year ago I collected my thoughts on this topic. You can read the post here Modern Data Practice and the SQL Tradition

Re: Is there a good discussion of optimizations?

On Jan 7, 2021, 13:42 -0800, Florents Tselai , wrote: > Apologies for the shameless self-promotion :) > > Around a year ago I collected my thoughts on this topic. You can read the > post here Modern Data Practice and the SQL Tradition . > It looks like it resonated with a lot of folks in the commu

Re: Is there a good discussion of optimizations?

Apologies for the shameless self-promotion :) Around a year ago I collected my thoughts on this topic. You can read the post here Modern Data Practice and the SQL Tradition . It looks like it resonated with a lot of folks in the

RE: Is there a good discussion of optimizations?

On Jan 7, 2021, 13:07 -0800, Kevin Brannen , wrote: > From: Guyren Howe > > >Most folks, in my experience, who use relational databases don’t really > >understand the basic theory or even more important the why - the philosophy > >- of what a relational database is and how to get the most out of

RE: Is there a good discussion of optimizations?

From: Guyren Howe >Most folks, in my experience, who use relational databases don’t really >understand the basic theory or even more important the why - the philosophy - >of what a relational database is and how to get the most out of them. I see a >lot of folks trying to use SQL in an imperat

Re: Is there a good discussion of optimizations?

On Wed, Dec 23, 2020 at 6:56 PM Guyren Howe wrote: > I’d like to put together a good video and writeup about what the… > philosophy behind relational databases is. > > Most folks, in my experience, who use relational databases don’t really > understand the basic theory or even more important the

Re: Is there a good discussion of optimizations?

On Wed, Dec 23, 2020 at 05:55:57PM -0800, Guyren Howe wrote: > I’d be interested in any comments anyone has about useful things to discuss > here, and in particular I’m interested in an accessible discussion of the > sorts > of query optimizations Postgres can do for us. I have a few talks on thi