sqlite-python-connect

Short bit of code to connect to a sqlite db and run a query.

About the datastore

This is a database of the top 250 movies from the Internet Movie Database (IMDB). For simplicity's sake, it is not fully normalized. We will not be using this particular dataset during your onsite, but you can use it to familiarize yourself with SQLite and make sure you can access it from your preferred language.

some steps to take

1. Make sure you have sqlite3 installed to explore sqlite db before running this code
2. Read the main.py file
3. Run the main.py file (python main.py)

Preparing for the onsite

We want you to feel prepared for the on-site. Before you arrive, be able to answer the following questions:

1. What is the longest-running movie?
2. What movie has the most actors?
3. What is the breakdown of top movies by rating?