Exploring the World of Databases and Open-Source Collaboration: My First Month as a SWE Intern at Bitnine Inc.
Tags: age, postgres, database, backend
Published: 2023-08-31 18:29:23

As I embarked on my internship journey at Bitnine Inc., I knew that I was about to dive into a world of databases, open-source collaboration, and cutting-edge technologies. The on-boarding period was designed to be a comprehensive curriculum, equipping me with the knowledge and skills necessary to thrive in the realm of database technologies. From PostgreSQL to IvorySQL and AGE, each module offered a unique perspective and an opportunity for growth. Here, I'll take you through my journey during the first month, highlighting the key takeaways and the excitement that lies ahead.

## Week 1: Laying the foundation
The first week laid the groundwork for an exciting trip ahead. I looked explored AGE, a PostgreSQL extension that combines the power of relational databases with graph databases. I set up my developer environment by following the AGE on-boarding guide, learning the fundamentals of PostgreSQL—a key component of AGE. This first step was critical since it introduced me to the environment, tools, and seamless integration that would be needed for subsequent activities. Understanding the relevance of PostgreSQL set the stage for a more in-depth examination of AGE's components.

## Week 2 & 3: Delving Deeper
The next two weeks were spent delving into PostgreSQL internals, advanced training, version control, and a variety of database technologies such as AGE, IvorySQL and AGE Viewer. Let's go over the highlights:

**PostgreSQL Insights**: I gained a thorough understanding of this powerful open-source relational database management system by unraveling the intricacy of PostgreSQL's internals. I gained understanding of the fundamental components, from internal structure to query execution. During this time, one essential skill I learned was how to optimize PostgreSQL databases.

**AGE and AGE Viewer Exploration**:: I became familiar with graph databases and data visualization through my exploration of AGE and its visualization tool, AGE Viewer. I was captivated by AGE's seamless integration of relational and graph processing abilities. With the help of its own cypher query language, I was able to efficiently query intricate data relationships. On the other side, AGE Viewer simplified complex data linkages into understandable interactive images.

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/qq3yfz9losmkzcf9xhju.jpg)

**IvorySQL Unveiled**: IvorySQL, an Oracle-compatible PostgreSQL, intrigued me with its versatility and unique features. As a drop-in replacement for the latest PostgreSQL, its commitment to compatibility was impressive. Learning about the PL/iSQL procedural language and its Oracle-style Packages expanded my understanding of database systems.


![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/irsmhpkprm03zkongqxz.png)

**Version Control and GitHub Mastery**: My prior knowledge of version control was reinforced through GitHub. Understanding version control's role in collaborative development and refreshing my knowledge of GitHub conventions was a valuable refresher.

## Week 4: Reflecting and Looking Forward
The final week of my first month was a time for reflection and planning. In a lengthy report, I summarized the depth of my knowledge by synthesizing my ideas and findings. This report not only confirmed my knowledge, but it also marked the beginning of a new chapter in my search.


I'm optimistic about the future as I look back on this first month. The solid foundation in different database systems, along with knowledge of open-source collaboration and cutting-edge tools, has sparked a thirst for research. The promise of tools like IvorySQL and AGE, the complexity of databases, and the importance of collaborative platforms like GitHub have created the conditions for ongoing development. As I eagerly look ahead, I'm filled with gratitude for the opportunity and enthusiasm for the challenges that await.