In this tutorial, we build a web app using a pre-existing database on a machine outside of Anvil.
The trick is to use an Uplink script to connect to the database - this is especially helpful if the database is inside a private network, since you don’t need to open the database ports to the outside world. The Uplink script provides a layer that allows you to expose only very specific queries to your web app.
ChaptersIn this tutorial, you'll:
Write a simple Python script to query the external database and get its contents as Python objects.
Call your Python script from the web browser using the Anvil Uplink.
Display your items in an interactive table online.
Edit your database rows from your web app, add new ones, and delete existing ones.
Click the following link to clone the finished app and explore it yourself.