From Rate Card to Database: Engineering UPS Shipping Rates Into a Multi-Carrier Logistics Platform published: false

An engineer integrated UPS shipping rates into a logistics platform by modeling a static shipping rate card into a queryable database. They caught schema design mistakes early and reduced 400+ database calls down to 4. This improved the platform's efficiency and accuracy. To implement this, they used Prisma as the ORM with PostgreSQL, defining a database structure in .prisma schema files. They created three tables: one for zones, one for country-zone mappings, and one for prices per zone and weight. This approach allowed for real-time querying of shipping rates.