High on Cloud-9 with StratosDB

Intro:

We are entering a time of independent businesses! Nearly 30% of millennials are becoming entrepreneurs according to a case study done by OnePoll in partnership with GoDaddy. According to the Kabbage Small Business Revenue Index, small business revenue has grown by 52.76% since December of 2016. However, one of the biggest and most persistent obstacles for new businesses is the upfront costs of building and maintaining computer and server architectures.

In comes the cloud, which brings a business model of transferring the inherent operating costs of servers and databases to companies (e.g. Amazon, Microsoft) that have the capital to maintain them. These companies offered “digital real estate” to customers which ended up being revolutionary. Many small businesses do not have the means to invest the upfront costs inherent to building and maintaining a server. This abstraction of costs takes the burden away from small companies allowing them to prioritize their resources.

Among the wide variety of services offered by Amazon, AWS RDS is a service that is widely used as it allows for an abstraction of databases from businesses. This was largely beneficial because this meant that businesses no longer had to bear the burden of hosting and maintaining a database while also allowing them to utilize the army of talented Amazon developers to maintain their servers.

However amazing AWS RDS is, it is still just a database hosting service. The service itself doesn’t include software that allows for actual database creation, management, and optimization. Instead, AWS RDS database instances call for installations of third party applications for every database instance hosted on the cloud. At an even more granular level, a PostgreSQL instance requires an installation of pgAdmin or a complicated connection via the command-line interface.

Want to read this story later? Save it in Journal.

In order to tackle this issue, our team decided to create a web application that simplifies the process of connecting to AWS RDS instances and streamlines database creation, schema testing, and optimization, as well as making deployments more efficient. The result of our efforts culminated in what we call StratosDB!

What is StratosDB?

StratosDB was conceived with the intent to abstract the functionalities from third-party applications and combine them into a one-stop-shop for all the different AWS RDS database instances. As it stands now, StratosDB is focused on optimizing the database and schema building for the AWS RDS PostgreSQL instance. StratosDB has abstracted away from the complicated connection process to the AWS RDS instance by allowing the user to input their AWS RDS hosting information directly into the application through an interactive form.

StratosDB is a NodeJS web application that directly connects to AWS RDS instances with a streamline and stylish GUI that makes schema design, testing, maintenance, and deployment efficient. It sports a large built-in code editor that allows for easy schema design and editing while also supporting file imports that allow for direct .sql or .txt file uploads that inject the pre-written code into the code editor.

With this code editor, we make deployment to the AWS RDS instance extremely easy with a single button click. Once the AWS RDS instance has accepted the database entries, there is a query entry and testing component. This query component allows for query selections to be made for data retrieval as well as testing the performance of these queries within the newly created database table.

StratosDB also makes connecting to the AWS RDS instance extremely easy with an intuitive cloud connection modal as well as an easy to understand info modal that provides in-depth instructions as to how to use the application. Unlike regular command-line interfaces, StratosDB is designed with UX/UI optimization in mind. Even though StratosDB has a simple and intuitive design, it is a very powerful tool that allows for versatile and powerful database manipulation. StratosDB is a great tool as it allows web developers to use AWS RDS at a more efficient level without having to go out of their way to download third-party clients.

How to download or contribute to our Beta:

Team StratosDB will strive to continuously release updates and additional features. If you would like to contribute to this project: Please feel free to submit a PR to our GitHub! If you happen to come across any issues while tinkering with the application: Please report the bug/issue by submitting a ticket located in the Issues Tab in our GitHub. Feel free to visit our website!

Contributors: Tommy Song, Sophia Pak, Joal Kim, and Tyler Morgan.

There are many Black creators doing incredible work in Tech. This collection of resources shines a light on some of us:

--

--

--

Open source Software Engineer with a passion for new and cool tech!

Love podcasts or audiobooks? Learn on the go with our new app.

The rise of feature management in a product-centric world

Data is the new oil…yes, but how to store this oil?

Develop PHP packages strategy

Swift: Try, Try?, Try! and ‘Double Optionals’..

Practical example: Concentrated liquidity and capital efficiency in Uniswap v2 vs v3

AWS Well-Architected Framework and the famous “6 Pillars”

Create thumbnails from videos — Flutter

generate thumbnails from your videos flutter

Stop Trying to Make Fetch Happen: Or, Make It Happen with Dataloader + GraphQL

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Tommy Song

Tommy Song

Open source Software Engineer with a passion for new and cool tech!

More from Medium

Host Private Node.JS Packages on the Google Cloud with Artifact Registry

Serving a Node.js API on Amazon Elastic Kubernetes Service and CloudFront

How To Create A New GitHub Organization With An OAuth App Setup

Search as you type….. (AWS OpenSearch/ElasticSearch)