Chapter 4. Databases
In this chapter, we present a few examples of Tornado web applications that make use of a database. We’ll begin with a simple RESTful API example, then move on to creating a fully functional version of the Burt’s Books website introduced in Templates in Practice: Burt’s Books.
The examples in this chapter use MongoDB as the database, and pymongo as the Python driver to connect to MongoDB. There are, of course, many database systems that make sense for use in a web application: Redis, CouchDB, and MySQL are a few well-known options, and Tornado itself ships with a library for wrapping MySQL requests. We choose to use MongoDB due to its simplicity and convenience: it’s easy to install and integrates well with Python code. Its schemaless nature makes it unnecessary to predefine your data structures, which is great for prototyping.
We’re assuming in this chapter that you have a MongoDB installation running on the machine where you’re running the example code, but it’s easy to adapt the code to use with MongoDB running on a remote server. If you don’t want to install MongoDB on your machine, or if there isn’t a MongoDB binary for your operating system, there are a number of hosted MongoDB services you can use instead. We recommend MongoHQ. In our initial examples, we’ll assume that you have MongoDB running locally on your machine, but it’s easy to adapt the code to use with MongoDB running on a remote server (including MongoHQ).
We’re also assuming you have some experience ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access