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
- Make sure you have sqlite3 installed to explore sqlite db before running this code
- Read the
main.py
file - 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:
- What is the longest-running movie?
- What movie has the most actors?
- What is the breakdown of top movies by rating?