Unconference - Stream 1 - 13:15-14:15 - PGCon 2022

Standardizing SQL: Challenges, Benefits, and Best Practices for a Faster and More Responsive Process

Key takeaways

The speaker mentions the challenge of deciding what features to remove from the SQL standard, citing the complexity of the standard and the need for a formal process to handle deprecation.
He suggests that the standardization process for the SQL standard is slow, and that it can take a long time for a proposal to be accepted.
The speaker also discusses the importance of transparency in the standardization process, and the need for clear communication and feedback from the community.
He highlights the potential benefits of standardizing more of the administrative features of Postgres, such as the ability to add custom aggregates and functions.
The speaker also mentions the need for a clearer distinction between the different levels of functionality in the SQL standard, and the importance of specifying what is and is not required.
He notes that the SQL standard is complex and has many moving parts, and that it can be difficult to keep track of what is and is not changing.
The speaker also discusses the importance of implementing features in a way that is backwards compatible, and the need for a clear migration path for users.
He suggests that the standardization process for the SQL standard could be improved by making it more flexible and responsive to the needs of the community.
The speaker also mentions the potential benefits of incorporating more domain-specific knowledge into the standard, and the need for a clearer understanding of what features are and are not relevant to the specific use cases.
He notes that the standardization process for the SQL standard is slow and bureaucratic, and that it can be difficult to navigate.
The speaker also discusses the importance of feedback and communication from the community, and the need for a clear and transparent process for submitting proposals and comments.
He suggests that the standardization process for the SQL standard could be improved by making it more accessible and user-friendly.
The speaker also mentions the potential benefits of standardizing more of the physical database design features, such as storage and indexing.
He notes that the SQL standard is complex and has many interlocking parts, and that it can be difficult to change.
The speaker also discusses the importance of preserving the integrity of the SQL standard, and the need for a clear and consistent set of rules and guidelines.
He suggests that the standardization process for the SQL standard could be improved by making it more collaborative and community-driven.
The speaker also mentions the potential benefits of incorporating more machine learning and AI-related features into the standard.
He notes that the SQL standard is complex and has many moving parts, and that it can be difficult to keep track of what is and is not changing.
The speaker also discusses the importance of implementing features in a way that is compatible with existing systems and architectures.

Unconference - Stream 1 - 13:15-14:15 - PGCon 2022

More talks