Storing News in a Database

In this tutorial, we’ll take a tour of Anvil and build a simple news aggregator. We’ll start from a blank page, and build up to a web app complete with database storage and deployed on the web - all in nothing but Python.

This is also known as a CRUD app, named after the Create, Read, Update and Delete operations.

The final app will look something like this:

screenshot of the completed app

The techniques you’ll learn in this tutorial are fundamental to building any Anvil app, and mastering them will give you a good understanding of how Anvil works.

You don't need any prior experience with Anvil or web development to complete this tutorial.

All you'll need is a little bit of Python. If you’re new to Python, here are some resources to help you get started.


Chapters

In this tutorial, you'll:

Build your user interface

Build a User Interface (UI) to add and edit the articles.

Write client-side Python

Write some client-side Python code to populate the Categories dropdown from the database.

Add news articles to the database

Create: Save the article information that the user enters.

Update existing articles

Update: Modify existing articles using your app.

Challenge yourself

Extend your app and modify its appearance.

Click the following link to clone the finished app and explore it yourself, or read on as we take a step-by-step guide to building it yourself.

If you prefer a more theoretical approach to learning, you can dive straight into the documentation.