-
-
-
darold/pgFormatter
A PostgreSQL SQL syntax beautifier that can work as a console program or as a CGI. On-line demo site at http://sqlformat.darold.net/ - darold/pgFormatter -
Squishing your multiline SQL queries for cleaner log output
When you are developing a complex Ruby on Rails application, you might need to write a few SQL queries and avoid using Active Record and… -
-
Spark 实践 | Spark SQL 查询 Parquet 文件性能提升 30%,字节跳动是如何做到的?
本文为《Improving Spark SQL Performance by 30%: How We Optimize Parquet Filter Pushdown and Parquet Reader》分享,作者是字节跳动的孙科和郭俊。 -
一文终结SQL 子查询优化
子查询(Subquery)的优化一直以来都是 SQL 查询优化中的难点之一。关联子查询的基本执行方式类似于 Nested-Loop,但是这种执行方式的效率常常低到难以忍受。当数据量稍大时,必须在优化器中对其进行去关联化(Decoorelation 或 Unnesting),将其改写为类似于 Semi-Join 这样的更高效的算子。 -
-
-
-
-
-
SQL 子查询的优化
前人已经总结出一套完整的方法论,理论上能对任意一个查询进行去关联化。本文结合 SQL Server 以及 HyPer 的几篇经典论文,由浅入深地讲解一下这套去关联化的理论体系。它们二者所用的方法大同小异,基本思想是想通的。 -
-
Directus: Open Data Platform for Headless Content Management
Directus is an open-source Headless CMS with the flexibility and power of a Data API. It allows managing both content and raw data, in any new or existing SQL database — keeping all your data pure, organized and portable, end-to-end.