Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Design

Posted by Max Teter
Max Teter
Courses Plus Student 1,046 Points

What language(s) to use for designing a GUI to view and edit a database?

Say I have a database in SQL. I want to design a simple but flexible GUI that allows users to take a set of orders off a sheet, and input the orders from the sheet to the database. The users have no programming knowledge, not even SQL queries. Eventually, I'd like to be able to have users be able scan the sheets, then have the orders automatically go to the database. What kind of language(s) would be good for this?

1 Answer

Alexander La Bianca
Alexander La Bianca
15,959 Points
Alexander La Bianca
Alexander La Bianca
15,959 Points

Depends if you want to make this a web app or a desktop app.

If you want to make this a web app, you can use just javascript on the client to build the UI. You will then need to hook that up to a backend service where you can send the data to. The backend service will then take care of inserting the data into the SQL database. I have done this several times by allowing a user to upload a csv file. The uploaded that is sent to my SQL database.

If you want to make this a desktop app you can use electron.js as your GUI and hook it up to the same backend service as above.

Hope this helps.