Skip to content

Instantly share code, notes, and snippets.

@kevincolten

kevincolten/index.md

Last active July 1, 2020 13:35
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save kevincolten/20fe55c8d24e90400fe108f122f04784 to your computer and use it in GitHub Desktop.
Save kevincolten/20fe55c8d24e90400fe108f122f04784 to your computer and use it in GitHub Desktop.
Download ZIP
Vandelay Software Developer Test
Raw
index.md

Vandelay Education Software Developer Challenge

Build a SQL GUI in the browser that can save queries

Documentation

You can refer to this old SQL workshop for documentation on the sample sqlite database. Play close attention to the Online SQL Interpreter, also located here. That's similar to part of what we want to build!

Specs

  1. Here's the database we want to query. Click download.

  2. We want to build a SQL browser similar to the one linked. No rules here, just a text box that takes some SQL and runs it on the sample database, either on the front end or by making a server call. Use whatever out of the box libraries you want. Don't spend time on making it too pretty, just make sure it works from a mobile and desktop browser with basic responsiveness.

  3. The feature we really want to add is a way to save past queries. We'll need a backend that somehow saves the queries, can pull them up, and inject them into the textbox to run. Your choice of whatever technology there. We use a lot of Node.js/Express.js, MongoDB, MySQL, DynamoDB, etc.

  4. Add user accounts with a password so different users can save their own queries.

  5. Get this sucker hosted and share the source. Have steps in the README.md about how to get it started locally if needed.

  6. Solve those sample queries!

Here's a wireframe for inspiration

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment