Welcome to the world of StratosDB, a powerful tool designed to simplify your interactions with AWS RDS databases. If you’ve ever felt overwhelmed by complex user interfaces and the intricacies of cloud computing, you’re in the right place. This guide will walk you through the process of getting started with StratosDB, addressing common issues, and ensuring your experience is seamless.

Table of Contents

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

Getting Started

To begin your journey with StratosDB, follow these simple steps:

1. Clone StratosDB to your local machine and navigate to its directory:

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

2. Install all required dependencies:

npm install

3. Run StratosDB on your local server:

npm run beta

4. Open your browser and navigate to http://localhost:8080. Click on the Cloud Icon on the left sidebar, then enter your AWS RDS information:
• User: Database Username
• Host: AWS RDS Endpoint Link
• Database: Database name (if empty, use postgres)
• Password: Database Password

Main Features

StratosDB boasts a range of features designed to enhance your experience:

Importing .sql and .txt Files

1. Click on the Import Icon on the left sidebar.
2. Select the .SQL or .TXT file you wish to import.
3. Click Import to load your code into the built-in code editor.

Schema Code Editor

This feature allows you to input psql commands to create, read, and manage your database and its table structures.

Query Text Editor

Here, you can enter your SELECT psql commands and press Submit Query for performance analysis on your existing schema design.

Return Table

A scrollable table displays the results of your SELECT queries, making it easy to review your data.

Visual Line Graph

Gain insights into query performance with a line graph that visualizes execution times, allowing you to hover over points for details on specific queries.

Licensing and Development

This project is open-source and licensed under the MIT License, encouraging contributions from developers interested in enhancing StratosDB.

Troubleshooting

If you encounter any issues while using StratosDB, check the following solutions:

• Ensure all dependencies are correctly installed using npm install.
• Double-check your AWS RDS configurations, including username, password, and host link.
• If the application fails to launch, verify you are in the right directory and have the correct permissions.
• For any bugs or issues, head over to the Issues Tab in the repository to report detailed information about the problem.
• For more insights, updates, or to collaborate on AI development projects, stay connected with fxis.ai.

At fxis.ai, we believe that such advancements are crucial for the future of AI, as they enable more comprehensive and effective solutions. Our team is continually exploring new methodologies to push the envelope in artificial intelligence, ensuring that our clients benefit from the latest technological innovations.

Now you’re ready to explore the depths of StratosDB and elevate your cloud database management experience!