Skip to content
Interview assignment
Branch: master
Clone or download

Latest commit

byrdal Merge pull request #3 from byrdal/master
Specify how link to repo is to be provided
Latest commit f461161 Oct 19, 2017

Files

Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
README.md Comma Oct 17, 2017
sqldump.sql

README.md

Job interview assignment

We kindly ask you to solve the task below. By solving and submitting this assignment you provide us with insights in how you solve real-world problems. What we will be looking at are topics such as: choice of technology, structuring of code, use of VCS, selection of 3rd party libraries, documentation etc.

The task

Develop a solution that, given a select query, can read data from a database, write it to a local file and then delete the data from the database. The solution should verify that data is written to the file, and that data integrity is maintained, before deleting it from the database.

  • Use Bash, PHP, JavaScript or Go as the language
  • Use MySQL, MariaDB, CockroachDB or SQLite as the database

Please use the data set provided in the SQL dump in this repo. Please also consider that your solution should be able to handle much larger data sets.

Expectations

Make a copy of this repo. Solve the task below. Push your code to a public repo, and send us the link as a reply to our email.

Your solution should include a short readme describing your solution, how to use/test it and any final considerations such as known errors, next steps, security concerns etc. Don’t worry we are not expecting this thing to be perfect.

You can’t perform that action at this time.