Day 54 - MVP Done
Today, I made some updates to the extension tutorial by removing the PGXN-related documentation. I decided to cover PGXN separately in a different document to provide more focused and comprehensive information on the topic.
Additionally, I added two new ways of updating the extension in the tutorial. The first method involves using the ALTER EXTENSION
command, which allows for modifying the existing extension by adding new functionalities or making changes to the existing ones. This provides a convenient way to update the extension without the need for dropping and recreating it.
The second method involves dropping the extension using the DROP EXTENSION
command and then recreating it using the CREATE EXTENSION
command. This approach is useful when significant changes are required, and it ensures a clean slate for the updated version of the extension.
With these updates, I believe the basic SQL quick start tutorial is now almost complete. It covers essential topics such as extension creation, regression testing, packaging, and now includes information on updating the extension using different methods. I am satisfied with the progress made so far and confident that this tutorial will serve as a valuable resource for developers interested in creating SQL extensions for Postgres.
In the coming days, I will review and refine the content, ensuring its clarity and accuracy. I will also seek feedback from mentors and peers to gather their insights and suggestions for further improvements.