Sadly, I’m unable to submit code this week because my project is taking much longer than expected, but I can show the start of the project and share a little about it. It’s a sql database editor(no name yet! any ideas?.. “Another Database Editor”?) .
What can it do? Not too much yet, but it can do the following:
Edit/create columns sqlite and postgres. Other databases can be connected if the interface I created is implemented).
Import table data from a CSV file(neat little class that uses a Regex to parse each data line from the file. It’s pretty fast too)
Uses a MVP(model-view-presenter) pattern to help organize the code and flow. Also an Observer pattern to “listen” the database messages and display them on the UI. Any database errors and successes are reported/logged to the bottom listbox with a timestamp.
It also uses the Canvas Listbox in two places that I’ve been working on and showing in previous Just Code challenges.
What I could not complete on time is the local sqlite file to store the databases that you want to manage… It would contain address/filepath, type, username, & password(if you want). The app will create the file if it doesn’t exist. It’s a whole app within itself.
Here’s a little preview: