Distributed Systems & SQL

Yes, all the folks who are working with big data must have heard this statement, but very few of them are aware of the real reason why parquet has the upper hand when it comes to storing nested data. It is the underlying architecture and hierarchical data model of parqeut which is making things easy for the nested data. This architecture of parqeut follows the Dremel paper published by Google. Here is the blog post which justifies the famous statement: https://blog.twitter.com/engineering/en_us/a/2013/dremel-made-simple-with-parquet

While writing sql queries there can be a lot of confusion when it comes to using single vs double quotation marks, especially in a database like PostgreSQL where both of them can not be used interchangeably (unlike MySQL) Even though it is very basic topic, it is very important and can having clarity on it can save a lot of time while writing and debugging the sql queries in PostgreSQL. Here's the link that i found that can reduce the dilemma upto an extent. https://streamofcoding.com/single-quote-vs-double-quotes-in-postgres/ Please feel free to add your thoughts or resources related to the topic in the comments.