Infarma Sync

Sync main screen

Inspiration

Ten years ago, our retail customers used text files to exchange information between their stores.

What it does

Sync makes data exchange between stores and head office quickly without VPNs, fixed IPs, and any internet connection. All this in a maximum of 5 seconds.

How I built it

Java Spring Soap Webservices Application, PostgreSQL, AWS S3, AWS SQS for notifications and a Delphi client (service + windows admin app), own Transactional Message Queue Server.

Challenges I ran into

I have to build my own. The need of do not fire database triggers when importing data. Delphi SOAP webservices :( Database records that can not be registered in queue through database triggers. Database inconsistence.

Accomplishments that I'm proud of

Transactional Message Queue Server Inconsistent database tables auto recovery

What I learned

SOAP webservices are terrible to work with. Build my own Transactional Message Queue Server is very very difficult, but it shines now. PostgreSQL is gold and I love it even more.