We learned a lot in this chapter about using a database to store persistent data.
Specifically, we covered:
The benefits of using a database engine
How to use SQLite, a database engine distributed with Python
How to implement a password database
How to design and develop a database-driven tasklist application
How to implement unit tests with Python's
unittest
moduleHow to make a web application more responsive using AJAX calls
We also discussed how to make a web application respond to mouse clicks and request new data from the server without using <form>
elements but using jQuery's click()
and live()
methods.
Now that we've made the first step in using a database, we're ready to create more elaborate databases designs, consisting of more than a single table, and look at the methods to define relations between these tables – which is the topic of the next chapter.5