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