preloader
軟體工程 Tricky number operation between SQLite and MySQL

Important: The result of 10/110 in SQLite is 0 and different with 0.09090909 when manipulating in MySQL. When testing Laravel Eloquent ORM both at local machine with SQLite and at remote machine with MySQL, you will find some execution results don’t same as expected at local machine. That’s is because SQLite won’t transform integer to real number automatically. Workaround: Add multiply 1.0 to ORM SQL statement and it becomes portable

read more

About

Howard Lee is a Staff Software Engineer based in Taipei, specializing in frontend architecture, CI/CD, and production-quality engineering for enterprise web applications. With 13+ years of software development experience, Howard has worked across B2B SaaS, IoT energy-management platforms, online travel marketplaces, and Android applications. His work focuses on modernizing large frontend systems, improving delivery quality, and building reliable product workflows with automated testing, observability, and practical cloud/platform integration. Core Expertise Frontend architecture: Angular 5 to 19 modernization, TypeScript, JavaScript, React, Next.

Know More

Tag

Social