Comment by SparklyCircuit

With my small team we're working on a dense integration layer between client data, bank statements, and invoices along with dedicated software in cooperation with accountants to simplify flow of data from independent payment processors and pairing appropriate payments with corresponding invoices in one database, in code.

This project makes use of existing database infrastructure and parses data from multiple banks including caveats and quirks of some banks improper handling of data.

This project aims to ease the work of accountants and administration as currently a lot of correcting mistakes and pairing to the correct invoice is done manually.

The project is made in python however the modularity we set ourselves to implement allows for quick, easy and hassle free corrections of code with use of project schematics, like builders, dependency injections etc. Discovered a great tool for running tests efficiently https://docs.astral.sh/uv/ .

Also for data retrieval from a remotely located database. DO NOT USE pyodbc, USE mssql library. pyodbc is unoptimized in terms of receiving high amounts of streamed data, it can't keep up. That alone has dropped the time of execution from 18 minutes down to about 20 seconds.

Also making use of typer and data classes for ensuring correct types of data.