oslabs-beta / Stratosdb

StratosDB.io

StratosDB: An all-in-one tool for Cloud SQL

Table of Contents

• Beta Stage
• Overview
• Getting Started
• Main Features
• Built With
• Core Team
• License

Beta Stage

Team StratosDB will strive to continuously release updates and additional features.

1. If you would like to contribute to this project:

   • Please feel free to submit a PR

2. 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 within this repository

Overview

With the current trajectory of technological improvements, businesses and applications are moving towards a “serverless” architecture. With cloud computing becoming more reliable, it just makes more sense for businesses to take the “pay as you go and avoid upfront costs” approach.

Although cloud computing and serverless architecture has all these great qualities, not everything is rainbows and sunshine! Cloud services are still pretty new and user interfaces for these services are not very intuitive. Amazon’s AWS, itself, does not offer a platform that is intuitive for the users. The platform itself can be extremely confusing when using services such as AWS RDS. As such, third party applications are often used to alleviate these problems one at a time.

In response, our team decided that we wanted to tackle this issue by creating a tool that can be used for all AWS RDS database instances. We would like to introduce StratosDB, a one stop shop for users of AWS RDS to create, test, and deploy their RDS database instances! StratosDB offers a platform built on NodeJS that connects to your specific AWS RDS instance with a streamlined GUI that makes using AWS RDS much more simple and efficient.

Getting Started

1. Clone StratosDB to your local machine and point to the StratosDB directory:

   git clone https://github.com/oslabs-beta/StratosDB.git
   
   cd StratosDB
   

2. Install all required dependencies with the following script:

   npm install
   

3. Run the following script to open StratosDB on http://localhost:8080:

   npm run beta
   

4. Once StratosDB is opened on http://localhost:8080, click on the Cloud Icon (located on the Left Sidebar) and enter your AWS RDS Information and press Connect:

   User: Database Username
   Host: AWS RDS Endpoint Link *
   Database: Database name **
   Password: Database Password

* Sourced from AWS RDS Database Instance Dashboard

** If Database name was left blank when the AWS RDS Datbase Instance was created, use postgres

Main Features

Importing .sql & .txt Files

1. Click on the Import Icon (located on the Left Sidebar)
2. Choose the .SQL or .TXT file you would like to import
3. Select Import to populate your file's code base into the application's built-in code editor.

Schema Code Editor

Use the Schema Code Editor to input any psql command queries (EG. CREATE TABLE, INSERT INTO) to create/read tables and/or data entries from your tethered AWS RDS database

Query Text Editor

Enter your SELECT psql commands into the provided text editor and press Submit Query to initiate the performance analysis on your existing schema design

EG. SELECT * FROM TABLE_NAME;

Return Table

A scrollable table will render based on the SELECT query you have entered in the Query Text Editor

Visual Line Graph

A visual line graph representation will render the performance time (milliseconds) for each successfully performed SELECT query **

** You can hover over each point in the line graph to view the query that was ran and its corresponding the performance time (ms)

Information Modal

A dedicated modal (located on the Left Sidebar) guides first time users through the application's features in detail and provides more information about StratosDB

Built With

• React
• TypeScript
• CodeMirror
• React-ChartJS
• Node.JS
  • Express
  • Multer
• AWS RDS
  • PostgreSQL

Core Team

Joal Kim

Sophia Pak

Tommy Song

Tyler Morgan

License

This project is licensed under the MIT License