Ben, on project conception:
"If you're anything like me, you kind of hate SQL. It's not that I don't think it's good, but it is annoying. SQL has been what we use for database management for about 50 years and it has reigned nearly uncontested.
There's countless GUI's for interacting with your SQL database, but they all have one thing in common. They all require you to type your own queries. Now, if you're interacting with a database chances are you know what you are doing and that is not a huge deal, but developers often find themselves having to mentally change languages constantly. Remembering a language as finicky as SQL can be a real pain, especially if you are only making a minor change or check.
This project aims to create a point and click style of operation to maintaining a SQL database. This allows less experienced users to aid in maintenance in a low danger manner, as well as allows developers to carry out simple actions easily, without needing to change languages in their head."
Project is phase 1 development COMPLETE! This means all core features are built out and lightly bug tested.
It is now entering phase 2 development. A group of testers is being selected and will use the product for some time, compiling a list of bugs to before the next phase.
Phase 3 development will include UI/UX improvements and branding before full release.
Simply building the project will create a .exe file in the /bin folder, that can be opened normally. Your first window will prompt you for database connection string information. If the connection is successful, you will see a success message and the version info of the database you have connected to. Otherwise, you will see an error message.
-
Connection text fields for host, username, database name, password, host, and a nickname ( for storage purposes )
-
Option to save connection info to local database
-
Drop down box for saved connections
-
Button to forget a connection
-
File tab
-
Disconnect from database
-
Close program
-
-
Tables tab
-
Add table
-
Rename table
-
Delete table
-
-
Columns tab
-
Add column
-
Remove column
-
Rename column
-
Change data type
-
Add constraint
-
Remove constraint
-
-
Rows tab
-
Add row
-
Select row(s)
-
Update row(s)
-
Delete row(s)
-
- Dynamically display selected rows / columns
With the addition of another team member, our updates are now held in clickup
Chris really enjoys body building and playing video games. He also enjoys learning about machine learning concepts and taking online data science courses in his spare time. He have about 2 years of experience building Full Stack web applications using React and Node JS. He also have over 4 years of experience programming in Python.
-
or email at christopherc1331@gmail.com
Ben is an AZ native born into nerd-dom. He built his first desktop when he was 8 and seems only fit that he get into coding eventually. He is currently a junior .Net developer at Centuri Construction
-
His website
-
or email at whatsup@btwicode.com