Engineering Speaks is where the SignEasy engineering brains stop by to narrate Explore the latest insights and ideas about technology and emerging trends from SignEasy’s top engineers.
stories of innovation, engineering culture and hacks that go behind ensuring the best user experience.

Switching Database Server Timezone to UTC

Since Signeasy’s inception in 2010, the database that powers our backend systems has been MySQL on Amazon Relational Database Service (RDS), which stores user and signature records. Each table in the database has relevant datetime columns (created time and modified time). Maintaining date and time information for events like document uploads, template uploads, signatures, and requests for signatures is essential to determine the documents’ status and the time taken to turn them around with completed signatures. The problem Historically, these…