instead of deleting records from sqlite, lets add a `deleted_at` column that we set to the current time when a row is deleted. that way we can bring records back if needed. ### game plan - [ ] follow fastapi and argparse tutorial - [ ] learn basic sqlite usage in python (see provided resources from sce discord) - [ ] add a deleted_at column and a partial index so that deleted records arent taking up space in the `alias` column - [ ] open a separate pr to update the readme on how to do a migration for a sqlite file - [ ] open the pr with the sqlite changes
instead of deleting records from sqlite, lets add a
deleted_atcolumn that we set to the current time when a row is deleted.that way we can bring records back if needed.
game plan
aliascolumn