Web Data with SQLite
Create and publish a dynamic web app
Apps we need
We use a wide selection of tools in this course.
Let’s quickly discuss what they are each for.
We’re building a website, so a web browser is critical!
We recommend Google Chrome and use it for demos.
Used for working with databases visually.
This app is free and cross-platform.
Command Line Tools
We also need some tools installed which
can only be used from the shell.
The latest version of SQLite works really nicely
with Python, so we’ll use it for our app.
Python will be the “back-end” of our website,
communicating between our web page and database.
Flask is a framework for Python which makes
it easier to build websites with databases.
Flask Login is a plugin for Flask which makes
user login and session management easier.
This part is optional, but could be a handy
service for designing visual database plans.