Rewrote my MS-Access programs that process the lotto data to use Python/PostgreSQL.
1) import.py – read lotto text file (containing all lotto numbers) and insert into PostgreSQL database.
2) summerize.py – read PostgreSQL lotto database and create summary database of all lotto numbers with number of times lotto number chosen.
3) summerize2.py – like above program except creates two summary databases for before/after lottery added numbers 50-53
4) FreqHTML.py – read the above databases and create the frequency HTML report.
5) lotto_batch.py – execute the above four programs in sequence. Takes < 5 seconds.