gaynetdinov / ex_money

An [abandoned] self-hosted personal finance app
ISC License
167 stars 12 forks source link

Move `TransactionInfo` table to `extra` column in `Transaction` #87

Closed gaynetdinov closed 7 years ago

gaynetdinov commented 7 years ago

Heroku today sent me a notification which says that my postgres db has ~8k rows out of 10k rows allowed on free plan. So I came up with a simple solution how to remove ~2k rows. In fact, storing extra as jsonb even simplified the code in some places. The next step would be to get rid of accounts_balance_history table somehow. In order to migrate existing entries in transactions_info table, run heroku run mix ex_money.migrate_transactions_info.