Understanding database connectors, triggers, and actions

If you’re not familiar with databases, that’s ok! While designing scalable database systems can be quite complex, the general concepts of databases are relatively simple.

Databases are typically made up of tables, columns, and rows. You can think of a simple database as a collection of spreadsheets, where the spreadsheet itself is the table, and then the rows and columns in the spreadsheet represent rows and columns in the database.

When reading or writing to a database, you need to tell the application some key details:

• The server name or address
• The database name
• Authentication credentials

This information is stored in a connection object or connection string and tells the application how to locate the database. Later, when performing actions such as queries, inserts, or updates against a database, you will specify additional details such as table names and filters to...