economic policy as code - 008 - build a database

https://github.com/systemaccounting/mxfactorial
https://www.patreon.com/mxfactorial
https://www.paypal.com/paypalme/mxfactorial

*UPDATES*
2023-04-27
- docker compose manages postgres in docker
- secrets were moved from secrets manager to systems manager paramater store
- services/rules/src/sql/selectApproval.ts was moved to crates/sqls/src/lib.rs, https://www.youtube.com/watch?v=-rdm9-YzP0w&list=PLWTZbGMyrdcWhfa-VNOEOFB0b6t3wX22T&index=11&pp=gAQBiAQB
- services/rules/src/rules/multiplyItemValue.ts was moved to services/rule/src/rules/transaction_item.rs

0:00 intro
0:32: prereqs
0:55 start postgres in docker
1:04 configure postgres client connection
1:31 apply migrations
1:54 view tables added by migrations
2:01 test a sql query
2:13 add a migration
3:18 connect to rds
4:09 begin database schema tour
4:17 account and subaccount tables
6:25 account_owner table
7:25 account_settings table
7:32 publishing CityOfLosAngeles account activity
7:50 publishing Enron account activity
8:02 account_profile, industry and occupation tables
8:41 account_profile values enable transaction automation
8:59 account_profile values enable economic measurability
9:11 account_profile values improve justice
9:25 account_profile summary with privacy
9:47 costs vs benefits of accountability
10:36 empowering transparent leaders with accountability
11:35 item table
11:45 rule table
12:06 multiplyItemValue rule automates taxes
13:01 rule_instance table
13:38 enabling transaction automation and a DRY economy
14:14 NinePercentSalesTax rule_instance record demo
15:30 transaction table
15:46 transaction_notification table
15:55 transaction_item table
16:36 approval table
17:13 approval automation
17:44 eliminating market power with price data
18:08 account_balance table
18:15 websocket table
18:41 summarize schema, seed and testseed directories
19:02 tear down