Day 11 - Back to Basics

Today's focus was on revisiting the fundamentals of Postgres extension development. By going back to basics, I aimed to gain a comprehensive understanding of the essential elements required for creating a Postgres extension. Throughout the day, I delved into the documentation, conducted research, and made significant progress towards building a solid foundation for my project.

My journey began with an in-depth exploration of the Postgres documentation, where I discovered that the core elements for developing a Postgres extension are a control file and a SQL script file. Understanding the significance of these files, gathered insights and best practices for their implementation.

To streamline my project organization, I created a dedicated folder within my repository called "Basic." This folder serves as a repository for definitions and code snippets associated with the control file and SQL script file. By compartmentalizing these essential components, I can easily reference and modify them as needed.

During my research, I also devoted time to understanding the makefile, an integral part of the extension creation process. Exploring the makefile's purpose and structure, and how it facilitates the compilation and installation of the extension.

As the day drew to a close, I made significant progress on the project by thoroughly researching the control file and SQL script file. Tomorrow, I aim to complete the remaining tasks, including finalizing the SQL and control files.