We've made excellent progress with writing an SQL script that both saves the history of all records in a PostgreSQL database and mirrors the primary tables to _history tables. #5 🎉
The code that has been written is not just "spike" (throw-away proof-of-concept), it's useable! 😮
There's no reason to not put in the extra effort to make this a production-ready Elixir package that we can start using in our projects and make available for others to do the same.
Todo
[ ] CREATE a small Phoenix project in the /test root directory
[ ] Run the spike SQL scripts in the Phoenix project
[ ] Confirm that the _history table is created
[ ] INSERT data into primary table and check that it gets added to the _history table
[ ] ALTER the primary table by adding a new column.
[ ] Confirm that the new column added to the primary table is mirrored to the _history table
[ ] INSERT another record into the primary table including the new column.
[ ] Confirm the record was mirrored to the _history table.
We've made excellent progress with writing an SQL script that both saves the history of all records in a PostgreSQL database and mirrors the
primarytables to_historytables. #5 🎉The code that has been written is not just "spike" (throw-away proof-of-concept), it's useable! 😮 There's no reason to not put in the extra effort to make this a production-ready Elixir package that we can start using in our projects and make available for others to do the same.
Todo
CREATEa small Phoenix project in the/testroot directory_historytable is createdINSERTdata intoprimarytable and check that it gets added to the_historytableALTERtheprimarytable by adding anewcolumn.newcolumn added to theprimarytable is mirrored to the_historytableINSERTanother record into theprimarytable including thenewcolumn._historytable.