Inspiration
As someone who is new with Openshift Technologies, Its not easy for me to get all task done even after reading some Openshift Documentations. I need to create my app and manage it via Mysql database user interface with ease instead of using Openshift CommandLine. I guess this application will also help Developers especially PHP Developers who are new to Openshift to easily connect and manage their Mariadb or Mysql Database within Openshift Cloud without learning a single line of Code...
What it does
Openshift Mysql Admin is a super advanced ajax based installable tools for managements of Openshift Mysql Admin Cloud Database Clusters. Developers, Bloggers, Companies etc can install it locally or online on their servers for easy management of Openshift Mysql Database.
It leverages both Users Graphic Interface and SQL Interface to allow Users to manage their various Databases and its table within their respective Openshift Mysql Database Clusters.
The User Graphic Interface allow users to manage their Openshift Mysql Database without learning any single SQL Command Eg. Admin Can
Create Database
List Databases
View Database Character Set and Collation Type
Drop Database
List all Table in the Database
Access Various Tables
Renames Tables
Drop Tables
View Table Structures and Schema
View Table Contents
Delete table rows
and Much More without learning any SQL Command
.
SQL Interface is design for developers and Admin that has knowledge of SQL Command. This SQL Interface allow users to perform any data manipulation on Openshift Mysql Clusters. Eg: Admin Can CREATE anything DROP, ALTER, UPDATES, RENAME and much more. Just Try any SQL Command. We got you covered.
There is an also an SQL Error Tracking that will tell you what is going wrong if there is any issue with your SQL Command. The SQL Command also supports Multiple SQL Transactions.
Import SQL File
This components allow Admin to easily Upload Database SQL Files and then Import it to Openshift Mysql Cloud Database. The Database SQL File will first be Uploaded to a directory temp_uploads before being imported to Openshift Mysql. Upon importing to Openshift Mysql, the SQL File will be automatically deleted from the directory to free up your space.
Openshift Mysql Backup & Download System:
This option allow Admin to easily backup their Database Files from Openshift Mysql Cloud and then Download it.
Application perform this action by first allowing Admin to choose Openshift Mysql DATABASE to backup. The Openshift Mysql Database is backed up to a directory db_backup thus allowing users to easily download the cloud backup SQL Files. Admin can also delete the backup SQL Files anytime from the directory.
How Install and Run the Application on Openshift
This application was written in PHP.
1.) Goto your Openshift Developer Sandbox Account and Login
2.) Goto OpenShift command line terminal
3.) Create persistent Database by running this Command oc new-app mariadb-persistent This command will create a persistent database called sampledb then copy the generated mysql database credentials.
Goto the application source code and locate data6rst.php file and update your Mysql Credentials where appropriates.
Run oc status to get the status of your application and also get Mariadb host connection Ip address and port no for your app mysql database connections
4.) Import and run the app from github by typing oc new-app php~https://github.com/areaboy/codeshiftapp1
5.) Run oc logs -f buildconfig/codeshiftapp1 to track its progress.
6.) Run oc expose service/codeshiftapp1 to expose your app to public
7.) Run oc get routes to get your application url
How we built it
Built with PHP and OpenShift.
License: Open Source(MIT)
https://opensource.org/license/mit/
What's next for Openshift Mysql Admin
1.) Table Pagination's
2.) Table Editing/Inline Editing.
3.) Table Content Search Engine.
4.) 2 way Factor Authentication Via Email/Phone Number
5.)Users and Privileges: This Privileges will enable Admin to control what Database and Table its User/Team can Access. For Instance, Admin can grant CREATE, DELETE, UPDATE etc. any Table privilege to User Fred. Admin can grant any permission on any table Databases etc to its users. Eg. Any User with CREATE can create table, create database etc.
This System will also have a notification and audit log that notifies admin about all database activities of each user.
Upon each user creation, Application will send them Email with link and information on how to signup and much more.
6.) Openshift Mysql Admin File Manager with Amazon S3: Admin can create Amazon S3 Objects Buckets to Backup, Exports and Import SQL Files to and from Openshift Mysql Cloud Database System..
Log in or sign up for Devpost to join the conversation.