Open dev.cfg and find the appropriate commented line for the SQL
implementation you will be using. For this tutorial I will use SQLite
because it uses a local file instead of a server connection:

sqlalchemy.dburi="sqlite:///home/username/tutorial/tutorial.sqlite"

Note

If you choose SQLite, the URI must be an absolute path. And of
course, you’ll need SQLite installed.

Note

The alternative is:

sqlalchemy.dburi="sqlite://%(current_dir_uri)s/devdata.sqlite"

%(current_dir_uri)s is a TurboGears config shortcut for current path.

To define your database tables, open the existing file
tutorial/model.py. TurboGears uses Elixir over SQLalchemy for database abstraction.
In Elixir, classes represent tables and class attributes represent
columns. Since I’m making a to-do list application, I added the following
classes in tutorial/model.py: