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 actually pretty simple.Databases are typically made up of tables, columns, and rows. You can think of a simple relational 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. The spreadsheets can then be linked together by a key (a property that each spreadsheet has in common). A primary key ensures each row is unique, while a foreign key is used to establish relationships by referencing a primary key in another table (or spreadsheet, keeping with our example).Databases don't often exist in a void—most people or systems typically interact with the data in a database through an application. When reading from or writing to a...
